Lead a team of ETL engineers, design ETL processes using SSIS and Azure Data Factory, develop data warehouse solutions, and ensure data quality.
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
Top Skills
AWS
Azure
Azure Data Factory
Snowflake
SQL
Ssis
Similar Jobs
Cloud • Information Technology • Productivity • Software • Automation
Design visuals for digital and print, manage projects, maintain brand guidelines, oversee design elements, and assist with presentations. Requires strong skills in Adobe Creative Suite and collaboration.
Top Skills:
Adobe Creative SuiteCanvaFigmaGoogle SlidesIllustratorIndesignPhotoshopPowerPoint
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Lead the collection of user requirements, analyze designs, implement enterprise solutions, and manage backend and frontend application development, ensuring high code quality and end-to-end delivery by guiding junior developers.
Top Skills:
Azure DevopsCSSJavaMongoDBMySQLReactSpring Boot
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The position is for a Software/Platform Engineer I at MetLife, focused on providing software solutions in a hybrid work environment.
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
