Datawarehouse Consultant

About The Opportunity

A fast-scaling technology services firm operating in the Enterprise Data & Analytics domain, we specialize in designing, deploying, and optimizing modern data warehouse architectures for clients across BFSI, Retail, and Manufacturing sectors. We enable data-driven decision-making through scalable cloud-based data platforms, ETL/ELT pipelines, and BI-ready semantic layers—powering dashboards, AI/ML models, and real-time analytics.

Role & Responsibilities

• Design and implement enterprise-grade data warehouse architectures on cloud platforms (Snowflake, Redshift, BigQuery) and on-prem (Teradata, SQL Server).
• Develop and optimize ETL/ELT workflows using tools like Informatica, Talend, Azure Data Factory, or AWS Glue for high-volume, complex data ingestion and transformation.
• Collaborate with stakeholders to define data models (star/snowflake schemas), dimensional modeling, and data lineage documentation.
• Ensure data quality, governance, and performance tuning across staging, ODS, and DWH layers with automated validation and monitoring.
• Integrate data warehouses with BI tools (Tableau, Power BI, Looker) and support semantic layer creation for business users.
• Lead client workshops, gather requirements, and deliver technical documentation aligned with enterprise data strategies.
  
  

• Snowflake
• Redshift
• BigQuery
• Informatica
• Talend
• Azure Data Factory
• SQL
• Dimensional Modeling
  
  

• Apache Airflow
• dbt
• Power BI
  
  

• Work with Fortune 500 clients across global industries and solve high-impact data challenges.
• Access to certified training programs and cloud platform certifications (AWS/Azure/GCP).
• Performance-driven culture with clear growth paths into Lead/Architect roles.