CrawlJobs Logo

BI Analyst - Claims (Power BI / SQL)

United States, Saint Louis Employment contract 90000.00 - 105000.00 USD / Year · Job Posted June 29, 2026
Apply Position
Job Link Share

Job Description

Tier4 Group is seeking a BI Analyst – Claims to support a high-visibility claims organization by delivering data-driven insights that influence business decisions. This role is embedded within the business (not IT) and partners directly with claims leadership to analyze performance, identify trends, and improve operational outcomes. This is an ideal opportunity for someone who enjoys combining data analysis, business interaction, and Power BI development.

Job Responsibility

  • Analyze claims data to identify trends, patterns, and anomalies
  • Investigate key business questions related to claims volume, cycle time, and cost drivers
  • Translate findings into clear, actionable insights for leadership
  • Partner directly with claims stakeholders, including Director and VP-level leadership
  • Gather and define reporting requirements
  • Present analysis results and explain the 'why' behind the data
  • Design and develop Power BI dashboards (end-to-end)
  • Define and maintain KPIs and reporting metrics aligned to claims operations
  • Support transition from Excel-based reporting to Power BI
  • Write and optimize SQL queries for data extraction and analysis
  • Perform data validation and support user acceptance testing (UAT)
  • Ensure accuracy and quality of reporting outputs
  • Work with internal and external data sources, including claims systems and vendors
  • Assist with integrating new data sources during system changes or acquisitions
  • Support reporting access and provide basic user training as needed

Requirements

  • Strong experience with Power BI, including building dashboards end-to-end (approximately 20+ dashboards preferred)
  • Advanced SQL skills for querying, data analysis, and validation
  • Experience working with data warehouses or reporting environments
  • Claims experience required
  • Property insurance preferred
  • Healthcare or other claims experience acceptable
  • Experience working directly with business stakeholders
  • Ability to gather requirements and present insights clearly
  • Strong verbal and written communication skills
  • 4-8+ years of experience in business intelligence, analytics, or reporting roles
  • Proven ability to balance technical execution with business engagement

Nice to have

  • Background in claims operations prior to moving into analytics
  • Experience delivering insights and recommendations (not just reports)
  • Familiarity with claims KPIs, workflows, and processes

What we offer

  • 5% annual bonus
  • Comprehensive benefits beginning Day 1
  • 401(k) with company match
  • Paid time off and additional company benefits

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

BI Analyst - Claims (Power BI / SQL)

8 matching positions

New

Senior Business Analyst

Join NLS as a Senior Business Analyst! Lead our Implementation team, mentor BAs,...
Location
Location
United States;Puerto Rico;Honduras , Springfield; San Juan; Tegucigalpa
Salary
Salary:
Not provided
nlsnow.com Logo
Next Level Solutions ltd.
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Advanced proficiency in business analysis tools (e.g., ADO, JIRA, Confluence, FigJam, Visio, and Lucidchart)
  • Demonstrated experience in process modeling, workflow automation, and requirement documentation
  • Expertise in Excel, SQL, Tableau, Power BI, or similar platforms
  • Strong knowledge of Agile, Scrum, and Waterfall methodologies
  • Deep knowledge of the P&C insurance lifecycle including policy, billing, and claims (Duck Creek experience strongly preferred)
  • Familiarity with machine learning, AI, or predictive analytics
  • Demonstrated ability to mentor and peer-review junior analysts with actionable feedback
  • Strategic problem-solving skills with a data-driven mindset
  • Excellent communication skills
  • Sound decision-making in ambiguous situations
Job Responsibility
Job Responsibility
  • Acts as a strategic partner to stakeholders by clarifying needs, managing expectations, and ensuring solutions align with business goals, while leveraging tools and technology, including AI, to improve team efficiency and decision-making
  • Independently gather, analyze, and document highly complex business, functional, and non-functional requirements
  • maintain requirements traceability matrices linking business objectives through requirements to test cases
  • Design Epics, Features, and User Stories in ADO or JIRA
  • define measurable acceptance criteria using Gherkin (Given-When-Then) methodology
  • Maintain and manage requirements repository—requirement-level change control including impact analysis, handoff facilitation with Dev, UX and QA, and stakeholder communication
  • Conduct deep-dive analysis to identify opportunities for process improvement, automation, and efficiency
  • Design and implement dashboards for strategic decision-making using tools like: SQL, Power BI, and Tableau
  • develop advanced analytics models to forecast demand, capacity, or customer behavior
  • Collaborate with technology teams to design and implement solutions that enhance business operations
What we offer
What we offer
  • Competitive compensation package
  • Annual bonus opportunities
  • Comprehensive health, dental, and vision benefits
  • Flexible work arrangements
  • Professional development and continuing education opportunities
  • Career advancement pathways
  • Paid time off and company holidays
  • Retirement savings programs
  • Wellness initiatives and employee support programs
  • Company-sponsored events and team-building activities
  • Fulltime
