Business Intelligence Analyst

Experior Financial

7d•$100,000 - $130,000•Remote

About The Position

Experior Financial Group is seeking a Business Intelligence Analyst to develop and maintain reports and dashboards that enable teams to understand and utilize data effectively. This role involves direct collaboration with stakeholders across the organization to transform raw data into clear, reliable, and actionable insights. The analyst will be responsible for writing SQL queries to extract data and designing Power BI dashboards for decision-makers. This is a hands-on technical position requiring comfort with data modeling, SQL, and presenting final dashboards.

Requirements

5+ years of experience building reports and dashboards in Power BI (or a comparable BI tool such as Tableau or Looker), including DAX and data modeling.
Strong SQL skills, comfortable writing complex queries (joins, subqueries, window functions) against relational databases.
Solid understanding of data modeling concepts and best practices for structuring data for reporting (e.g., star schemas).
Experience working with data warehouses and/or ETL tools and processes.
Strong analytical mindset with excellent attention to detail and data accuracy.
Ability to communicate technical findings clearly to non-technical stakeholders.
Self-motivated and comfortable working independently in a remote environment.
Must reside and be authorized to work in the USA.

Nice To Haves

Familiarity with IMO, Insurance Carrier, and/or financial services operations is strongly preferred.
Familiarity with Power Query (M language) and Power BI Service administration (workspaces, gateways, row-level security) is an asset.
Exposure to Python or another scripting language for data processing or automation is an asset.
Experience with cloud data platforms (e.g., Azure, Snowflake, or similar) is an asset.

Responsibilities

Design, build, and maintain interactive dashboards and reports in Power BI for stakeholders across the business.
Write and optimize SQL queries against relational databases to extract, join, and aggregate data for reporting and analysis.
Build and maintain data models (including DAX measures and calculated columns) that power accurate, performant dashboards.
Partner with business stakeholders to understand reporting needs and translate them into clear, well-structured data visualizations.
Develop and maintain ETL/data pipelines to keep reporting data accurate, complete, and up to date.
Monitor data quality and troubleshoot discrepancies between source systems and reports.
Document data definitions, report logic, and dashboard usage so reporting stays consistent and maintainable over time.
Identify opportunities to automate recurring reports and streamline the reporting process.