Job Summary

The ETL Informatica Lead will lead the planning, execution, and delivery of enterprise-scale data warehouse and analytics initiatives, with a strong focus on Enterprise Data Warehouse modernization, cloud data platforms, Microsoft Fabric, and Microsoft Purview. The role will coordinate cross-functional teams, partner closely with customers on Fabric and Purview integration and implementation, and lead a team of 10–20 associates. The position requires strong expertise in Informatica ETL, Azure cloud-based data platforms, modern data architectures, data governance, and end-to-end delivery, along with the ability to participate in strategic client discussions, proposals, estimations, and presentations. This is a hybrid role requiring the team to work onsite two days per week.

Key Responsibilities

• Lead end-to-end delivery of Enterprise Data Warehouse and analytics initiatives from project initiation through closure.

• Plan, execute, and deliver large-scale data warehouse modernization and analytics initiatives.

• Lead a team of 10–20 associates and coordinate delivery across cross-functional teams.

• Partner with customers on Microsoft Fabric and Microsoft Purview integration and implementation.

• Participate in the implementation and integration of Microsoft Fabric components including OneLake, Data Engineering, Data Factory, Data Science, and Power BI.

• Leverage Fabric and Purview implementation experience to lead delivery across the engagement.

• Collaborate with internal teams and customers to identify and resolve project and operational issues related to Data Governance and Management.

• Coordinate daily, weekly, and ad hoc customer communications and participate in strategic discussions.

• Manage project issues, risks, scope, resources, and delivery activities.

• Support modern data platform implementations involving EDW modernization, cloud data platforms, and analytics solutions.

• Apply strong understanding of Enterprise Data Warehouse concepts, including data modeling, ETL/ELT, and analytics.

• Support data governance, cataloging, and compliance initiatives using Microsoft Purview.

• Apply knowledge of Azure data services and BI ecosystems, including Power BI.

• Draft proposals, provide effort estimations, and participate in client presentations.

• Collaborate with stakeholders to develop solutions for existing and proposed data platform and governance initiatives.

• Maintain delivery focus while adapting to project requirements and learning new technologies as needed.

Required Qualifications

• 10+ years of hands-on experience with large-scale Enterprise Data Warehouse or analytics initiatives.

• 5+ years of technical lead experience on large-scale Enterprise Data Warehouse or analytics initiatives.

• 5+ years of experience with Informatica ETL.

• 4+ years of hands-on experience with Azure cloud-based data platform projects.

• 2+ years of experience with Microsoft Fabric and its role in modern data architectures, including Power BI.

• Strong understanding of Enterprise Data Warehouse concepts, data modeling, ETL/ELT, and analytics.

• Experience with Microsoft Purview for data governance, cataloging, and compliance.

• Bachelor's degree in Computer Science or equivalent work experience.

• Strong issue management, risk management, scope management, and resource management skills.

• Strong customer communication, stakeholder management, and presentation skills.

Preferred Qualifications

• Experience in the Insurance domain.