Read More
Arrow Right

Analyst, Real-World Data & Healthcare Analytics

The Analyst, Real-World Data & Healthcare Analytics is a technical contributor w...
Location
Location
United States , Deerfield
Salary
Salary:
96000.00 - 132000.00 USD / Year
https://www.baxter.com/ Logo
Baxter
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Data Science, Health Informatics, Statistics, Economics, Life Sciences, or related field
  • Hands-on experience working with the Premier Healthcare Database
  • 1–2+ years of experience working with healthcare data (EHR, claims, or hospital datasets)
  • Proficiency in SQL
  • experience with R or Python for data analysis
  • Experience with data visualization tools (Power BI or Tableau)
  • Working knowledge of healthcare coding systems (ICD-10, CPT/HCPCS, DRG)
  • Up to 20% travel
Job Responsibility
Job Responsibility
  • Perform targeted data extractions from healthcare datasets (with a primary focus on the Premier Healthcare Database) using SQL
  • Clean, validate, and structure hospital-level data (EHR, chargemaster) to support RWE analyses
  • Develop and maintain reproducible data workflows and automated reporting pipelines
  • Ensure all datasets are audit-ready and compliant with Medical Affairs standards
  • Prepare datasets and conduct analyses to support budget impact models, cost-effectiveness studies, and value assessments
  • Analyze hospital cost and utilization data to support value-based care initiatives and optimization programs
  • Contribute to evidence generation supporting clinical and economic value narratives
  • Build and maintain interactive dashboards (Power BI or Tableau) to track product utilization, waste, and adoption across surgical specialties
  • Translate complex datasets into clear, actionable insights for cross-functional stakeholders
  • Support development of data-driven reports for internal decision-making and scientific engagement
What we offer
What we offer
  • Medical and dental coverage that start on day one
  • Insurance coverage for basic life, accident, short-term and long-term disability, and business travel accident insurance
  • Employee Stock Purchase Plan (ESPP), with the ability to purchase company stock at a discount
  • 401(k) Retirement Savings Plan (RSP), with options for employee contributions and company matching
  • Flexible Spending Accounts
  • Educational assistance programs
  • Time-off benefits such as paid holidays, paid time off ranging from 20 to 35 days based on length of service, family and medical leaves of absence, and paid parental leave
  • Commuting benefits
  • Employee Discount Program
  • Employee Assistance Program (EAP)
  • Fulltime
Read More
Arrow Right

Analyst, Real-World Data & Healthcare Analytics

The Analyst, Real-World Data & Healthcare Analytics is a technical contributor w...
Location
Location
United States , Deerfield
Salary
Salary:
96000.00 - 132000.00 USD / Year
https://www.baxter.com/ Logo
Baxter
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Data Science, Health Informatics, Statistics, Economics, Life Sciences, or related field
  • Hands-on experience working with the Premier Healthcare Database
  • 1–2+ years of experience working with healthcare data (EHR, claims, or hospital datasets)
  • Proficiency in SQL
  • experience with R or Python for data analysis
  • Experience with data visualization tools (Power BI or Tableau)
  • Working knowledge of healthcare coding systems (ICD-10, CPT/HCPCS, DRG)
  • Up to 20% travel
Job Responsibility
Job Responsibility
  • Perform targeted data extractions from healthcare datasets (with a primary focus on the Premier Healthcare Database) using SQL
  • Clean, validate, and structure hospital-level data (EHR, chargemaster) to support RWE analyses
  • Develop and maintain reproducible data workflows and automated reporting pipelines
  • Ensure all datasets are audit-ready and compliant with Medical Affairs standards
  • Prepare datasets and conduct analyses to support budget impact models, cost-effectiveness studies, and value assessments
  • Analyze hospital cost and utilization data to support value-based care initiatives and optimization programs
  • Contribute to evidence generation supporting clinical and economic value narratives
  • Build and maintain interactive dashboards (Power BI or Tableau) to track product utilization, waste, and adoption across surgical specialties
  • Translate complex datasets into clear, actionable insights for cross-functional stakeholders
  • Support development of data-driven reports for internal decision-making and scientific engagement
What we offer
What we offer
  • Medical and dental coverage that start on day one
  • Insurance coverage for basic life, accident, short-term and long-term disability, and business travel accident insurance
  • Employee Stock Purchase Plan (ESPP), with the ability to purchase company stock at a discount
  • 401(k) Retirement Savings Plan (RSP), with options for employee contributions and company matching
  • Flexible Spending Accounts
  • Educational assistance programs
  • Paid holidays
  • Paid time off ranging from 20 to 35 days based on length of service
  • Family and medical leaves of absence
  • Paid parental leave
  • Fulltime
Read More
Arrow Right

