Director ETL and Data Engineering

About the role

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.

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.

Qualifications

• 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.
• 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.

Benefits

• 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
• 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

Pay

$136,000 - $180,000

Schedule

Hybrid work schedule, working in CPG’s office Tuesdays through Thursdays and flexibility to work remotely on Mondays and Fridays.