AkzoNobel logo

Data Modeling Analyst - Azure Databricks

AkzoNobel

4 - 9 years

Pune

Posted:19 hours ago

Job Description

Dear Candidate,

Greetings from AkzoNobel (Experts in the proud craft of making paints and coatings since 1792)

Data Modeling Analyst

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

Skills Required

Requirements SQL Data modeling ETL Management Microsoft Azure Modeling Data analysis

Learn the skills this job asks for

See your skill gap for Data Engineer →

Free courses, interview questions and practice for each skill.

Work Mode

Hybrid

Job Type

Full Time

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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
AkzoNobel logo
AkzoNobel

RecommendedJobs for You