Data Engineering Architect

Huron Consulting Group Inc.; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) with employer match

Generous Paid Time Off policy

Paid parental leave and adoption assistance

Job summary

Huron Consulting Group Inc. is seeking a Data Engineering Architect in Bengaluru, India, to design and implement scalable data architecture. The ideal candidate will have strong expertise in Informatica IICS and data warehousing, ensuring robust foundations for analytics.

You will lead initiatives in data modeling and ETL processes while collaborating with teams to support reporting and analytics needs. Strong proficiency in SQL and cloud platforms is preferred. The role offers a hybrid work model and a competitive benefits package.

Qualifications

• 9–11 years of experience in data engineering, ETL, and data warehousing.
• Strong hands-on experience with Informatica IICS.
• Expertise in dimensional modeling and data governance.

Responsibilities

• Define and design end-to-end data architecture.
• Lead data modeling initiatives using dimensional modeling techniques.
• Optimize data integration workflows for performance.

Skills

ETL development

Data modeling

Informatica IICS

SQL

Cloud platforms (AWS, Azure, GCP)

Data quality frameworks

Python/Spark

Education

Bachelor's degree in relevant field

Tools

Informatica Intelligent Cloud Services

Snowflake

Power BI

Tableau

Job description

## Data Engineering ArchitectApplyremote type: Hybridlocations: Bangalore India - Outer Ring Roadtime type: Full timeposted on: Posted Todayjob requisition id: JR-0015197Huron 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 strong 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 into data models and warehouse designs* Partner with BI and analytics teams to ensure data structures support reporting, dashboards, and advanced analytics* Collaborate with cloud and enterprise architecture teams* Oversee implementation of data warehouse solutions, including schema design, ETL development, and deployment* Support UAT, production rollout, and performance tuning of warehouse environments* Drive CI/CD and automation practices for data engineering workflows**Preferences:*** 9–11 years of experience in data engineering, ETL, and data warehousing* Strong hands-on experience with Informatica IICS (Cloud Data Integration, Application Integration)* Proven experience in data warehouse modeling and implementation* Expertise in dimensional modeling (fact tables, dimensions, SCDs, conformed dimensions)* Strong proficiency in SQL and performance tuning* Experience designing and implementing enterprise data warehouses and data marts* Knowledge of cloud platforms (AWS, Azure, or GCP)* Strong understanding of data governance, data quality, and metadata management* Experience with modern cloud data warehouses (Snowflake, Redshift, BigQuery, Databricks)* Familiarity with IICS Data Quality (IDQ)* Knowledge of Data Vault or hybrid modeling approaches* Experience with Python/Spark for data processing* Exposure to BI tools (Power BI, Tableau, Looker)### ## ****Position Level****Manager### ## ****Country****India### About UsAt Huron, we’re redefining what a consulting organization can be. We go beyond advice to deliver results that last. We inherit our client’s challenges as if they were our own. We help them transform for the future. We advocate. We make a difference. And we intelligently, passionately, relentlessly do great work...together. Are you the kind of person who stands ready to jump in, roll up your sleeves and transform ideas into action? Then come discover Huron. Whether you have years of experience or come right out of college, we invite you to explore our many opportunities. Find out how you can use your talents and develop your skills to make an impact immediately. Learn about how our culture and values provide you with the kind of environment that invites new ideas and innovation. Come see how we collaborate with each other in a culture of learning, coaching, diversity and inclusion. And hear about our unwavering commitment to make a difference in partnership with our clients, shareholders, communities and colleagues. Huron Consulting Group offers a competitive compensation and benefits package including medical, dental, and vision coverage to employees and dependents; a 401(k) plan with a generous employer match; an employee stock purchase plan; a generous Paid Time Off policy; and paid parental leave and adoption assistance. Our Wellness Program supports employee total well-being by providing free annual health screenings and coaching, bank at work, and on-site workshops, as well as ongoing programs recognizing major events in the lives of our employees throughout the year. All benefits and programs are subject to applicable eligibility requirements. Huron is fully committed to providing equal employment opportunity to job applicants and employees in recruitment, hiring, employment, compensation, benefits, promotions, transfers, training, and all other terms and conditions of employment. Huron will not discriminate on the basis of age, race, color, gender, marital status, sexual orientation, gender identity, pregnancy, national origin, religion, veteran status, physical or mental disability, genetic information, creed, citizenship or any other status protected by laws or regulations in the locations where we do business. We endeavor to maintain a drug-free workplace.