1. Home
  2. Jobs
  3. Jobs in Pune
  4. Analytics Engineer, Data Modeling, Semantic Layer, Azure Databricks
Agent
Jobs
Applied
Tracker
Profile
    1. Jobs for you
    2. Job

    Job · 23932587

    Akzo Nobel India logo

    Analytics Engineer, Data Modeling, Semantic Layer, Azure Databricks

    Akzo Nobel India · Pune · hybrid · Posted today

    Undisclosed4–9 yrsfulltimeSourced fromNaukri

    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

    PysparkSQLDesignAzure DatabricksStakeholder ManagementData Modeling

    About AkzoNobel

    Akzo Nobel India logo

    Akzo Nobel India

    Chemicals

    1.6k+

    employees

    1939

    87 years old

    Amsterdam

    IN

    ₹10.1L PA avg

    Avg at AkzoNobel

    About

    About AkzoNobel Since 1792, we’ve been supplying the innovative paints and coatings that help to color people’s lives and protect what matters most.

    Industries

    ChemicalsChemicals / Agri InputsManufacturing

    Employee ratings

    0 reviews

    4.1/ 5

    Employees rate it well for

    Overall Company41Company Culture40

    Find them on

    WebsiteLinkedInAmbitionBox reviews

    Jobs in Pune

    Career guides

    • Does Auto-Apply Hurt Your Chances? What the Callback Data Says, and Safe Limits (2026)
    • Can AI Apply to Jobs for Me? Yes - Here's What It Can and Can't Do (2026)
    • Can ChatGPT Apply to Jobs for You? What It Can and Can't Do on Naukri, LinkedIn and Greenhouse (2026)

    All career guidesAll articlesBrowse companies hiring

    Analytics Engineer, Data Modeling, Semantic Layer, Azure Databricks · waiting for your command