Data Movement Engineer; Talend - Contractor

Get AI-powered advice on this job and more exclusive features.

Feel Good About Doing Good The Knights of Columbus is a tax-exempt Catholic fraternal benefit society that provides financial security to members and their families through our life insurance, long-term care insurance, disability income insurance, investment and annuity products. Charity is at the core of our missions: our profits are donated to help those in need and to support our faith - $1.73B over the past ten years.

The Knights of Columbus follows the Church’s teachings in our investment strategies and our employee benefits. As part of our religious mission, we support the pro-life cause, oppose assisted suicide and euthanasia, and help Christians who are facing religious persecution in the Middle East.

Share Your Talent. Live Your Purpose. We are a growing and purpose-driven community of professionals. Join us to discover how you can meet your goals and ours!

The Knights of Columbus is embarking on the modernization of its core data platforms. We are currently seeking a Data Movement Engineer who will assist in supporting our current ETL environment and building new ETL/ELT workflows and data pipelines as we transition to a cloud environment. This role will support data architects, analysts, and BI developers on various data initiatives. The ideal candidate will possess strong expertise in ETL tools like Talend & Informatica, data warehousing, and cloud technologies, and be comfortable leading complex projects and mentoring team members.

• Complete full life cycle of ETL/ELT development including design, mappings, transformations, scheduling, and testing.
• Translate data movement requirements into technical ETL design.
• Design, develop, and maintain robust ETL workflows using Talend, Informatica (IICS, Power Center), and BODI.
• Develop data extraction and transmissions to external vendors.
• Develop test plans and perform unit testing.
• Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements.
• Perform design and code reviews in support of organizational standards.
• Contribute to architectural decisions to support business processes.
• Perform data quality analysis, report data quality issues and propose solutions for data quality management.
• Analyze and interpret existing BODI code to support migration or integration efforts.
• Optimize data extraction, transformation, and loading processes for reliability, performance, and scalability.
• Develop and optimize complex SQL queries.
• Ensure ETL jobs are well-documented, version-controlled, and aligned with data architecture standards.
• Provide production support for ETL and data solutions, including troubleshooting and resolving pipeline issues.
• Monitor ETL jobs and proactively address failures or performance issues.
• Lead root cause analysis and resolution of data-related production incidents.
• Collaborate with other teams to implement fixes and preventive measures.
• Identify recurring issues and propose long-term solutions.
• Suggest process and technical improvements to reduce incidents.
• Implement data validation, cleansing, and reconciliation logic within ETL processes.
• Support data lineage and impact analysis for downstream systems.
• Provide technical leadership, code reviews, and mentorship to junior ETL developers.
• Coordinate with business stakeholders, data architects, and application teams to gather requirements and deliver solutions.
• Communicate issue status, impact, and resolution timelines effectively.
• On‑call and/or after‑hours work required.

• Minimum of 5 years of relevant experience in data warehousing, business intelligence tools and data analysis.
• Minimum of 3 years of SQL query development across multiple database platforms (Snowflake, SQL Server, DB2).
• Expert‑level proficiency in Talend Management Console and Talend Open Studio.
• Must work well independently; inquisitive and seek answers to complex questions without being prompted.
• Strong understanding of BODI code and architecture.
• Proficiency in ETL/ELT concepts and tools (Informatica IICS, Talend, Boomi, Power Center).
• Working knowledge of data…