ETL Developer - 1 year contract - 60/hr Remote

ContractStaffingRecruiters.com; Branford (CT); Remote; USD 90,000 - 120,000; Full time

Job summary

ContractStaffingRecruiters.com is seeking an ETL Developer for a long-term contract in Branford, Connecticut. This role involves designing and maintaining robust data pipelines from various sources to ensure accuracy for analysis. Candidates will need strong SQL skills and experience in ETL systems.

The ideal applicant will have over 5 years of experience, a relevant Bachelor's degree, and familiarity with tools like Informatica and PowerBI. Join our aerospace client’s innovative team.

Qualifications

• 5+ years of ETL experience essential.
• Understanding of relational databases and MS SQL functions.
• Bachelor's degree in a relevant field required.

Responsibilities

• Create and maintain ETL processes for data movement.
• Design mappings and transform data into usable formats.
• Integrate different system data and monitor quality.
• Troubleshoot and resolve data-related issues.
• Maintain technical documentation.

Skills

MS SQL

SSIS

Troubleshooting

ETL

Education

Bachelor's Degree in Engineering, Analytics, Data Science, Mathematics

Tools

PowerBI

Informatica

Github

Dynamics

Jira

Databricks

Azure stack

Zeta Cloud

Job description

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

Skills Required:

• 5+ ETL experience
• Bachelors Degree in Engineering, Analytics, Data Science, Mathematics