ETL Developer

Role Overview: As an ETL Developer at Pinnacle Group, you will be responsible for designing, developing, and optimizing scalable data integration pipelines using SSIS and Azure Data Factory (ADF). Your role will involve collaborating with stakeholders to gather requirements, implementing data modeling principles, and ensuring high data quality and integrity. You will play a crucial part in supporting enterprise data workflows and enabling data-driven decision-making across the organization. Key Responsibilities: - Design, develop, and maintain robust ETL pipelines using SSIS and Azure Data Factory (ADF) - Build and optimize complex SQL queries, stored procedures, and data transformations - Implement scalable data integration solutions to support enterprise data workflows - Collaborate with stakeholders to gather requirements and translate them into technical specifications - Apply data modeling and data warehousing principles to structure and manage large datasets - Monitor ETL jobs, troubleshoot failures, and ensure high data quality and integrity - Optimize performance of data pipelines through indexing, partitioning, and query tuning - Support cloud-based data initiatives and contribute to modernization efforts - Document processes, workflows, and technical designs for maintainability and knowledge sharing Qualifications Required: - Proven experience in ETL development with hands-on expertise in SSIS and Azure Data Factory (ADF) - Advanced proficiency in SQL, including performance tuning and query optimization - Strong understanding of data modeling techniques and data warehouse architecture - Experience working with large-scale datasets and complex data transformations - Familiarity with cloud platforms, preferably Microsoft Azure - Strong analytical and problem-solving skills with attention to detail - Excellent communication skills and ability to collaborate with cross-functional teams About Pinnacle Group: Pinnacle Group is a leading workforce solutions provider that delivers innovative technology solutions and data-driven insights to help organizations transform and scale. With expertise in IT consulting, data engineering, and business operations, Pinnacle Group empowers clients to modernize their data ecosystems and achieve operational excellence. The company fosters a collaborative and growth-oriented environment where innovation is encouraged, and professional development is supported. Join Pinnacle Group to be part of a dynamic organization shaping the future of data-driven transformation. Role Overview: As an ETL Developer at Pinnacle Group, you will be responsible for designing, developing, and optimizing scalable data integration pipelines using SSIS and Azure Data Factory (ADF). Your role will involve collaborating with stakeholders to gather requirements, implementing data modeling principles, and ensuring high data quality and integrity. You will play a crucial part in supporting enterprise data workflows and enabling data-driven decision-making across the organization. Key Responsibilities: - Design, develop, and maintain robust ETL pipelines using SSIS and Azure Data Factory (ADF) - Build and optimize complex SQL queries, stored procedures, and data transformations - Implement scalable data integration solutions to support enterprise data workflows - Collaborate with stakeholders to gather requirements and translate them into technical specifications - Apply data modeling and data warehousing principles to structure and manage large datasets - Monitor ETL jobs, troubleshoot failures, and ensure high data quality and integrity - Optimize performance of data pipelines through indexing, partitioning, and query tuning - Support cloud-based data initiatives and contribute to modernization efforts - Document processes, workflows, and technical designs for maintainability and knowledge sharing Qualifications Required: - Proven experience in ETL development with hands-on expertise in SSIS and Azure Data Factory (ADF) - Advanced proficiency in SQL, including performance tuning and query optimization - Strong understanding of data modeling techniques and data warehouse architecture - Experience working with large-scale datasets and complex data transformations - Familiarity with cloud platforms, preferably Microsoft Azure - Strong analytical and problem-solving skills with attention to detail - Excellent communication skills and ability to collaborate with cross-functional teams About Pinnacle Group: Pinnacle Group is a leading workforce solutions provider that delivers innovative technology solutions and data-driven insights to help organizations transform and scale. With expertise in IT consulting, data engineering, and business operations, Pinnacle Group empowers clients to modernize their data ecosystems and achieve operational excellence. The company fosters a collaborative and growth-oriented environment where innovation is encouraged, and professional development is supported. Join Pi