Develop and maintain Power BI dashboards, reports, DAX measures, KPIs, and dimensional data models for insurance stakeholders. Write complex SQL for data extraction, transformation, reconciliation, and analysis. Investigate data-quality issues, validate reporting accuracy, optimize performance, and translate insurance business requirements into actionable analytics solutions. Collaborate with engineering, business, and analytics teams across multiple data sources.
Power BI
- Strong hands-on experience with Power BI Desktop and Power BI Service.
- Strong knowledge of DAX, Power Query, data modeling, relationships, drill-through, bookmarks, filters, and visualization best practices.
- Experience building complex dashboards and executive or business reporting solutions.
- Understanding of Power BI performance optimization and data model design.
- Strong SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and complex transformations.
- Experience analyzing and reconciling data across multiple tables and data sources.
- Good understanding of relational databases, dimensional modeling, and data warehousing concepts.
- Ability to investigate data-quality issues and independently perform root-cause analysis.
- Good understanding of insurance data and business processes, preferably within Property & Casualty insurance.
- Familiarity with policy, coverage, exposure, premium, claims, losses, reserves, limits, deductibles, brokers or agents, and underwriting.
- Ability to understand insurance KPIs and translate business questions into analytical reports and dashboards.
- Experience working with policy, claims, underwriting, or premium-related datasets is preferred.
- Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users.
- Develop efficient DAX measures, calculated columns, KPIs, and data models to support analytical and reporting requirements.
- Write and optimize complex SQL queries for data extraction, transformation, reconciliation, and analysis.
- Analyze large datasets to identify business trends, data issues, and actionable insights.
- Work with business stakeholders to understand requirements and translate them into reporting and analytical solutions.
- Perform data validation, reconciliation, and root-cause analysis to ensure reporting accuracy and consistency.
- Develop and maintain dimensional data models supporting reporting and analytics use cases.
- Collaborate with data engineering, business, and analytics teams to integrate data from multiple source systems.
- Apply insurance domain knowledge to interpret business data and develop meaningful KPIs and reporting solutions.
- Support report performance optimization, production issues, enhancements, and ongoing reporting needs.
- 4-6 years of overall experience in business intelligence, reporting, or data analytics.
- Hands-on experience with Power BI and SQL in enterprise reporting environments.
- Prior experience with an insurance carrier, broker, MGA, or insurance analytics organization is highly desirable.
- Exposure to Azure, Snowflake, Databricks, or SQL Server would be an advantage.
- Strong analytical thinking, problem-solving, and communication skills.
- Ability to interact with business stakeholders and independently convert requirements into technical solutions.
EXL London, England Office
London, United Kingdom
Similar Jobs
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Build and operate database and storage platform software, including services, APIs, and developer tools for provisioning, migrations, upgrades, and lifecycle management. Solve scaling, performance, reliability, and data correctness challenges across databases, distributed systems, cloud infrastructure, and networking. Partner with engineering teams on schemas and platform adoption, lead technical projects through rollout, participate in on-call response, and use AI-assisted tools in development.
Top Skills:
Ai-Assisted Engineering ToolsAmazon ElasticacheAPIsAWSAws AuroraBackend ServicesDynamoDBGoJavaKubernetesMySQLObservability ToolingOpensearchRedisRubyVitess
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead Samsara’s AI initiatives across the software development lifecycle, including developer agents and SRE AI. Manage five to ten senior engineers, set technical direction without an established roadmap, evaluate build-versus-buy decisions, control AI and infrastructure costs, scale automated incident response, and build trust in actions such as root-cause analysis, severity escalation, and deployment rollbacks. Partner directly with R&D leaders and developers while hiring, mentoring, and developing an inclusive, high-performing team.
Top Skills:
Ai AgentsClaudeCloud InfrastructureCodexIotModel Context Protocol (Mcp)Sre Automation
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Build agentic AI products that enable customers to create custom detections and workflows. Own solutions from customer discovery through design, implementation, deployment, monitoring, and ongoing improvement. Develop backend services, APIs, and customer-facing experiences while partnering with platform, machine learning, product, and design teams. Improve AI detection quality, reliability, performance, and cost, shape technical direction, and mentor engineers.
Top Skills:
Ai Coding AgentsAPIsCloud ComputingComputer VisionEdge ComputingIotLarge Language Models
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
