EXL Logo

EXL

Power BI / Insurance Analytics Developer

Posted Yesterday
In-Office or Remote
Hiring Remotely in Canada
Senior level
In-Office or Remote
Hiring Remotely in Canada
Senior level
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.
The summary above was generated by AI
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.
SQL and Data
  • 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.
Insurance Analytics
  • 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.
Responsibilities
  • 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.
Qualifications
  • 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.

Similar Jobs

8 Hours Ago
Remote or Hybrid
121K-193K Annually
Senior level
121K-193K Annually
Senior level
AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Leads Expedia B2B Operations’ global business enablement portfolio, focusing on continuous improvement, process design, automation, AI-enabled servicing, operational readiness, governance, crisis response, and partner communications. The role redesigns workflows, builds business cases, improves service and financial metrics, governs operational changes, supports launches, and drives adoption across teams, vendors, partners, Product, and Technology.
Top Skills: Artificial IntelligenceAutomationConversations ApiLean Six SigmaProcess MappingProperty Message CentreRoot-Cause AnalysisSix Sigma
9 Hours Ago
Remote or Hybrid
172K-257K Annually
Senior level
172K-257K Annually
Senior level
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Lead approximately 10 senior Account Executives on an outbound mid-market sales team. Responsibilities include hiring and developing talent, coaching through pipeline and performance data, forecasting, improving sales processes, establishing operating rhythms, and partnering with Sales Leadership, Marketing, Enablement, Operations, and Product. The role focuses on building a high-performance organization, strengthening pipeline quality, improving execution, and developing future sales leaders.
Top Skills: AfterpaySquare
14 Hours Ago
In-Office or Remote
Junior
Junior
Big Data • Information Technology • Software • Analytics • Energy
Provide frontline support for Enverus software applications through phone, email, and virtual screen sharing. Diagnose and resolve technical issues, manage customer cases, document and escalate product problems, educate users on navigation and product value, communicate updates, and relay client feedback to internal teams. The role requires strong communication, troubleshooting, organization, conflict resolution, collaboration, and customer-service skills, with rotating holiday support possible.
Top Skills: Generative AiSaaSVirtual Screen Sharing

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account