Senior BI & AI Analytics Leader

Msimga

Northern (KY)

Hybrid

USD 90,000 - 140,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

MSI, a leading MGA, seeks a Sr. BI Analyst to turn complex data into actionable insights. You will own dashboards, reports, and data pipelines, collaborating with Product, Underwriting, and Analytics teams to support strategic decisions.

The ideal candidate has 5–7 years in data analytics, advanced SQL, Power BI mastery, and hands-on experience with Microsoft Fabric. Fluency with AI tools like Claude and Copilot is highly desired to accelerate automation and scale solutions.

Qualifications

Bachelor’s degree in a related field preferred; equivalent experience considered.
5–7 years of data analytics or related experience.
Advanced SQL, data modeling, and visualization; recognized Power BI subject matter expertise (Tableau or other BI tools a plus).
Hands-on experience with Microsoft Fabric ecosystem, including: OneLake, Lakehouse, Data Warehouse, Notebooks, Pipelines, Dataflows, Power BI integration, and Python for Fabric Notebooks.
Solid grasp of database structures, relationships, and dependencies.
Strong critical thinking and proactive problem-solving - comfortable working from an ambiguous request to a defined, scalable solution.
Strong written and verbal communication with business stakeholders and senior leaders; able to present findings and influence decisions without technical jargon.
Peer mentoring and peer review capabilities.
Intermediate insurance domain knowledge and understanding of MGA operations; insurance industry experience preferred.
Advanced, hands-on AI fluency - daily working use of tools such as Claude and Microsoft Copilot.

Responsibilities

Design, develop, and manage business intelligence solutions on complex projects of large scope - dashboards, reports, ad-hoc datasets, and visualizations that guide business decisions.
Partner with Product, Actuarial & Advanced Analytics, Underwriting, and other core insurance functions to collect, structure, and validate data from multiple sources.
Audit, compile, and reconcile data to ensure accuracy and integrity.
Communicate findings clearly to business stakeholders and senior leaders - translating technical analysis into plain-language recommendations, defending methodology when challenged, and providing consultative input beyond what was asked.
Automate manual reporting processes and build scalable, reusable solutions rather than one-off deliverables.
Apply AI tools (Claude, Microsoft Copilot, and similar) to accelerate dashboard development, pipeline automation, code generation and review, and report QA - and champion AI-driven process improvement across the BI function.
Apply critical thinking to ambiguous requests - clarify the underlying business question, evaluate trade-offs, and recommend the approach rather than defaulting to the one requested.
Conduct peer reviews of colleagues' work and mentor less experienced analysts as the Power BI subject matter expert.
Support the implementation of new practices, processes, and procedures.