18 Nov
|
AkzoNobel
|
India
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 transparent 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
📌 Data Modeling Analyst (India)
🏢 AkzoNobel
📍 India