Pratt & Whitney is seeking a Lead ETL Developer to build and maintain robust data integration solutions supporting our enterprise data warehousing, reporting, and analytics. You'll design cloud-native pipelines and dimensional models while providing leadership to offshore resources.
What You'll Do
- Conduct meetings and workshops to gather, clarify, and validate data and reporting requirements.
- Analyze business information needs and perform thorough source data profiling and gap analysis.
- Identify and document business transformation rules and logic for data integration.
- Collaborate with stakeholders and architects to translate requirements into functional and technical specifications.
- Work closely with SMEs from systems including ADP Enterprise, Workday, SAP ERP, and SuccessFactors.
- Design and implement scalable, cloud-native ETL pipelines using Matillion, integrating data into the Snowflake data warehouse.
- Create and manage Snowflake databases, warehouses, schemas, and objects.
- Design and develop dimensional data models based on the Kimball methodology.
- Build orchestration workflows and transformation mappings to enable efficient ETL loads.
- Monitor, troubleshoot, and debug ETL jobs to ensure high data quality, performance, and reliability.
- Design and implement secure data pipelines, ensuring compliance with data governance and quality standards.
- Document ETL processes and data models to support knowledge sharing.
- Work closely with BI, Data Science, and IT teams to ensure solutions meet business needs.
- Support quality assurance efforts by participating in test plan creation and issue resolution.
- Coordinate User Acceptance Testing and production deployment activities.
- Oversee and monitor production data loads to ensure timely data delivery.
- Provide leadership to offshore resources by assigning tasks, tracking progress, and ensuring timely deliverables.
What We're Looking For
- Typically requires a University Degree or equivalent experience and minimum 8 years prior relevant experience, or an Advanced Degree in a related field and minimum 5 years experience.
- Experience with Cloud Platforms: Microsoft Azure, AWS (S3).
- Experience with Data Warehousing: Snowflake.
- Experience with ETL / Orchestration Tools: Matillion.
- Experience with Databases: Oracle 19c, Azure SQL Server.
- Experience with Languages & Scripting: SQL, Python.
- Experience with Modeling & BI Tools: SQL Data Modeler, Qlik Sense.
Nice to Have
- Proven experience with Snowflake and Matillion in cloud-based data environments.
- Strong knowledge of ETL/ELT best practices, data warehousing principles, and data modeling.
- Excellent SQL and scripting skills for data processing and transformation.
- Strong understanding of data governance, access control, and data quality principles.
- Ability to work effectively with cross-functional and geographically distributed teams.
- Excellent communication, documentation, and problem-solving skills.
Technical Stack
- Microsoft Azure, AWS (S3), Snowflake, Matillion
- Oracle 19c, Azure SQL Server
- SQL, Python
- SQL Data Modeler, Qlik Sense
Team & Environment
You will be part of the data engineering team, working closely with BI, Data Science, and IT teams, and will provide leadership to offshore resources.
Benefits & Compensation
- Compensation: $101,000 USD - $203,000 USD
- Parental (including paternal) leave
- Flexible work schedules
- Achievement awards
- Educational assistance
- Child/adult backup care
- Medical, dental, vision, life insurance
- Short-term disability, long-term disability
- 401(k) match
- Flexible spending accounts
- Employee assistance program
- Employee Scholar Program
- Paid time off and holidays
- Annual short-term and/or long-term incentive compensation programs
Work Mode
This is a hybrid position based in Farmington, CT, 06032 USA.
RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class.
