Data Engineering Architecture Manager

About the role

Deloitte Consulting is recruiting a Data Engineering Architecture Manager to lead a large-scale modernization of legacy Informatica PowerCenter and on-premises master data management (MDM) capabilities toward Snowflake and Informatica IDMC, including cloud MDM, Customer 360, data integration, API migration, testing, cutover and downstream readiness. The role sits within the AI & Data practice, which designs, develops and operates data and AI platforms for clients. Recruiting ends on 11/1/2026.

Key responsibilities

• Lead the modernization of legacy PowerCenter and on-premises MDM to Snowflake and Informatica IDMC.
• Drive Agile and PMO governance through sprint planning, stand-ups, backlog management, executive reporting, RAID management, change control and steering committee updates.
• Assess the current MDM platform, including entity models, match and merge rules, survivorship, trust logic, custom Java APIs and integrations.
• Architect a Snowflake medallion data pipeline with bronze, silver and gold layers, incremental processing, data quality controls, auditability and observability.
• Design IDMC MDM entities for Person, Organization, Account, Service and Household, including relationship models, stewardship workflows, security and Customer 360 capabilities.
• Oversee reverse engineering of PowerCenter mappings and workflows into PySpark, Python and SnowSQL, with quality gates and conversion tracking.
• Define the API migration strategy, rebuild custom processes using Informatica CAI and Snowflake/Python, and coordinate downstream consumer transition.

Required profile

• 10+ years of experience leading cross-functional teams across Snowflake and MDM workstreams, including resource planning, onboarding, lead development, delivery governance and coordination across delivery locations.
• Bachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering or a related IT discipline, or equivalent experience.
• Ability to travel 10% on average, depending on clients and sectors served.
• Limited immigration sponsorship may be available.

Required skills

• Snowflake and MDM architecture and design
• Informatica PowerCenter, Informatica IDMC and Informatica CAI
• PySpark, Python and SnowSQL
• API migration strategy and customer 360 capabilities
• Agile and PMO governance

The stated wage range is $140,000 to $160,000, and candidates may be eligible for a discretionary annual incentive program. The position is open in several US cities, including Atlanta, Charlotte, Dallas, Houston, Lake Mary, Mechanicsburg, Philadelphia and Gilbert.