ETL Developer

We are working with a leading aerospace client known for its innovative contributions to the aviation and space industries. This organization is at the forefront of developing cutting-edge technology and complex systems that drive progress and ensure global connectivity.

The Role

• Design, build, and maintain data pipelines for extracting, transforming, and loading complex data.
• Develop, automate, and maintain robust ETL/ELT processes to move data from various sources to data lakes or warehouses like Databricks.
• Design source-to-target mappings, transform data into usable formats, and develop complex SQL queries and scripts.
• Integrate data from different systems (finance, engineering, operations) and monitor data quality, ensuring consistency and accuracy.
• Identify and resolve data defects, performance issues, and bottlenecks in data workflows.
• Maintain technical documentation, including data flow diagrams and data dictionary definitions.

What You'll Need

• Proficiency with MS SQL, including relational databases, data types, functions, stored procedures, and SQL Agent.
• Strong SSIS experience, including visual studio, ETL, sequencing, error handling, and tokenization.
• Hands-on experience with Databricks.
• Proven ability to troubleshoot and solve complex problems.
• Experience with tools like Informatica, PowerBI, Python, or similar production-level systems.

What's On Offer

• Opportunity to work on critical data initiatives for a major aerospace client.
• Engage with complex engineering, manufacturing, and supply chain data.
• Utilize modern data technologies like Databricks.
• Contribute to systems that ensure high data accuracy for analysis.

Apply via Haystack today!