Senior Associate - Data Analytics and Reporting

Department: IT

Employment Type: Permanent - Full Time

Location: Pune

Reporting To: Anish Kumar

Description

We're seeking a Senior Associate - Data Analytics & Reporting , who can turn complex data into actionable insights across business functions. You will design and build end-to-end analytics solutions using Microsoft Fabric (OneLake, Lakehouses, Warehouses, Notebooks, Data Pipelines), Power BI (semantic models, DAX, Report Server/Service), and robust SQL/database engineering (performance-tuned queries, stored procedures, ETL/ELT pipelines). The ideal candidate has hands-on experience modernizing analytics stacks, establishing governance & DevOps for BI, and partnering with stakeholders to drive measurable outcomes.

• Must speak English
• 5-7 years hands on experience with Power BI (Desktop & Service) delivering production grade dashboards and models.
• Advanced SQL expertise (query tuning, indexing, execution plans) across Azure SQL/SQL Server and at least one other RDBMS (PostgreSQL or MySQL).
• Microsoft Fabric production experience: building Lakehouse/Warehouse, using OneLake, Pipelines, and implementing Direct Lake datasets.
• Strong DAX and Power Query (M) skills; experience with incremental refresh, hybrid tables, composite models.
• Solid understanding of Kimball dimensional modelling, star/snowflake schemas, SCDs, and data vault concepts (nice to have).
• Experience with Git based source control and CI/CD for BI/data (Power BI deployment pipelines, Azure DevOps/GitHub).
• Knowledge of security & governance in Power BI/Fabric (RLS/OLS, sensitivity labels, tenant/workspace admin).

Proven ability to work with business stakeholders, uncover insights, and present findings.

Key Responsibilities

Power BI & Visualization

• Design, develop, and publish Power BI reports & dashboards with a strong emphasis on usability, performance, and storytelling.
• Build and maintain tabular/semantic models (dataset schemas, relationships, aggregations, incremental refresh, composite models).
• Author reusable DAX measures and calculation groups; implement row-level security (RLS) and object-level security (OLS).
• Manage deployment across Power BI workspaces; set up deployment pipelines, endorsements, and data lineage.

Microsoft Fabric (End-to-End Analytics)

• Implement solutions using Microsoft Fabric components: OneLake data hub, Lakehouse, Warehouse, Shortcuts, Pipelines (Data Factory experiences), Notebooks (PySpark), and Event streams when required.
• Orchestrate ingestion from first-/third-party sources, build medallion architecture (bronze/silver/gold) and optimize for Direct Lake / Direct Query scenarios.
• Govern artifacts via domains and workspaces, enforce data quality checks, and set up catalogue/lineage.

Data Engineering & SQL

• Develop performant SQL across engines (e.g., Azure SQL Database/MI, SQL Server, Fabric Warehouse, Synapse-SQL, PostgreSQL/MySQL).
• Tune queries, indexes, and partitioning; write stored procedures/functions and optimize ETL/ELT steps.
• Build and maintain data models (star/snowflake), data marts, and conformed dimensions adhering to best practices.

Data Integration & Quality

• Use Fabric Data Factory (or Azure Data Factory) and Pipelines for ingestion from APIs, files (Parquet/Delta), SaaS (Dynamics 365, Salesforce), and on-prem sources via gateways.
• Implement CI/CD for BI/data artifacts (YAML pipelines or Git integration), automated testing/validation, and alerting.
• Apply data quality rules, profiling, and reconciliation processes; maintain documentation and data dictionaries.
• Security, Governance & Operations
• Enforce security & compliance (RLS/OLS, sensitivity labels, data loss prevention policies, tenant settings).
• Manage gateway configurations, capacity settings (Pro/Premium/Fabric), and resource utilization (refresh schedules, query caching).
• Collaborate with InfoSec, Data Governance, and Platform teams to align with enterprise standards.

Stakeholder Engagement

• Partner with business owners (Finance, Operations, Sales, Supply Chain, etc.) to define KPIs and success criteria.
• Translate ambiguous requirements into technical specifications and deliver iterative prototypes.

Provide enablement/training and build a community of practice for self-service BI.

Skills, Knowledge and Expertise

• 4-7 years of hands-on experience in Power BI development, including Power BI Desktop, Service, DAX, Power Query, and data modelling.
• Bachelor's degree in computer science, Information Technology, Engineering, or a related field.
• Microsoft Power BI or other relevant BI/analytics certifications are preferred
• Experience with Azure data services: Data Factory, Databricks, Synapse Analytics, Event Hub, Azure Functions, Key Vault, Purview (governance/catalog).
• Scripting in Python/PySpark for notebooks, data wrangling, and ML adjacent analytics.
• Exposure to NoSQL (Cosmos DB, MongoDB) and streaming use cases (Kafka/Event streams).
• Performance tuning for large models (aggregations, calculation groups, composite models at scale).
• Familiarity with finance/supply chain analytics (P&L, working capital, OTIF, inventory turns, demand planning).
• Power BI Desktop/Service, Power BI Report Builder (for paginated), Tabular Editor, DAX Studio, SQL Server Management Studio/Azure Data Studio, Git (Azure DevOps/GitHub), Microsoft Fabric (OneLake, Lakehouse, Warehouse, Pipelines, Notebooks).
• Issue tracking and collaboration: Azure Boards/Jira, Confluence/SharePoint, Teams

• Certification if any | Microsoft PL-300, Microsoft DP-600, Microsoft DP-700