Knights of Columbus

Associate Data Movement Engineer, Talend – Contractor

Knights of Columbus

contract

Posted on:

Location Type: Office

Location: New Haven • Connecticut • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowCloudETLInformaticaServiceNowSQL

About the role

  • 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

Requirements

  • Minimum of 1 years of relevant experience in data warehousing, business intelligence tools, and the analysis of data.
  • Minimum of 1 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 PowerCenter 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 (e.g., ServiceNow, 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 (e.g., AQT, MS Query)
  • Ability to solve problems using analytical thinking skills
Benefits
  • Charity is at the core of our missions
  • Support our two million members as they volunteer to help others in their parishes and communities around the world

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
ETLELTSQLdata warehousingdata quality analysisdata transformationdata extractiondata validationdata cleansingdata reconciliation
Soft skills
analytical thinkingproblem solvingcollaborationcommunication