Data Warehouse Architect

6 days ago

Bengaluru Noida Pune, India Accion Labs Full time ₹ 20,00,000 - ₹ 25,00,000 per year

Experience: 10-18 years

NP: Immediate joiners are preferred or candidates serving NP can join within 20 days

Key Responsibilities:

  • Design and architect end-to-end data warehouse solutions using modern data platforms
  • Define data models (star/snowflake schema), data marts, and OLAP structures
  • Create and manage ETL/ELT pipelines to ingest data from various sources (structured, semi-structured)
  • Collaborate with business and data teams to translate requirements into scalable data architecture
  • Ensure data quality, governance, security, and compliance standards are met
  • Optimize data storage and query performance for analytical workloads
  • Develop data strategy and roadmap aligned with business objectives
  • Guide and mentor data engineering teams on best practices

Required Skills and Experience:

  • Strong experience with data warehousing concepts, architecture, and best practices
  • Expertise in dimensional modeling, data lakes, and data marts
  • Hands-on experience with one or more cloud platforms
  • Proficiency with ETL/ELT tools
  • Excellent SQL and performance tuning skills
  • Familiarity with DevOps, CI/CD for data pipelines, and version control (Git)
  • Strong understanding of data governance, cataloging, and security
  • Experience with BI tools (Power BI, Tableau, etc.) is a plus

Required skills:

Tools & Technologies Cloud Platform : Azure (Data Bricks, DevOps, Data factory, azure synapse Analytics, Azure SQL, blob storage, Databricks Delta Lake)

Languages : Python/PL/SQL/SQL/C/C++/Java

Databases : Snowflake/ MS SQL Server/Oracle

Design Tools : Erwin & MS Visio.

Data warehouse tools : SSIS, SSRS, SSAS. Power Bi, DBT, Talend Stitch, PowerApps, Informatica 9, Cognos 8, OBIEE.

Any cloud exp is good to have.

  • Cloud Data Warehouse Architect

    7 days ago

    Bengaluru, India Mount Talent Consulting Pvt Ltd. Full time

    Data Architecture experience in Data Warehouse, Snowflake+ DBTSnowflake + snowflake advanced certification - Oversees and designs the information architecture for the data warehouse, including all information structures i.E. staging area, data warehouse, data marts, operational data stores, oversees standardization of data definition, Oversees development...

  • Data Architect

    6 days ago

    Pune, India NTT DATA Full time

    **Req ID**:229970 We are currently seeking a Data Architect to join our team in Pune, Mah\u0101r\u0101shtra (IN-MH), India (IN). **Technical Skill Sets (mandatory)**: - Must have significant level knowledge on implementing cloud data warehouses - Snowflake, AWS Redshift, Azure SQL Data Warehouse, or Google BigQuery experience considered - Must have...

  • Data Architect

    6 days ago

    Pune, India NTT Data Services Full time

    **Req ID**: 229970 We are currently seeking a Data Architect to join our team in Pune, Mahārāshtra (IN-MH), India (IN). Technical Skill Sets (mandatory): - Must have significant level knowledge on implementing cloud data warehouses - Snowflake, AWS Redshift, Azure SQL Data Warehouse, or Google BigQuery experience considered - Must have significant level...

  • Data Architect

    10 hours ago

    Noida, India Impetus Technologies Full time

    Do you want to work with the best minds in the industry, create high-performance scalable solutions? Do you want to be part of the team that is solutioning next-gen data platforms? Then this is the place for you. You want to architect and deliver solutions involving data engineering on Petabyte scale of data, that solve complex business problems Impetus is...

  • AWS data warehouse architect/engineer

    3 weeks ago

    Bengaluru, India Hcxp Consulting Full time

    Data marts using AWS services (Redshift, Aurora, RDS), Data modelling (Star schema, Snowflake),Perf tuning (compression, materialised views), Architecting scalable data warehouses using AWS Redshift, Athena,Glue, Batch analytics using Kinesis, Lambda

  • AWS data warehouse architect/engineer

    1 week ago

    Bengaluru, Karnataka, India Hcxp Consulting Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    Data marts using AWS services (Redshift, Aurora, RDS), Data modelling (Star schema, Snowflake),Perf tuning (compression, materialised views), Architecting scalable data warehouses using AWS Redshift, Athena,Glue, Batch analytics using Kinesis, Lambda

  • Data Architect

    1 week ago

    Noida, India Zenon Analytics Private limited Full time

    Sr. Data Architect / Data Architect Experience: 10+ Years Summary: The Data Architect will design and implement data solutions that support the organization’s strategic business goals. Responsibilities: • Focuses on enterprise-wide data modelling and database design. • Tests, monitors, manage and validate data warehouse activity including...

  • Data Architect

    1 week ago

    Noida, India Zenon Analytics Private limited Full time

    Sr. Data Architect / Data Architect Experience: 10+ Years Summary: The Data Architect will design and implement data solutions that support the organization’s strategic business goals. Responsibilities: • Focuses on enterprise-wide data modelling and database design. • Tests, monitors, manage and validate data warehouse activity including data...

  • Data Architect

    2 weeks ago

    Bengaluru, Noida, Pune, India Happiest Minds Technologies Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Role & responsibilitiesArchitect and design end-to-end data solutions on Azure, with a focus on Databricks. Lead data architecture initiatives, ensuring alignment with best practices and business objectives. Collaborate with stakeholders to define data strategies, architectures, and roadmaps. Migrate and transform data from Oracle to Azure Data Lake. Ensure...

  • Senior Data Architect

    6 days ago

    Bengaluru, India Mount Talent Consulting Pvt Ltd. Full time

    Data Architecture experience in Data Warehouse, Snowflake+ DBT Snowflake + snowflake advanced certification - Oversees and designs the information architecture for the data warehouse, including all information structures i.E. staging area, data warehouse, data marts, operational data stores, oversees standardization of data definition, Oversees development...