Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation and navigate constant change. Through a combination of strategy, expertise and creativity, we help clients accelerate operational, digital and cultural transformation, enabling the change they need to own their future.
Join our team as the expert you are now and create your future.
We are seeking an experienced Data Engineering Architect with deep expertise in Informatica Intelligent Cloud Services (IICS) and solid data warehousing design and implementation capabilities. This role will drive the architecture of scalable data platforms while ensuring robust, well-modeled data foundations that support analytics and business intelligence.
The ideal candidate will bring a blend of architectural vision and hands-on expertise in designing and implementing enterprise-grade data warehouses and data integration frameworks.
Requirements:
Define and design end-to-end data architecture, including enterprise data warehouse (EDW) and data marts
Lead data modeling initiatives using dimensional modeling techniques (star schema, snowflake schema, fact/dimension design)
Design and implement scalable data warehouse solutions aligned with business and analytics needs
Establish standards for data modeling, naming conventions, and metadata management
Lead implementation of Informatica IICS (CDI, CAI, and related services)
Architect and govern ETL/ELT pipelines supporting data warehouse loading and transformation
Optimize data integration workflows for performance, scalability, and cost efficiency
Mentor teams on best practices in ETL development and data warehouse integration
Define data quality frameworks and validation strategies for warehouse data
Ensure consistency and integrity across source-to-target data flows
Implement auditing, lineage, and reconciliation mechanisms
Work closely with business stakeholders to translate reporting and analytics needs