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.
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.
-
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
We are a specialist professional services and technology firm, working in partnership with leading insurance, highly regulated and global businesses.
We help our clients to manage risk, operate their core business processes, transform and grow. We deliver professional services and technology solutions across the risk and insurance value chain, including excellence in claims, underwriting, distribution, regulation & risk, customer experience, human capital, digital transformation & change management.
Our global team of more than 8,000 professionals operate across ten countries, including the UK & the U.S. Over the past ten years Davies has grown its annual revenues more than 20-fold, investing heavily in research & development, innovation & automation, colleague development, and client service. Today the group serves more than 1,500 insurance, financial services, public sector, and other highly regulated clients.
