We are looking for an ETL Developer for a long term contract with our aerospace client. In this role you will design, build, and maintain data pipelines by extracting, transforming, and loading complex data from engineering, manufacturing, and supply chain sources into data warehouses. They ensure data accuracy for analysis, often utilizing SQL, Python, and tools like Informatica, PowerBI, and other production-level, high-reliability systems.
Key Responsibilities
Data Pipeline Development: Create, automate, and maintain robust ETL/ELT processes to move data from various sources (e.g., PLM systems, databases, APIs) to data lakes or warehouses such as Databricks.
Data Modeling & Transformation: Design source-to-target mappings, transform data into usable formats, and develop complex SQL queries and scripts.
System Integration & Maintenance: Integrate data from different systems (finance, engineering, operations) and monitor data quality, ensuring consistency and accuracy.
Troubleshooting: Identify and resolve data defects, performance issues, and bottlenecks in data workflows.
Documentation: Maintain technical documentation, including data flow diagrams and data dictionary definitions
Required
MS SQL - relational databases, data types, functions, stored procedures, sql agent
SSIS - visual studio, etl experience, sequencing, error handling, tokenization
Databricks experience
Troubleshooting / googling to solve problems
Optional tools/experience
Github
Dynamics
Jira
Databricks
Azure stack
Zeta Cloud
Aerospace / complex business process background
Ability to track solution end to end (ie: dynamics, databricks, pbi)