The Data Engineering Architect will design and implement data architecture for enterprise data warehouses, lead data modeling activities, optimize data workflows, and mentor teams. Responsibilities include ensuring data integrity and supporting analytics needs, while overseeing the implementation of data warehouse solutions.
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.
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)
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Develops and maintains ETL/ELT pipelines, legacy SSIS and SSAS solutions, reporting platforms, and relational and dimensional data models. Tunes SQL, data pipelines, semantic layers, and reporting workloads for performance and reliability. Supports Snowflake and cloud-native data platforms, documents data lineage and procedures, responds to ServiceNow incidents, and follows HIPAA, ITIL, governance, and change-control standards. Collaborates across technical and analytics teams while supporting healthcare data systems and modernization initiatives.
Top Skills:
Apache AirflowAzure Data FactoryAzure Machine LearningAzure SynapseCozyroc Ssis+DbtKronosPower BIPythonServicenowSnowflakeSQL ServerSsasSsisSsrsT-SqlTableauUkg
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Lead design and operation of a self-managed Enterprise MongoDB platform: set standards, own backups/restore, performance engineering, capacity planning, security hardening, incident leadership, documentation, and mentor junior administrators while partnering with infrastructure and application teams to standardize and automate operations.
Top Skills:
AnsibleCi/CdLinuxMongoDBMongodb Ops ManagerNutanixRbacReplica SetsShardingTerraformTls
Cloud • Information Technology • Security • Software
Provides Tier 1 technical support to SaaS customers through email, phone, chat, and remote sessions. Troubleshoots macOS, MDM, directory services, iOS management, software management, APIs, and user lifecycle issues. Manages high-priority tickets, reproduces defects, collaborates with engineering and product teams, supports customer onboarding, maintains knowledge-base content, and participates in on-call coverage.
Top Skills:
Ai Prompt EngineeringApple Mobile Device Management (Mdm)AptCentosDebianDepFilevaultGoogle WorkspaceiOSKeychainLdapLinuxmacOSOktaPamRest ApisRhelRpmScriptingSshUbuntuVolume Purchase Program (Vpp)Yum
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