Ms Fabric Sr. Engineer

Build and maintain data ingestion pipelines using Data Factory, Dataflows Gen2, ...
Location
Location
India , NCR Region
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6–10 years of experience in data engineering, with strong Azure analytics background
  • Hands on experience with Microsoft Fabric, including: Data Engineering (Lakehouse, Notebooks, Pipelines), Data Factory (Dataflows Gen2, Pipelines), Data Warehouse (SQL Endpoint, Direct Lake), Power BI (datasets, DAX, semantic models), OneLake & Delta Lake
  • Strong skills in SQL, PySpark, Python, and ETL/ELT development
  • Experience with Azure services such as ADLS, ADF, Databricks, Synapse, Event Hub, and Key Vault
  • Experience working with insurance data (policies, claims, pricing, exposure, risk) is highly desirable
  • Understanding of regulatory reporting (Solvency II, IFRS 17) is a plus
  • Strong problem solving and analytical skills
  • Ability to work in agile, cross functional teams
  • Clear communication and documentation abilities
  • Able to guide junior team members
Job Responsibility
Job Responsibility
  • Build and maintain data ingestion pipelines using Data Factory, Dataflows Gen2, Pipelines, and event driven patterns
  • Develop Lakehouse structures using Delta Lake, Notebooks (PySpark), and medallion architecture
  • Implement Fabric Data Warehouse objects (tables, stored procedures, views, SQL endpoints)
  • Create and optimize semantic models for Power BI, including Direct Lake datasets
  • Develop KQL databases and real time analytics components where required
  • Implement CI/CD pipelines for Fabric using Git integration and DevOps best practices
  • Monitor, troubleshoot, and optimize Fabric workloads for performance and cost
  • Ensure data quality through validation rules, profiling, and automated checks
  • Support production deployments, incident resolution, and environment management
  • Work with Hiscox business teams to understand data requirements and translate them into technical solutions
Read More
Arrow Right

Analyst, Real-World Data & Healthcare Analytics

The Analyst, Real-World Data & Healthcare Analytics is a technical contributor w...
Location
Location
United States , Deerfield
Salary
Salary:
96000.00 - 132000.00 USD / Year
https://www.baxter.com/ Logo
Baxter
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Data Science, Health Informatics, Statistics, Economics, Life Sciences, or related field
  • Hands-on experience working with the Premier Healthcare Database
  • 1–2+ years of experience working with healthcare data (EHR, claims, or hospital datasets)
  • Proficiency in SQL
  • experience with R or Python for data analysis
  • Experience with data visualization tools (Power BI or Tableau)
  • Working knowledge of healthcare coding systems (ICD-10, CPT/HCPCS, DRG)
  • Up to 20% travel
  • Applicants must be authorized to work for any employer in the U.S.
Job Responsibility
Job Responsibility
  • Real-World Data (RWD) Analysis & Engineering
  • HEOR & Value Evidence Support
  • Data Visualization & Insight Delivery
  • Medical Affairs Scientific Support
  • Compliance & Governance
What we offer
What we offer
  • medical and dental coverage that start on day one
  • insurance coverage for basic life, accident, short-term and long-term disability, and business travel accident insurance
  • Employee Stock Purchase Plan (ESPP), with the ability to purchase company stock at a discount
  • 401(k) Retirement Savings Plan (RSP), with options for employee contributions and company matching
  • Flexible Spending Accounts
  • educational assistance programs
  • time-off benefits such as paid holidays, paid time off ranging from 20 to 35 days based on length of service, family and medical leaves of absence, and paid parental leave
  • commuting benefits
  • Employee Discount Program
  • Employee Assistance Program (EAP)
  • Fulltime
Read More
Arrow Right

Financial Data Analyst

This position drives financial performance insight across population health and ...
Location
Location
United States , Vancouver
Salary
Salary:
90000.00 - 115000.00 USD / Year
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of experience in financial analysis, healthcare analytics, or population health environments
  • Experience working with Claims data & large datasets
  • Experience working with Financial modeling & variance analysis
  • Experience working with Risk-based or value-based reimbursement models
  • Strong technical skills in Excel (advanced modeling, PowerPivot)
  • Strong technical skills in SQL or data querying tools
  • Strong technical skills in Data visualization (Power BI, Tableau, etc.) preferred
  • Familiarity with HCC / RAF risk adjustment methodologies
  • Familiarity with Medicare Advantage, MSSP, ACO, or similar programs
  • Ability to communicate insights clearly to executive and operational stakeholders
