Back to search

Senior BI Data Modeler

Senior Power BI Developer / BI Data Modeler focused on migrating complex Excel-based insurance analytics and reporting solutions to Power BI.

  • Remote
  • Full-time
  • Remote
  • Competitive salary
  • Posted Oct 23, 2026
INDUSTRYFinance & AccountingFintech & Payments

Responsibilities

  • Migrating complex Excel-based insurance analytics and reporting solutions to Power BI
  • Analyzing existing Excel formulas, VBA macros, VBScript, and Power Query transformations
  • Translating business logic into DAX calculations and scalable Power BI data models
  • Validating Power BI KPI results against existing Excel reports
  • Building interactive dashboards for regional comparisons, cost and impact analysis, KPIs, and projections

Requirements

  • Experience in a Insurance
  • Experience in a Financial Analytics

Nice to have: Insurance domain experience, Financial Analytics domain experience, Modernization of complex Excel-based reporting solutions

Skills

Power BIDAXPower BI Data ModelingSemantic ModelsStar SchemaPower Query / METLAdvanced ExcelVBA / VBScriptSQLData ReconciliationKPI ValidationForecastingTrend AnalysisPower BIDAXPower QueryMExcelVBAVBScriptSQL

Benefits

  • Opportunity for advancement

Full description

Benefits: REMOTE Competitive salary Opportunity for advancement Job Title: Senior Power BI Developer / BI Data Modeler Location: Remote Experience: 7+ Years Domain: Insurance / Financial Analytics Work Hours: Must overlap with US Eastern Time for a few hours Required Skills: Power BI, DAX, and complex calculations Power BI Data Modeling, Semantic Models, and Star Schema Power Query / M and ETL Advanced Excel, Complex Formulas, and Calculation Dependencies VBA / VBScript (VBS) Analysis Excel-to-Power BI Migration SQL, Data Reconciliation, and Validation KPI Validation and Performance Optimization Forecasting, Trend Analysis, and Scenario-Based Reporting Key Requirements: Hands-on experience migrating complex Excel-based insurance analytics and reporting solutions to Power BI. Ability to analyze existing Excel formulas, VBA macros, VBScript, and Power Query transformations. Strong expertise in translating business logic into DAX calculations and scalable Power BI data models. Experience validating Power BI KPI results against existing Excel reports. Ability to build interactive dashboards for regional comparisons, cost and impact analysis, KPIs, and projections. Preferred Experience: Insurance or Financial Analytics domain experience. Modernization of complex Excel-based reporting solutions. Strong analytical, troubleshooting, and communication skills. Important: This is not a visualization-only Power BI role. Candidates must have hands-on experience with complex Excel calculations, DAX, Power BI data modeling, and preferably VBA/VBS-driven reporting processes. This is a remote position.

Senior BI Data Modeler at Select Minds LLC | Referso Jobs