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