Job Responsibility
Job Responsibility
  • Analyze claims, CMS, and EHR (Epic) data to evaluate cost, utilization, and quality performance
  • Build and maintain financial models, proformas, and contract-level P&Ls to track performance vs. budget and forecast
  • Perform risk pool, settlement, and payor reconciliation activities
  • ensure accurate accruals and revenue recognition
  • Identify variance drivers, coding gaps, and revenue leakage within complex datasets
  • Support forecasting and run-out analysis tied to delayed reimbursement cycles
  • Partner with finance, operations, and clinical leaders to deliver actionable insights on total cost of care and performance improvement opportunities
  • Evaluate payor contract terms and proposed rate changes, modeling financial impact
What we offer
What we offer
  • Medical, vision, dental, and life and disability insurance
  • 401(k) plan
  • Free online training
  • Fulltime
Read More
Arrow Right

Senior Data Systems Analyst

A leading, forward-thinking Canadian insurance organization is embarking on an a...
Location
Location
Canada , Markham
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
July 20, 2026
Flip Icon
Requirements
Requirements
  • University degree in Computer Engineering, Computer Science, or a related field
  • Minimum 5 years of experience successfully leading Data Systems Analysis organizations with expertise in building large-scale enterprise data assets
  • 8+ years of experience as a Business Analyst working on mid-to-large projects for data design, development, and implementation of business-critical enterprise data systems
  • Strong data analysis skills with a very strong SQL background
  • Deep background in ETL/Data engineering and outstanding knowledge/experience with the Informatica product suite
  • Solid grasp and experience with data technologies and environments (Snowflake, Hadoop, PostgreSQL, Data Warehouses, and Data Lakes/Lakehouses)
  • Experience establishing documentation standards frameworks for data quality, data governance, stewardship, and metadata management
  • Strong analytical, critical thinking, problem-solving, stakeholder management, and leadership/influencing skills at the senior management level
  • Excellent verbal and written communication skills
  • Insurance industry knowledge is considered a strong asset
Job Responsibility
Job Responsibility
  • Claims & Policy Data Analysis
  • Customer & Risk Insights
  • Regulatory & Compliance Reporting
  • Data Wrangling & Preparation
  • Business Intelligence & Visualization
  • Data Quality & Governance
  • Collaboration & Stakeholder Engagement
  • Predictive & Advanced Analytics Support
  • Fulltime
Read More
Arrow Right

Actuarial Analyst - Analytics

The overarching remit of the Actuarial Analytics team is to create business valu...
Location
Location
United Kingdom , Birmingham
Salary
Salary:
Not provided
socialvalueportal.com Logo
Social Value Portal Ltd
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • University degree in Mathematics or related field
  • Actuarial experience gained within the insurance industry
  • Understanding of actuarial / statistical techniques
  • Coding experience with R / Python
  • Competent user of MS Excel, VBA, SQL, R, Python, Power BI
  • Strong analytical skills with attention to detail
  • accurate and numerate
  • Able to communicate effectively both verbally and in writing
  • Team worker as well as able to work on own initiative
  • Ability to manage time, work on a number of tasks in parallel, meet deadlines and prioritise
Job Responsibility
Job Responsibility
  • Support the delivery of impactful analytics to the underwriting teams
  • Develop and enhance line of business specific analysis, tools and insights to support and enhance their strategy and decision making, including portfolio monitoring and optimisation, segmentation and trend analysis, tracking exposure and technical price adequacy, and profitability studies
  • Provide support to the underwriting teams, business managers and claims teams as required within the reserving process
  • Develop tools to better understand new and ongoing trends in the claims environment, allowing us to more quickly identify drivers of losses and respond with effective underwriting action
  • Support the business planning process and create tools to better understand cross-class performance and market insights, enhancing growth and profitability and giving insights to better manage capital
  • Work with stakeholders from across the business to explore new ways to drive profitability
  • Conduct exploratory data analysis, trialling new solutions and building pricing models using actuarial and/or data science based methods
  • Work with the data organisation, underwriters and claims managers to ensure that data requirements are communicated and delivered
  • Be proactive in ensuring that the necessary data is captured from underwriting and claims to enhance future modelling capabilities
  • Identify opportunities and deliver improvements in both Analytics and wider business processes & methodologies
What we offer
What we offer
  • Attractive base compensation and discretionary performance related annual bonus
  • Private medical insurance coverage for both you and your dependents
  • Company paid life assurance and long term disability insurance
  • Pension with 10% employer contribution, plus a further matched contribution up to 2.5%
  • 25 days of annual leave (prorated for 1st calendar year of employment), plus public holidays, with the ability to flex the religious bank holidays to suit your religious beliefs, subject to approval
  • Additional annual leave purchase is also available up to a maximum of five additional days per year
  • Up to 2.5 days matched paid leave for volunteering at a charity of your choice and 5 days paid leave to provide or arrange care for a dependent with a long term care need annually
  • Up to £550 reimbursement towards home office setup
  • Free in-office lunch and monthly lifestyle allowance
  • Monthly travel allowance or annual season ticket
  • Fulltime
Read More
Arrow Right