2+ Star schema Jobs in Pune | Star schema Job openings in Pune

Tech Stack: Power BI, DAX, SQL, Microsoft Fabric

The Role

You are the bridge between raw data and business decisions.You will be responsible for taking processed data and transforming it into high-performance, scalable semantic models. Your goal is to ensure that the data is structured so perfectly that building a report becomes the easiest part of the job.

Key Responsibilities

• Semantic Architecture: Design and build Star Schemas that serve as the single source of truth.
• Gold Layer Ownership: Transform Silver-layer tables into business-ready dimensions and facts.
• Advanced DAX: Write clean, optimized DAX for complex business logic (not just basic sums).
• Visual Storytelling: Build intuitive Power BI reports that focus on clarity and actionable insights.
• Performance Tuning: Optimize models for fast load times, query folding, and efficient refreshes.
• Stakeholder Sync: Work with clients to define KPIs and ensure the model actually answers their questions.

What We’re Looking For

• Modeling DNA: You think in Star Schemas and understand why a flat table is a bad idea for Power BI.
• DAX Proficiency: Deep understanding of Filter vs. Row context and time-intelligence functions.
• SQL Fluency: You can write complex queries to validate your models against the source data.
• Visual Logic: You have a sharp eye for UI/UX—no cluttered dashboards or "chart junk."
• Fabric Familiarity: Experience with (or a strong desire to learn) the Microsoft Fabric ecosystem.

Why Work With Us?

• Microsoft Partner Edge: Hands-on with the latest Fabric and Power BI features before they go mainstream.
• Flat Hierarchy
• Technical Autonomy: You own the Gold layer architecture; you set the modeling standards.
• High-Stakes Projects: Solve real data problems for enterprise clients in Healthcare and Government.
• Career Growth: Structured learning paths to master the wider Azure Data & AI stack.
• Competitive Pay
• Flexible Hours: We value outcomes over desk-time; flexible shifts to help you beat Pune traffic.

Hybrid work mode

(Azure) EDW Experience working in loading Star schema data warehouses using framework

architectures including experience loading type 2 dimensions. Ingesting data from various

sources (Structured and Semi Structured), hands on experience ingesting via APIs to lakehouse architectures.

Key Skills: Azure Databricks, Azure Data Factory, Azure Datalake Gen 2 Storage, SQL (expert),

Python (intermediate), Azure Cloud Services knowledge, data analysis (SQL), data warehousing,documentation – BRD, FRD, user story creation.