Data Architect (Senior/Lead)

10 years

0 Lacs

Posted:20 hours ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Data Architect – : 10+


  • Kimball Data Modeling, Dimensional Modeling, Star Schema, Fact and Dimension Tables, Slowly Changing Dimensions (SCD), Data Warehouse Design, Conceptual, Logical, and Physical Data Models, Enterprise Data Modeling, Data Modeling Tools (e.g., ER/Studio, Erwin, PowerDesigner)

Key Responsibilities:

  • Participate in Requirement workshops/ Backlog refinement workshop to understand data requirements for the project.
  • Lead the design and implementation of enterprise-grade data models, with a strong focus on Kimball dimensional modeling and star schemas to support analytics and reporting needs.
  • Build and maintain conceptual, logical, and physical data models using industry-standard tools (e.g., ER/Studio, Erwin).
  • Collaborate closely with Data Analysts, Data Stewards and the Data Governance team to ensure alignment of data models with business requirements and governance standards.
  • Architect and optimize data pipelines, ensuring efficient data ingestion, transformation, and integration across diverse systems.
  • Translate business requirements into scalable data architecture solutions that support real-time and historical analytics.

Mandatory Skills & Experience:

  • 10+ years of experience in Data architecture, Data modeling and Data analysis skills.
  • Proven expertise in Dimensional data modelling, Kimball modeling techniques and data warehouse design.
  • Proficiency in SQL for data transformation, automation, and querying.
  • Experience with ETL/ELT processes,
  • Familiarity with Data lakes and Lakehouse architecture
  • Familiarity with data integration tools, and data pipeline orchestration.
  • Strong communication and stakeholder management skills, with the ability to work in agile teams and participate in sprint ceremonies.
  • Experience withAzure Databricks, Azure Data Lake, and related cloud- solutions is desirable.
  • Exposure to SAP ERP data is desirable

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You