[Hiring] ETL Manager @Pinnacle Group, Inc.

Role Description

• 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.