Functional Engineer Reporting-DataBricks

AkzoNobel; Mhalunge; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

AkzoNobel is seeking a Business-facing Analytics Data Modeler to bridge stakeholders and data/engineering teams in Pune/remote India. You will own the middle layer, translate business needs into technical data models, and lead conversations to shape analytics capabilities.

The role combines data modeling with hands-on SQL, data profiling, and governance. You will collaborate with BI developers and data engineers to ensure accurate, scalable models across the enterprise.

Qualifications

• Strong SQL skills with complex joins, aggregations, and investigative queries.
• Practical experience designing analytics data models (dimensional/star schemas) and understanding of slowly changing dimensions.
• Ability to translate business requirements into technical specifications and data models.
• Excellent communication skills to interact with business stakeholders and technical teams.

Responsibilities

• Work with business stakeholders to understand goals, KPIs, and processes.
• Lead workshops/interviews to gather analytics requirements.
• Translate business needs into functional/technical requirements.
• Define and maintain business definitions for core entities, metrics, and KPIs.
• Design logical/physical data models for enterprise reporting (star schemas, semantic entities).
• Create and maintain source-to-target mappings and transformation specs.
• Define data contracts between source systems, warehouse, and BI layers.
• Collaborate with data engineers/BI developers for correct implementation.
• Perform hands-on data work (SQL) to profile data and prototype transformations.
• Document modeling standards and governance rules; own domain definitions.

Skills

SQL proficiency

Data modeling (star schema)

Requirements gathering

Communication with stakeholders

Hands-on data profiling

Tools

Snowflake

BigQuery

Redshift

Azure Synapse

ER/Studio or Lucidchart

Job description

About the role -

We are 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. This 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.

What youll 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 modeling & design (no report building)*
• 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 equivalent in your 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 a subject-matter expert for what 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.
• Proactive, hands-on mindset; you take ownership, ask questions, and drive clarity rather than waiting for perfect input. Nice-to-haves (adapt to your environment):
• Experience with enterprise data warehouses and modern cloud platforms (e.g., Snowflake, BigQuery, Redshift, Azure Synapse).
• Familiarity with data modeling tools (e.g., ER/Studio, ERwin, db docs, Lucidchart, etc.).
• Understanding of ETL/ELT concepts and how pipelines support your models (without necessarily building the pipelines yourself).
• Experience in [your industry] 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 modeled and what the data really means.