Data Warehouse Consultant

Overview

We are seeking an experienced Data Warehouse Consultant responsible for designing, developing, and optimizing enterprise data warehouse solutions. The role involves working closely with business stakeholders, data engineers, and analytics teams to build scalable, reliable, and high-performance data platforms that support reporting, analytics, and business intelligence.

Responsibilities

• Design, develop, and optimize enterprise data warehouse solutions that support reporting, analytics, and business intelligence.
• Collaborate with business stakeholders, data engineers, and analytics teams to translate requirements into scalable data platforms.

Technical Expertise

• Strong experience in Enterprise Data Architecture, including:
  • EDW modernization
  • Data Lake / Lakehouse architectures
• Deep understanding of BFSI data domains and enterprise reference models:
  • FSLDM
  • FSAS
  • Cloudera CDP (HDFS, Spark, Hive, Kafka)

Governance & Compliance

• Metadata and lineage
• Data quality frameworks
• Security, masking, and encryption
• Strong understanding of regulatory and compliance-driven data platforms.

Non-Functional Design

• Performance and workload optimization
• Scalability and capacity planning
• Resilience, backup, and recovery design