Analytics Engineer, Data Modeling, Semantic Layer, 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)
This is a data modeling and analytics engineering role, rather than a data pipeline / ingestion engineering role. You will take data that has already landed in our lakehouse and turn it into clean, governed, well-modeled, high-performance structures that power reporting, self-service analytics, and decision-making. You own the layer between raw data and business insight dimensional models, semantic layers, and Delta Lake tables designed for consumption, not the ETL/ELT jobs that move data into the platform.
If your background is primarily building ingestion pipelines, orchestrating ETL/ELT jobs, or managing data movement infrastructure, this is likely not the right fit. If you get energized by designing a fact table that will still make sense in three years, or building a semantic layer that lets a business user self-serve without asking "which table do I use," this is exactly the role.
Mandatory skills - Kimball dimensional modeling, Azure Databricks, Delta Lake, Unity Catalog, Python, SQL, and PySpark
About the role
As an Analytics Engineer, you sit at the intersection of data, technology, and business value. Your primary responsibility is to design and build robust, scalable data models fact/dimension models and semantic layers that power analytics, reporting, and data-driven decision-making across the organization. You work closely with stakeholders to translate business questions into well-structured, reusable data models, and with BI Analysts to make sure those models are genuinely easy to build reports on.
You are hands-on: writing clean PySpark/SQL to build and optimize tables, applying dimensional modeling principles, and structuring data in Databricks so it's fast, trustworthy, cost efficient and built to last not just working today, but scaling as the business and data volumes grow.
Responsibilities
Data modeling (core focus)
- Design and build dimensional data models (fact & dimension tables) using Kimball modeling principles, optimized for analytics and reporting workloads.
- Design and maintain Delta Lake tables in Databricks structured specifically for efficient, high-performance querying and reporting not for raw ingestion.
- Build and maintain semantic layers that enable self-service analytics, giving business users and BI Analysts a single, trusted, well-documented source of truth.
- Own data modeling standards, naming conventions, and structure across the analytics layer to ensure consistency and quality across projects.
- Continuously evolve models to be future-proof: anticipate new business questions and data sources rather than re-architecting reactively.
- Optimize table design, partitioning, and query patterns to balance performance with cost efficiency on Databricks (compute usage, storage, and job runtime).
Collaboration & translation
- Work directly with business stakeholders to translate ambiguous business needs into scalable, well-designed data models.
- Partner closely with BI Analysts to ensure models support fast, flexible reporting and dashboarding.
- Manage and govern data assets using Unity Catalog, ensuring proper access control, documentation, and discoverability.
Delivery
- Write clean, well-documented, efficient code and maintain clear data documentation so models are understandable and maintainable by others.
- Participate in the full project lifecycle — requirements, design, build, testing, and change management — in an Agile/DevOps environment.
- Contribute to ongoing process improvement in how the team builds and governs data models.
(Note: you will consume data that has already been ingested by upstream pipelines; building or maintaining ingestion/ETL pipelines is not the core focus of this role.)
Skills & Qualifications
- Strong, demonstrable expertise in data modeling — fact/dimension modeling and semantic layer design — this is the core skill we're hiring for.
- Solid understanding of Kimball dimensional modeling methodology, with examples of models you've designed.
- Hands-on experience with Databricks, Delta Lake, and Unity Catalog.
- Proficiency in Python, SQL, and PySpark for building and transforming data models (as distinct from ingestion pipelines).
- General familiarity with ETL/ELT concepts is helpful for collaborating with data engineering, but this is not a pipeline-building role.
- Excellent communication, documentation, and stakeholder-facilitation skills in English.
- Nice to have: knowledge of Azure services (ADLS, Synapse, ADF), experience with SAP data (BW/HANA/ingestion) as a data source, and familiarity with BI tools (Power BI, Tableau) to understand how your models get consumed.
Above all
You're an enthusiastic learner who enjoys working collaboratively and is genuinely excited about turning data into models that create real business value — built not just for today's insights, but to scale with the company.
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