ETL Developer

About Pinnacle Group

Pinnacle Group is a trusted leader in delivering innovative workforce and technology solutions that help organizations optimize data, systems, and business outcomes. We partner with clients to build scalable, data-driven platforms that enable informed decision-making and long-term growth. Our teams combine deep technical expertise with a collaborative mindset to solve complex data and integration challenges. At Pinnacle Group, we foster an environment where technical excellence and continuous learning are at the core of everything we do.

Summary

The ETL Developer will play a critical role in designing, developing, and maintaining robust data integration and data warehousing solutions. This position focuses on building reliable ETL pipelines that support business intelligence and analytics initiatives. The ideal candidate brings strong expertise in T-SQL, SSIS, and Azure Data Factory, along with a passion for data quality and performance optimization. This role collaborates closely with business and technical stakeholders to deliver scalable, high-impact data solutions.

Job Description

• Design, develop, and maintain ETL processes to support enterprise data integration and reporting initiatives.
• Develop complex T-SQL queries, stored procedures, and transformations to support data extraction and processing.
• Build, deploy, and manage ETL workflows using SQL Server Integration Services (SSIS).
• Design and model data warehouse structures to support analytics and business intelligence requirements.
• Ensure data accuracy, consistency, and integrity through testing, validation, and monitoring processes.
• Collaborate with business analysts and stakeholders to gather requirements and translate them into technical solutions.
• Monitor ETL pipelines and troubleshoot performance or data issues to ensure reliable operations.
• Create and maintain clear documentation for ETL workflows, data mappings, and technical processes.

Requirements

Why Join Pinnacle Group?

At Pinnacle Group, you will work on impactful data initiatives that support critical business decisions across organizations. We provide an environment that encourages innovation, collaboration, and professional growth while working with modern data and cloud technologies. You’ll have the opportunity to expand your technical skill set, contribute to meaningful projects, and work alongside experienced professionals. Our culture values accountability, continuous improvement, and delivering excellence for both our clients and our people.