Description :

Job Title : Data Architect

Job Summary :

We are seeking an experienced Data Architect to design, govern, and evolve scalable enterprise data architectures. The role will focus on dimensional data modeling, enterprise data warehouse (EDW) design, and operational data stores (ODS) to support analytics, reporting, and business intelligence use cases.

The ideal candidate will bring strong expertise in star and snowflake schemas, data modeling best practices, and the ability to translate business requirements into robust, high-quality data models.

Key Responsibilities :

- Define and maintain enterprise data architecture standards, principles, and best practices

- Design and implement conceptual, logical, and physical data models for enterprise systems

- Lead dimensional modeling efforts for analytical platforms, including Star and Snowflake schemas

- Define and manage fact tables, dimension tables, and grain definitions to ensure analytical consistency

- Architect and evolve Enterprise Data Warehouse (EDW) and Operational Data Store (ODS) solutions

- Develop and maintain data models using industry-standard tools such as ERwin, ER/Studio, PowerDesigner, SAP PowerDesigner, Toad Data Modeler, Enterprise Architect, Lucidchart, and MS Visio

- Ensure alignment between business requirements, data models, and downstream BI/reporting layers

- Establish and enforce data standards, naming conventions, and modeling guidelines

- Collaborate with data governance teams to ensure data quality, integrity, and consistency

- Partner with business stakeholders, data engineers, BI teams, and solution architects to understand requirements and translate them into scalable data models

- Review and validate data designs produced by delivery teams

- Provide architectural guidance during EDW, ODS, and analytics platform implementations

- Create and maintain data architecture documentation, data dictionaries, and model repositories

- Evaluate and recommend improvements to data architecture frameworks and modeling practices

- Support impact analysis and change management for evolving data requirements

Required Skills & Experience :

Core Technical Skills :

- Strong expertise in Data Modeling and Dimensional Modeling

- Deep understanding of Star Schema, Snowflake Schema, Fact Tables, Dimension Tables, and Grain Definition

- Proven experience designing Enterprise Data Warehouses (EDW) and Operational Data Stores (ODS)

- Hands-on experience with data modeling tools such as ERwin, ER/Studio, PowerDesigner, SAP PowerDesigner, Toad Data Modeler, Enterprise Architect, Lucidchart, or MS Visio

- Strong understanding of relational database concepts and analytical data structures

Experience :

- 712 years of experience in Data Architecture, Data Modeling, or Enterprise Data Design roles

- Experience working on large-scale enterprise data platforms supporting analytics and reporting

- Proven ability to handle complex data domains and multi-source integrations

Education :

- Bachelors degree in Computer Science, Information Systems, Engineering, or a related field

- Masters degree or relevant data architecture certifications are a plus

Ideal Candidate Profile :

- Strong conceptual thinker with excellent data modeling and abstraction skills

- Detail-oriented with a deep focus on data accuracy and consistency

- Comfortable working in cross-functional, enterprise environments

- Able to balance strategic data architecture vision with hands-on modeling execution