Director ETL and Data Engineering

Church Pension Group; New York (NY); Hybrid; USD 136,000 - 180,000; Full time

Benefits offered by this job

Medical (including Vision)

Dental

Pension plan

Life Insurance

Disability Insurance

Job summary

Church Pension Group in Midtown Manhattan seeks a Director of ETL and Data Engineering to lead a team building enterprise data integration solutions, ETL pipelines, and data platforms across the organization.

You will ensure data quality, security, and governance while guiding modern data engineering practices and collaborating with stakeholders to design scalable systems and deliver end-to-end with hands-on leadership.

Qualifications

• Expert knowledge of database and data warehouse design principles.
• Strong experience designing and implementing ETL/ELT pipelines using modern data integration tools.
• Proficiency with data orchestration and workflow management tools.
• Experience with data warehousing concepts, data modeling, and analytics platform design.
• Strong full-lifecycle application development experience from requirements gathering through deployment and maintenance.
• Deep understanding of coding best practices and design patterns with a focus on performance and scalability.
• Demonstrated experience with Scrum and Agile methodologies, including experience leading agile teams.
• Expert-level proficiency in one or more programming languages and ability to quickly become productive in new technical environments.
• Excellent oral and written communication skills, including the ability to translate technical concepts for non-technical stakeholders.

Responsibilities

• Drive project initiatives to deliver robust and scalable data solutions.
• Architect and design ETL pipelines, data platforms, and applications that are scalable and well-tested.
• Lead a team of software engineers with hands-on development responsibilities.
• Manage and optimize a portfolio of data integration processes.
• Collaborate with analysts and business owners to design new products or extensions.
• Provide technical oversight, code reviews and mentoring.
• Deliver end-to-end solutions meeting milestones and stakeholder expectations.
• Lead agile development practices and continuous improvement.
• Design automated tests to exercise application logic.
• Ensure compliance with security and governance standards.

Skills

Data warehousing

ETL/ELT pipelines

Data orchestration

Analytics platform design

Full lifecycle development

Coding best practices

Agile methodologies

Strong communication

Education

Bachelor’s/Master’s in STEM

Tools

ETL tools

Workflow management tools

Job description

Description Department: Information Technology Job Type: Regular Full Time Education Level: BA/BS Required Years Experience: 7

Church Pension Group (CPG) is a financial services organization that serves the Episcopal Church, located in Midtown Manhattan. CPG was founded in 1917 to provide pension benefits to eligible clergy of the Episcopal Church. Since then, its mission has expanded to include life and disability insurance, health benefits, property & casualty insurance, and publishing.

The Director of ETL and Data Engineering leads a team of software engineers in designing, building, and maintaining enterprise data integration solutions, ETL pipelines, and data platforms across The Church Pension Group's business and corporate units. This role ensures data integrity, consistency, and availability across systems while supporting business process automation, integration, and analytics. The role ensures data quality, security, and operational excellence, collaborating closely with stakeholders to develop consistent data processes and technical solutions. The Director provides hands‑on technical leadership and drives adoption of modern data engineering and software development practices.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Drive project initiatives to deliver robust and scalable solutions that advance CPG's data engineering capabilities, incorporating new technologies as appropriate.


• Architect and design ETL pipelines, data platforms, and application solutions that are scalable, maintainable, reusable and well-tested.


• Lead a team of Software Engineers while maintaining hands‑on development responsibilities for critical applications and data solutions.


• Manage and maintain a portfolio of applications and data integration processes, identifying opportunities to standardize and streamline workflows.


• Collaborate with Business Analysts, technical teams, and business owners to identify requirements and design new products or extensions to existing products.


• Provide technical oversight to the development process including code reviews and mentoring of the technical team.


• Deliver solutions end-to-end, ensuring delivery milestones are met and stakeholder expectations are managed.


• Lead agile development practices and continuous improvement initiatives across the team.


• Design and oversee automated testing strategies including unit tests to ensure application logic is fully exercised for each application component.


• Ensure all solutions comply with enterprise security and privacy guidelines and maintain data governance standards.


• Utilize the hybrid work schedule to maintain regular in‑person, on‑site presence that fosters team collaboration, relationship building, and effective technical leadership.


• Effective performance of the essential functions of this position requires regular in‑person, on‑site interaction with colleagues, both for purposes of relationship building and meaningful collaboration.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Expert knowledge of database and data warehouse design principles, including when to build new structures versus reusing existing ones, optimization strategies, and balancing solution complexity with business needs.


• Strong experience designing and implementing ETL/ELT pipelines using modern data integration tools and frameworks.


• Proficiency with data orchestration and workflow management tools.


• Experience with data warehousing concepts, data modeling, and analytics platform design.


• Strong full‑lifecycle application development experience from requirements gathering through deployment and maintenance.


• Deep understanding of coding best practices and design patterns with a focus on performance and scalability.


• Demonstrated experience with Scrum and Agile methodologies, including experience leading agile teams.


• Expert‑level proficiency in one or more programming languages and ability to quickly become productive in new technical environments.


• Excellent oral and written communication skills, including the ability to translate technical concepts for non‑technical stakeholders.

EDUCATION And/or EXPERIENCE

• Bachelor’s and/or Master’s degree in software engineering, science, technology, engineering or mathematics or combination of equivalent education and experience.


• 7+ years of professional software development experience.


• 3+ years of experience in a technical leadership or senior engineering role.


• 5+ years hands‑on experience with ETL, shell scripting, and process orchestration tools.

Physical Demands

• Extensive use of computer keyboard and mouse.


• Use of telephone for extended meetings with remotely located colleagues.


• Some travel. If remotely located, must be prepared to travel several times per year.


• Ability to maintain standard New York (EST) business hours on a regular schedule, and work outside ordinary business hours in the event of production emergencies (i.e., critical applications becoming unavailable), and/or to participate in scheduled and unscheduled Disaster Recovery and Business Continuity exercises occasionally.

Work Environment

Currently, hybrid work environment, which requires working in CPG’s office Tuesdays through Thursdays and flexibility to work remotely on Mondays and Fridays. Church Pension Group employees must always maintain a professional, compassionate, and trustworthy work environment. Reasonable accommodations may be made to enable someone with a disability to perform the essential functions of the job within this environment.

Salary Range: $136,000 - $180,000

Flexible Benefits Available To Eligible Employees

• Medical (including Vision)


• Dental

Core Benefits Automatically Provided To Eligible Employees

• Employer funded defined benefit pension plan (five year vesting)


• Employee Life Insurance


• Spouse and Dependent Life Insurance


• Accidental Death and Dismemberment (AD&D) Insurance


• Short-Term Disability (STD) coverage


• Long-Term Disability (LTD) coverage (elected as either pre‑tax or after‑tax)


• Business Travel Accident Insurance


• Worker’s Compensation


• Employee Assistance Program


• Retiree health insurance (eligible after 10 years)


• Retiree life insurance

Elective Benefits Available To Eligible Employees

• 401(k) with matching contributions (immediate vesting)


• Flexible Spending Accounts (FSAs)


• Commuter Benefits


• New York’s 529 College Savings Program (NY State residents)

Educational Assistance Program available to eligible employees

Parental Leave available to eligible employees

Time Off available to eligible employees: Vacation, Sick, Personal and Holidays

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. Please understand that, as a general policy, CPG does not sponsor visas.

CPG is an equal opportunity employer. We are committed to fair hiring practices and do not discriminate against job applicants or employees based on any protected characteristics. We also celebrate diversity and are committed to creating an inclusive environment for all employees.