Associate Data Movement Engineer; Talend - Contractor

Job title:
Associate Data Movement Engineer (Talend)
Location:
New Haven, CT (Prefer hybrid but open to remote for the right candidate)

We are embarking on the modernization of its core data platforms. We are currently seeking an Associate Data Movement Engineer who can assist us with modernizing our current ETL environment, as well as building new ETL/ELT workflows and data pipelines as we move towards a cloud environment. The Associate Data Movement Engineer will support our data architects, data analysts, and business intelligence developers on various data initiatives.

They must be self-directed and comfortable supporting the data requirements of multiple teams and systems. The ideal candidate will also possess experience in the data management domain and be willing to contribute their technical skills and experience towards the development and support of elegant and efficient data processes and systems.

• Complete full life cycle of ETL/ELT development to address business needs or resolve issues including design, mappings, data transformations, scheduling and testing
• Translate data movement requirements into technical designs
• Develop data extraction and transmissions to external vendors
• Develop test plans and perform unit testing. Create supporting documentation for new processes
• Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements
• Contribute to architectural decisions to support business processes
• Provide production support for data solutions
• Complete RCA and contribute to remediation planning and implementation
• Perform data quality analysis, report data quality issues and propose solutions for data quality management
• Prepare effort estimation of software development and unit testing
• Monitor ETL workflows and streaming jobs across Talend, Airflow, and ESP environments
• Investigate and resolve data load failures, performance issues, and data quality anomalies
• Perform RCA and implement corrective and preventive actions
• Develop and maintain ETL jobs using Talend and support legacy BODI workflows
• Collaborate with data engineers to optimize pipeline performance
• Implement data validation, cleansing, and reconciliation logic
• Work with business analysts to ensure data accuracy and completeness
• Support data audits and compliance initiatives
• Manage and enhance job orchestration using Airflow
• Ensure timely execution of data workflows
• Automate routine support tasks and improve monitoring capabilities
• Liaise with business users, application teams, and data architects to resolve issues and gather requirements
• Maintain detailed documentation of ETL processes, job schedules, and issue logs
• Contribute to knowledge base and support documentation for recurring issues
• On Call and/or after hours work required
• Other related duties as directed

• Minimum of years of relevant experience in data warehousing, business intelligence tools, and the analysis of data.
• Minimum of year of SQL query development, preferably in multiple database management platforms, and working with normalized relational databases and dimensional data warehouse implementations
• Proficiency in ETL/ELT concepts and tools (Informatica IICS and Power Center preferred)
• Preferable hands-on experience with Talend and working knowledge of SAP BODI
• Experience with Airflow for job orchestration and scheduling
• Exposure to Event Stream Processing (ESP) platforms and real-time data handling
• Familiarity with incident tracking tools (, Service Now, Jira) and CI/CD practices
• Some experience with cloud-based database technologies is required
• Working knowledge of data warehousing concepts, structures and ETL best practices
• Experience using query tools (, AQT, MS Query)
• Ability to solve problems using analytical thinking skills

• Bachelor s degree in computer science, Information Systems, or related field
• + years of experience in ETL development and production support
• + years  experience in data warehousing and related domains