Apply on Employer Site

Knights of Columbus · 2 days ago

Associate Data Movement Engineer (Talend) - Contractor

New Haven, CT

Full-time, Contract

Onsite

Entry Level

1+ years exp

The Knights of Columbus is a tax-exempt Catholic fraternal benefit society that provides financial security to its members and their families. They are seeking an Associate Data Movement Engineer to assist in modernizing their ETL environment and building new data workflows and pipelines in a cloud environment.

Insurance

H1B Sponsor Likely

Responsibilities

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

Qualification

ETL/ELT conceptsSQL query developmentTalendAirflowData warehousingCloud-based databasesAnalytical thinkingIncident tracking toolsData quality management

Required

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

Bachelor's degree in computer science, Information Systems, or related field

1+ years of experience in ETL development and production support

1+ years' experience in data warehousing and related domains

Company

Knights of Columbus

Knights of Columbus has grown from several members in one council to 15,342 councils and 1.9 million members throughout the United States,.

Founded in 1882

New Haven, Connecticut, USA

1001-5000 employees

http://www.kofc.org

H1B Sponsorship

Knights of Columbus has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2020 (1)