Data Modeling Analyst - Azure Databricks
Akzo Nobel India · Pune · hybrid · Posted today
About a minute. You'll make an account on the way through.
About this role
Dear Candidate,
Greetings from AkzoNobel (Experts in the proud craft of making paints and coatings since 1792)
We're looking for a business-facing Data Modeling Analyst to act as the bridge between our stakeholders and our data & engineering teams. You'll sit in the middle layer: understanding business needs, translating them into clear technical requirements, and designing the data models and specifications that enable robust enterprise reporting and analytics.
This is a hybrid between a data modeler and a business analyst hands-on with SQL and data profiling, but also leading conversations with the business to shape what we build at an enterprise level. You won't be building reports or dashboards yourself; you'll be defining the models and specs that make sure the people who do can build them right, the first time.
Mandatory Skills - Azure Databricks, Data Modelling, SQL, Stakeholder Management, Design, Requirement Gathering etc
What you'll do
Business & requirements
- Work closely with business stakeholders to understand goals, KPIs, and processes.
- Lead workshops and interviews to gather and structure reporting/analytics requirements.
- Translate business needs into precise functional and technical requirements.
- Define and maintain business definitions for core entities, metrics, and KPIs.
Data modelling & design
- Design logical and physical data models for the enterprise reporting layer (e.g., star schemas, dimensional models, semantic entities).
- Create and maintain source-to-target mappings and transformation specifications.
- Define data contracts and interface specifications between source systems, the warehouse, and BI layers.
- Work closely with data engineers and BI developers so that models are implemented correctly and efficiently.
Hands-on data work (SQL & analysis)
- Use SQL to explore and profile source data, validate assumptions, and assess data quality.
- Write SQL to prototype data transformations and models (e.g., views, CTEs, dbt models, or the equivalent in our stack).
- Trace metrics and attributes end-to-end: from business definition to underlying source fields and logic.
- Support engineers and BI developers with clear specifications, test cases, and acceptance criteria.
Governance, quality & documentation
- Own functional and technical documentation for your domains (definitions, models, mappings, logic).
- Help establish and enforce standards for modeling, naming, and metric definitions.
- Contribute to data quality rules and acceptance tests for critical datasets.
- Act as the subject-matter expert for "what our data means" and "how it should be modeled."
What you'll bring
Must-haves
- Experience in a BI / analytics-oriented role (e.g., BI Analyst, Analytics Engineer, Data Modeler, Functional Analyst, or similar).
- Strong SQL skills; comfortable with complex joins, aggregations, and investigative queries.
- Practical experience designing data models for analytics and reporting (dimensional/star schema, fact/dimension concepts, slowly changing dimensions, etc.).
- Demonstrated ability to gather and refine business requirements and convert them into technical specs and models.
- Strong communication skills, with the ability to talk to both business stakeholders and technical teams.
- A proactive, hands-on mindset you take ownership, ask questions, and drive clarity rather than waiting for perfect input.
- Experience with enterprise data warehouses and modern cloud platforms (e.g., Databricks).
Nice-to-haves (adapt to your environment)
- Familiarity with data modeling tools (e.g., ER/Studio, Erwin, dbt docs, Lucidchart, etc.).
- Understanding of ETL/ELT concepts and how pipelines support your models (without necessarily building the pipelines yourself).
- Experience in manufacturing and knowledge of common KPIs and data domains.
What success looks like
- Stakeholders see their needs accurately reflected in data models and validated datasets.
- Data engineers and BI developers have clear, unambiguous specifications and models to build from.
- Core entities and metrics are consistently defined, reducing rework and misinterpretation.
- You become the go-to person for how things should be modelled and what the data really means.
Regards,
Team AkzoNobel
Sourced from naukri
Skills
About AkzoNobel

Akzo Nobel India
Chemicals
1.6k+
employees
1939
87 years old
Amsterdam
IN
₹10.1L PA avg
Avg at AkzoNobel
About
Industries
Employee ratings
0 reviews
Employees rate it well for
Find them on