Job Title : Analytics Data Modeler

Experience : 5+ Years

Location : Pune

Job Summary :

We are seeking an experienced Analytics Data Modeler to bridge the gap between business stakeholders and data engineering teams. The role involves gathering business requirements, defining KPIs, designing dimensional data models, and using SQL for data analysis and validation.

Key Responsibilities :

- Gather and document business and reporting requirements.

- Translate business needs into functional and technical specifications.

- Design data models (Star Schema, Fact & Dimension Models).

- Create source-to-target mappings and data specifications.

- Use SQL for data profiling, analysis, and validation.

- Define KPI and metric logic.

- Collaborate with Data Engineers and BI teams.

- Maintain data documentation and governance standards.

Required Skills :

- Strong SQL skills.

- Experience in Data Modeling and Data Warehousing, Azure Data Brick.

- Knowledge of Star Schema, Dimensional Modeling, Fact & Dimension Tables.

- Business Requirements Gathering and Stakeholder Management.

- Data Analysis, Data Quality, and Documentation.

- Excellent communication skills.