Senior Associate – Data Analytics, Reporting

Role Overview

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

Requirements

• 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).

Tech Stack

• Azure
• ETL
• MySQL
• Postgres
• PySpark
• RDBMS
• SQL
• Vault