Data Warehousing Architect

2 days ago

Gurgaon, Haryana, India GENESIIS HRADVISORS Full time ₹ 12,00,000 - ₹ 36,00,000 per year

Description :

Company Name : GENESIIS HRADVISORS

Job Title : Data Warehousing Architect

Reports To : Director of Business Intelligence Engineering

Department : Business Intelligence Engineering

Location : Gurgaon (5 days working)

Work Experience : Min 10 yrs.

Qualification : B.E./ B.Tech and above

Position Summary :


The Data Warehousing Architect leads the development of the data warehouse and the execution of data flows to integrate data from multiple sources. This role is responsible for architecting and optimizing the Snowflake data warehouse and ensuring data structures support strategic initiatives across inventory, pricing, purchasing, finance, and network marketing.

Core Competencies & Responsibilities :

Data Architecture & Engineering :

- Lead the evaluation, planning, and implementation of new data platforms and frameworks including Snowflake and dbt, ensuring alignment with business needs and scalability goals.

- Own the design and evolution of the cloud data warehouse (e.g. Snowflake, Oracle Database Migration Services). Maintain the current operational Oracle data warehouse through the evolution process.

- Implement and manage tools for scalable ELT transformations (e.g. dbt). Maintain the current operational Oracle PL/SQL ETL process through the transition.

- Evaluate and implement real-time data ingestion and advanced processing tools (e.g. Snowpipe, Snowpark, Amazon Sagemaker Canvas) as part of the modernization roadmap.

- Ensure data models are optimized for performance, scalability, and business relevance.

2. Operational Process Support :

- Collaborate with teams in product management, operations, inventory, pricing, purchasing, compensation, sales, and finance to :

i. Understand evolving business processes.

ii. Ensure data structures support accurate, near real-time insights.

iii. Provide analytical support for process refinement and automation.

3. Industry-Specific Enablement :

- Support the Director of Business Analytics and Director of Business Intelligence Engineering in evaluating field-facing and product promotions. Support the business analytics teams in executing internal data analysis projects by providing timely and accurate data.

- Build data structures to analyze :

i. Sales trends

ii. Enrollment and retention trends

iii. Compensation trends, costs, and patterns

iv. Payout accuracy

v. Purchase and compensation fraud detection and management

vi. Effectiveness of promotional strategies

vii. Field-leader structures and performance

- Operationalize business analysis into repeatable, scalable reporting frameworks.

4. Governance, Quality & Compliance

- Establish and enforce data governance policies.

- Monitor data quality and implement cleansing strategies using predictive and prescriptive analytics.

- Ensure compliance with internal standards and external regulations.

- Lead development of the DW naming and governance standards.

- Collaborate with product, analytics, and IT teams to align data initiatives with business goals.

- Communicate effectively with executive stakeholders and translate technical concepts into business value.

Preferred Experience :

- Leading data platform migrations or greenfield implementations

- Experience with Snowflake, dbt, and Tableau Cloud

- Designing scalable data architectures for real-time analytics

- Supporting operational and industry-specific processes through data

- Excellent communication skills in English

  • Data Architect

    2 weeks ago

    Gurgaon, Haryana, India Multicloud4U® Technologies Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Description : Job Title : Azure/Snowflake Data Architect. Experience : 4 to 15 Years. Location : Gurugram.Skills : - Azure Data Factory. - SQL. - Oracle. - Snowflake. We are seeking a highly experienced Azure/Snowflake Data Architect with deep expertise in designing and implementing end-to-end data solutions on the Microsoft Azure...

  • Data Architect

    2 weeks ago

    Gurgaon, Haryana, India Multicloud4U® Technologies Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    DescriptionJob Title : Azure/Snowflake Data Architect.Experience : 4 to 15 Years.Location : Gurugram.SkillsAzure Data Factory.SQL.Oracle.Snowflake.We are seeking a highly experienced Azure/Snowflake Data Architect with deep expertise in designing and implementing end-to-end data solutions on the Microsoft Azure platform.The ideal candidate will have a strong...

  • Technical Architect

    2 weeks ago

    Gurgaon, Haryana, India Intersoft Data Labs Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Job Title: Technical Architect Data Engineering (Kafka / MongoDB / Python)Location: Intersoft Data Labs – Gurugram Development CentreExperience: 12+ YearsWork Mode: Hybrid / Onsite (Mostly Remote)Working Hours: Must overlap till 1:00 PM CST (Central Standard Time)Role OverviewIntersoft is seeking a Technical Architect – Data Engineering to lead the...

  • Data Architect

    7 days ago

    Gurgaon, Haryana, India USEReady Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role:Data ArchitectLocation:GurgaonDescription :We are seeking an experienced and strategic Data Architect to design, build, and manage our modern enterprise data platform. The ideal candidate will be a subject matter expert in Microsoft Azure data services, with deep, hands-on experience architecting solutions using Snowflake as the core data cloud...

  • Data Architect

    1 day ago

    Gurgaon, Haryana, India Sightspectrum Full time ₹ 8,00,000 - ₹ 20,00,000 per year

    Data architectLocation: GurgaonMode of working: Hybrid (3 days work from office)Key ResponsibilitiesArchitecture & StrategyDefine and drive the data architecture roadmap aligned with business and analytics goals.Design scalable and maintainable Lakehouse architectures using Azure services.Establish best practices for data modeling, storage, and processing...

  • Data Architect

    1 day ago

    Gurgaon, Haryana, India Pradeepit Consulting Services Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Title : Data ArchitectLocation: GurgaonMode of working: Hybrid (3 days work from office)Exp-12+ YrsKey ResponsibilitiesArchitecture & StrategyDefine and drive the data architecture roadmap aligned with business and analytics goals.Design scalable and maintainable Lakehouse architectures using Azure services.Establish best practices for data modeling,...

  • Data Architect

    2 weeks ago

    Gurgaon, Haryana, India AuxoAI Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Location :Description :As a Data & Analytics Architect, you will lead key data initiatives, including cloud transformation, data governance, and AI projects.You'll define cloud architectures, guide data science teams in model development, and ensure alignment with data architecture principles across complex solutions.Additionally, You Will Create And Govern...

  • Azure Data Architect

    2 days ago

    Gurgaon, Haryana, India Multicloud4U® Technologies Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Title: Azure Data ArchitectExperience: 8 to 15 YearsLocation: GurugramSkills: Azure Data FactorySQLOracleWe are seeking a highly experienced Azure Data Architect with deep expertise in designing and implementing end-to-end data solutions on the Microsoft Azure platform. The ideal candidate will have a strong background in SQL Server, SSIS, Azure...

  • Principal Data Architect

    5 days ago

    Gurgaon, Haryana, India Hirly Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    We are seeking a Principal Data Architect to lead our Data Platforms Team and drive innovation in data engineering, analytics, and governance. Role Overview : As a Principal Data Architect, you will be responsible for leading the design, development, and scaling of our data infrastructure. You will collaborate with product managers, data scientists,...

  • AWS Data Lake Architect

    7 days ago

    Gurgaon, Haryana, India Care Health Insurance Full time ₹ 25,00,000 - ₹ 40,00,000 per year

    AWS Data Lake ArchitectWe are seeking a highly experienced and hands-on AWS Data Lake Architect to lead our transition from a managed service provider to a dedicated in-house team. The ideal candidate will have 5-8 years of experience in data architecture and a proven track record of taking ownership of existing data platforms. This is a unique opportunity...