Pinnacle Group exists to connect people with opportunity. For the last 25 years, we've done exactly that by living our core values of putting people first, delivering excellence in all we do, and giving back to the communities in which we live and work. We are a leading workforce solutions company supporting the talent needs of global leaders in financial services, technology, communications, utilities, and transportation and we are one of the largest women and minority-owned companies in our industry. Our team of service-driven, energetic, and diverse professionals is well-respected in our industry and our leadership team is aligned and focused on taking the company to the next level. If you're looking for a new opportunity where you can truly make a difference, we hope you'll apply for a position with us.
Job Summary
- Lead, mentor, and develop a team of ETL and data engineers, providing technical guidance, code reviews, and career development support
- Act as a hands-on contributor, designing, developing, and maintaining ETL processes using SSIS, Azure Data Factory, and advanced SQL
- Architect, build, and enhance enterprise data warehouse solutions to support analytics, reporting, and business intelligence initiatives
- Design and implement scalable, efficient, and reliable data pipelines that integrate data from internal and external systems
- Develop complex SQL queries, stored procedures, and transformations to support high-performance data processing and reporting
- Establish and enforce best practices for ETL development, data modeling, version control, and deployment processes
- Ensure data integrity, quality, and consistency through validation frameworks, monitoring, and automated testing strategies
- Lead end-to-end data integration efforts across systems such as ERP, ATS, VMS, and financial platforms, ensuring seamless data flow
- Collaborate with BI teams, data architects, and business stakeholders to gather requirements and translate them into scalable technical solutions
- Support data exploration and analytics initiatives by preparing curated datasets and identifying trends, anomalies, and insights
- Drive modernization efforts, including migration to cloud-based platforms and adoption of Azure-native data services
- Identify opportunities for automation, performance optimization, and process improvement within the data engineering lifecycle
- Maintain comprehensive documentation for ETL processes, data mappings, and workflows to support transparency and maintainability
Qualifications
- 7+ years of experience in ETL development, data engineering, or data warehousing, with at least 2+ years in a leadership or managerial role
- Strong hands-on expertise with SSIS, Azure Data Factory, and advanced SQL (query tuning, stored procedures, performance optimization)
- Proven experience designing and managing enterprise data warehouse architectures and dimensional data models
- Experience building and maintaining scalable, high-performance data pipelines and integration frameworks
- Familiarity with integrating data across enterprise systems such as ERP, ATS, VMS, or financial platforms
- Strong understanding of data quality, governance, validation, and monitoring best practices
- Experience with cloud data platforms (Azure preferred; AWS or Snowflake is a plus)
- Excellent leadership, communication, and stakeholder management skills with the ability to bridge technical and business teams
Skills Required
- 7+ years of experience in ETL development, data engineering, or data warehousing
- At least 2+ years in a leadership or managerial role
- Strong hands-on expertise with SSIS, Azure Data Factory, and advanced SQL
- Proven experience designing and managing enterprise data warehouse architectures
- Experience building and maintaining scalable, high-performance data pipelines
- Familiarity with integrating data across enterprise systems
- Strong understanding of data quality and governance best practices
- Experience with cloud data platforms
- Excellent leadership and communication skills
Pinnacle Group, Inc. Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Pinnacle Group, Inc. and has not been reviewed or approved by Pinnacle Group, Inc..
-
Fair & Transparent Compensation — Pay is considered market-aligned in select specialized roles and certain high-cost markets. Some roles cite solid base pay that meets expectations when aligned to strong client programs.
-
Pay Growth & Progression — Performance-based raises and higher rates for select assignments are described in certain roles. Advancement opportunities and earnings can improve when placed on strong client accounts.
-
Inclusive Benefits Coverage — Access to medical, dental, vision, and a 401(k) is extended to W‑2 consultants as well as internal staff. Employer-of-record programs emphasize providing the full benefits suite to payrolled workers.
Pinnacle Group, Inc. Insights
What We Do
Pinnacle Group is a leading provider of information technology and workforce solutions. Pinnacle Group includes Pinnacle Technical Resources, Inc., its flagship information technology staffing and consulting services provider; Pinnacle MSP, a managed services provider; Pinnacle Payrolling, a payrolling and independent contractor compliance provider; Pinnacle Canada, which provides staffing, MSP and payrolling services in Canada. Pinnacle Group has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit http://www.pinnacle1.com Apply online now at http://www.pinnacle1.com/careers/
.png){kind=logo}
