Director of Global Talent Acquisition | Connecting People with Opportunity
About Pinnacle Group
Pinnacle Group is a leading workforce solutions provider, delivering innovative technology solutions and data-driven insights to help organizations transform and scale. With deep expertise in IT consulting, data engineering, and business operations, we empower clients to modernize their data ecosystems and achieve operational excellence. Our collaborative, customer-centric approach ensures we deliver impactful and sustainable results across industries.
Summary
Pinnacle Group is seeking a highly skilled ETL Developer with strong expertise in SQL, Azure Data Factory (ADF), and SSIS. This role is focused on designing, developing, and optimizing scalable data integration pipelines to support enterprise data initiatives. The ideal candidate will have a solid foundation in data modeling and data warehousing concepts, along with a passion for building efficient, reliable data solutions. You will play a key role in enabling data-driven decision-making across the organization.
Job Description
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
Requirements
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
Why Join Pinnacle Group?
At Pinnacle Group, you will have the opportunity to work on cutting-edge data and technology initiatives that drive real business impact. We foster a collaborative and growth-oriented environment where innovation is encouraged and professional development is supported. Our team values expertise, accountability, and continuous improvement, offering you the platform to expand your technical skills and advance your career. Join us to be part of a dynamic organization shaping the future of data-driven transformation.
Compensation and Benefits Disclosure
The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.
Instructions
Please answer the questions below, attach your resume and email your responses to Kathryn.Nelson@PTRGlobal.com and Jason.Jordi@Pinnacle1.com as part of your application.
Can you describe your experience designing and optimizing complex SQL queries for large-scale data processing? SQL will be a key competency in this role.
What hands-on experience do you have with SSIS packages, including development, deployment, and troubleshooting?
How have you used Azure Data Factory (ADF) to build and orchestrate ETL/ELT pipelines in a cloud environment?
Can you explain your approach to data modeling (e.g., star schema, snowflake schema) and when you would use each?
Could you please share your salary expectations so that we are respectful of your time?
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Staffing and Recruiting and IT Services and IT Consulting
Referrals increase your chances of interviewing at Pinnacle Group, Inc. by 2x