About the Role
As a Data Engineer II at Honeywell Aerospace, you will develop and refine data pipelines for accurate and efficient information flow, enhancing the organization's ability to access and utilize critical financial data. Your primary focus will be on creating robust, scalable solutions for real-time data delivery and automated processing from diverse sources to endpoint solutions, collaborating with Finance stakeholders to translate business requirements into reliable data products.
Responsibilities
- Build and maintain ELT/ETL pipelines that ingest data from varied sources into Snowflake, ensuring reliability, observability, and recoverability.
- Develop transformations using SQL and Python within Dataiku and Databricks to produce trusted, reusable finance data marts and subject-area tables.
- Automate and orchestrate workflows in Dataiku/Databricks, implementing robust logging and monitoring.
- Enable Tableau analytics by publishing performant Snowflake views and semantic layers, optimizing query patterns.
- Implement data quality and governance measures, including validation rules, reconciliations, lineage documentation, and access controls.
- Collaborate with Finance/FP&A, Accounting, and business analysts to translate metrics into data models and pipelines.
- Leverage Snowflake features and optimization strategies for performance tuning.
- Manage code in Git, contribute reviews, and promote changes through development, testing, and production environments.
- Convert manual/Excel processes into automated, auditable pipelines and prototype utilities in Python.
Requirements
- Experience with ELT/ETL pipeline development.
- Proficiency in SQL and Python.
- Experience with Dataiku and Databricks (recipes, flows, scenarios, notebooks, Jobs, Delta Lake/Spark).
- Experience with workflow automation and orchestration.
- Experience with Snowflake views and semantic layers.
- Experience with query optimization.
- Experience with data quality and governance implementation.
- Experience with requirement gathering and stakeholder collaboration.
- Experience with performance tuning and optimization strategies.
- Experience with version control (Git) and CI/CD practices.
- Experience converting manual processes into automated pipelines.
Skills
- SQL
- Python
- Dataiku
- Databricks
- Snowflake
- Tableau
- Git
- ELT/ETL
- Data Quality
- Data Governance
- CI/CD
Location
- Sky Harbor, Phoenix, AZ
Work Type
- Hybrid
- Onsite
Experience Level
- Data Engineer II
About the Company
- Honeywell Aerospace
