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 New York, New York, USA Office
320 Park Avenue, 29th Floor, New York, NY, United States, 10022
EXL Jersey City, New Jersey, USA Office
Jersey City, United States, 0
EXL Newark, New Jersey, USA Office
Newark, United States
Similar Jobs
Artificial Intelligence • Fintech • Information Technology • Marketing Tech • Payments • Social Impact • Software
Leads and builds Donorbox’s product marketing function, owning positioning, messaging, product-led growth, launches, enablement, competitive intelligence, and performance measurement. Partners with Product, Sales, Customer Success, and Marketing to drive acquisition, conversion, retention, and expansion. Manages one direct report, establishes scalable processes and KPIs, influences roadmap priorities, and presents data-driven insights to executive leadership.
Top Skills:
Product-Led Growth (Plg)SaaS
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead and develop a Canada Scaled Customer Success team to drive onboarding, adoption, expansion, and renewals via digital scale programs. Hire and coach CSMs, manage KPIs/OKRs, improve processes and tooling, collaborate cross-functionally, and escalate high-stakes customer moments to ensure measurable customer outcomes.
Top Skills:
CRMCs PlatformDigital Engagement ToolsGainsightProduct AnalyticsTotango
.png){kind=logo}
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
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
