Job Summary: The Data Flow Engineer's primary role is to create and manage data connections, perform validations, and execute transformations. Their work is integral to the ongoing process of iterative improvement, with a particular focus on enhancing auto-reconciliation within the system through advanced technology.
Responsibilities: - Import and validate file delivery for new clients.
- Automate daily process monitoring and reporting.
- Establish connections through external APIs and FTPs.
- Ensure timely and dependable consumption of external portfolio data.
- Normalize external datasets into a standardized Clearwater format facilitating the in-take process.
- Mine data from existing feeds to identify, design, and implement solutions to improve auto-reconciliation.
- Execute improvements requested from Operations and Development groups.
- Apply acquired skills, procedures, and decision-making best practices to complete various issues, such as normalizing new feeds and improving automation.
- Understand and reference or explain the general workflow, tools, and Clearwater value proposition.
- Use critical thinking to address issues and offer solutions for both internal and external parties, ensuring best practices are employed.
- Clearly and effectively communicate the technical aspects of Clearwater systems and our best practices with non-technical internal and external stakeholders.
- Engage in light on-call duties.
Required Skills: - Securities, accounting, and financial experience.
- Strong understanding of SQL and relational database principles.
- Experience with scripting programming languages like Groovy, Perl or Python.
- Experience with industry-standard data transmission protocols preferred.
- Securities, accounting, and financial experience preferred.
- Strong computer skills, including proficiency in Microsoft Office.
- Excellent attention to detail and strong documentation skills.
- Outstanding verbal and written communication skills.
- Strong organizational and interpersonal skills.
- Exceptional problem-solving abilities.
Education and Experience: - Bachelor's degree in Math, Computer Information Systems, or other relevant degrees.
- 4+ years of relevant experience.
- Experience with industry-standard data transmission protocols.
Location : This position is based in Boise, ID
What we offer:- Business casual atmosphere in a flexible working environment
- Team focused culture that promotes innovation and ownership
- Access cutting edge investment reporting technology and expertise
- Defined and undefined career pathways allowing you to grow your own way
- Competitive medical, dental, vision, and life insurance benefits
- Maternity and paternity leave
- Personal Time Off and Volunteer Time Off to give back to the community
- RSUs as well as employee stock purchase plan and 401k with match
- Work from anywhere 3 weeks out of the year
- Work from home Fridays