Job DescriptionDear Candidate, NGreetings from AkzoNobel (Experts in the proud craft of making paints and coatings since 1792) NWe are hiring for the role of Senior Data Modeler at Pune (Hybrid role), below are additional details as required. NSkills - Design & Architecture, Azure Databricks, Data Modeling, SQL etc. NAbout the rolenWere looking for a business-facing Analytics Data Modeler to act as the bridge between stakeholders and our data & engineering teams. Youll own 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. NThis is a hybrid between a data modeler and an analyst: hands-on with SQL and data profiling, but also leading conversations with the business to shape what we build. NWhat youll donnBusiness & requirements* N Work closely with business stakeholders to understand goals, KPIs, and processes. N Lead workshops and interviews to gather and structure reporting/analytics requirements. N Translate business needs into exact functional and technical requirements. N Define and maintain business definitions for core entities, metrics, and KPIs. N Data modeling & design (no report building)* N Design logical and physical data models for the enterprise reporting layer (e.G., star schemas, dimensional models, semantic entities). N Create and maintain source-to-target mappings and transformation specifications. N Define data contracts and interface specifications between source systems, the warehouse, and BI layers. N Work closely with data engineers and BI developers so that models are implemented correctly and efficiently. N Hands-on data work (SQL& analysis)* N Use SQL to explore and profile source data, validate assumptions, and assess data quality. N Write SQL to prototype data transformations and models (e.G., views, CTEs, dbt models, or equivalent in your stack). N Trace metrics and attributes end‐to‐end: from business definition to underlying source fields and logic.



N Support engineers and BI developers with clear specifications, test cases, and acceptance criteria. N Governance, quality & documentation* N Own functional and technical documentation for your domains (definitions, models, mappings, logic). N Help establish and enforce standards for modeling, naming, and metric definitions. N Contribute to data quality rules and acceptance tests for critical datasets. N Act as a subject-matterexpert for what data means and how it should be modeled." NnWhat you'll bring NMust-haves: Nn Experience in a BI / analytics-oriented role (e.G., BI Analyst, Analytics Engineer, Data Modeler, Functional Analyst, or similar). N Strong SQL skills;comfortable with complex joins, aggregations, and investigative queries. N Practical experience designing data models for analytics and reporting (dimensional/star schema, fact/dimension concepts, slowly changing dimensions, etc.). N Demonstrated ability togather and refine business requirements and convert them into technical specs and models. N Strong communication skills with the ability to talk to both business stakeholders and technical teams. N Proactive, hands-on mindset; you take ownership, askquestions, and drive clarity rather than waiting for perfect input. NnNice-to-haves (adapt to your environment): Nn Experience with enterprise data warehouses and modern cloud platforms (e.G., Snowflake, BigQuery, Redshift, Azure Synapse). N Familiarity with data modeling tools (e.G., ER/Studio, ERwin, db docs, Lucidchart, etc.). N Understanding of ETL/ELT concepts and how pipelines support your models (without necessarily building the pipelines yourself). N Experience in [your industry] and knowledge of common KPIs and data domains. NnWhat success lookslike Nn Stakeholders see their needs accurately reflected in data models and validated datasets. N Data engineers and BI developers have transparent, unambiguous specifications and models to build from. N Core entities and metrics are consistently defined, reducing rework and misinterpretation. N You become the go‐to person for how things should be modeled and what the data really means. NnRegards,nTeam AkzoNobel

📌 Senior Data Modeler (Pune)
🏢 AkzoNobel
📍 Pune