ETL Developer

Job Description

Job Description

Benefits :

401(k)

Competitive salary

Opportunity for advancement

Training & development

Job Type : W2 Contract Role, Full Time, On Site. Role is tied to a multi-year project contract .

Industry : Information Technology

About Us

At Red Hill Consulting LLC , we are more than just consultantswe are problem solvers, innovators, and strategic partners. With expertise in IT, governance, risk management, compliance, and business transformation , we help organizations navigate complexity and drive meaningful change.

Our team specializes in delivering tailored, high-impact solutions that empower businesses to optimize processes, enhance security, and leverage data-driven insights. Whether it's implementing cutting-edge technology, refining operational strategies, or ensuring regulatory compliance, we take a proactive, hands-on approach to solving challenges.

Rooted in our core values of Integrity, Innovation, and Excellence , we foster a collaborative environment where expertise meets execution. Our clients span industries such as finance, healthcare, government, and technology , and we pride ourselves on delivering measurable results that drive sustainable success.

About the Role

We are seeking a detail-oriented ETL Developer to join a leading clients enterprise data and analytics team. In this role, you will be responsible for designing, developing, and maintaining data integration solutions that ensure high-quality, reliable data for analytics and reporting.

This is a multi-year consulting engagement focused on building and optimizing enterprise data warehouses, ETL pipelines, and reporting environments . You will collaborate closely with business analysts, database administrators, and reporting teams to deliver efficient and scalable data solutions that drive informed decision-making.

This position is ideal for a highly technical professional with deep SQL expertise, strong ETL development skills, and a passion for creating streamlined data workflows in a large, complex environment.

Key Responsibilities

• ETL Design & Development : Build and maintain robust ETL pipelines using SQL Server Integration Services (SSIS) and related technologies to support enterprise data warehouse operations.
• Data Warehouse Management : Contribute to the design and optimization of data warehouse structures, ensuring scalability and data integrity.
• Performance Optimization : Collaborate with DBA and reporting teams to tune queries, optimize ETL jobs, and improve data processing efficiency.
• Cloud Data Integration : Support data platform initiatives using Azure SQL Database, Azure Data Factory, Azure Storage, and Azure Pipelines .
• Monitoring & Troubleshooting : Monitor ETL workflows, proactively resolve job failures, and maintain reliable data delivery.
• Data Quality Assurance : Implement data validation, cleansing, and transformation processes to ensure accuracy and consistency.
• Collaboration : Work closely with cross-functional teams to translate business requirements into technical solutions.
• Reporting Support : Provide integration support for BI environments such as Cognos, Power BI, or Tableau .
• Documentation : Develop detailed documentation for ETL processes, workflows, and troubleshooting guidelines.
• Continuous Improvement : Recommend and implement improvements to ETL architecture and processes for scalability and automation.

Qualifications & Skills

Education & Experience :

• Bachelors degree in Computer Science, Engineering, or a related field.
• 8+ years of experience designing, developing, testing, and supporting ETL processes and enterprise data warehouses.
• Proven experience with SQL Server technologies (SSIS, SSAS, SSRS) for integration, reporting, and analytics.
• Strong expertise in T-SQL development, including writing complex queries, stored procedures, and views.
• Experience with Azure Data Services (Azure SQL Database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS / PaaS).
• Familiarity with Cognos, Power BI, Tableau , or other BI platforms.

Technical Competencies :

• Skilled in ETL workflow orchestration, optimization, and error-handling strategies.
• Strong understanding of data warehouse concepts , schema design, and relational database principles.
• Experience maintaining and monitoring ETL job schedules to ensure timely data delivery.
• Hands-on experience with query performance tuning and database optimization.
• Certifications in relevant database or data engineering technologies are preferred.

Soft Skills :

• Excellent communication and collaboration skills to work with developers, reporting teams, and business stakeholders.
• Strong analytical and problem-solving abilities with a focus on accuracy and efficiency.
• Ability to work independently, prioritize tasks, and meet deadlines in a fast-paced environment.
• Detail-oriented and proactive with strong documentation and knowledge-sharing habits.

Why Join Us?

• Be part of a dynamic, mission-driven team that values innovation and strategic thinking.
• Work on diverse, high-impact projects across multiple industries.
• Opportunities for professional development and career growth.
• Competitive salary and benefits package.