Data Analyst, Business Intelligence - MSI

The Baldwin Group

23h • Remote

About The Position

Why MSI? We thrive on solving challenges. As a leading MGA, MSI combines deep underwriting expertise with insurer and reinsurer risk capacity to create specialized insurance solutions that empower distribution partners to meet customers’ unique needs. We have a passion for crafting solutions for the important risks facing individuals and businesses. We offer an expanding suite of products – from fully-digital embedded renters coverage to high-value homeowners insurance to sophisticated commercial coverages, such as cyber liability and habitational property – delivered through agents, brokers, wholesalers and other brand partners. Our partners and customers count on us to deliver exceptional service through a dedicated team that makes rapid resolutions a priority. We simplify the insurance experience through our advanced technology platform that supports every phase of the policy lifecycle. Bring on your challenges and let us show you how we build insurance better. Position Summary The BI Data Analyst will be responsible for delivering actionable insights through analysis, reporting, and visualization to support decision-making across the organization. This role involves creating and maintaining dashboards, reports, and data visualizations, as well as leveraging data to forecast trends and guide business activities. The ideal candidate is curious, detail-oriented, and skilled at exploring data from multiple angles, conducting research, identifying trends, and collaborating with colleagues to integrate data from various sources for informed recommendations.

Requirements

• Bachelor’s degree in a related field preferred; equivalent experience considered.
• 3–5 years of data analytics or related experience.
• Strong data visualization skills with Power BI (preferred), Tableau, and Qlik Sense
• Experience with Power Automate and Power Apps.
• Hands-on experience with Microsoft Fabric ecosystem, including: OneLake, Lakehouse, Data Warehouse, Notebooks, Pipelines, Dataflows, and Power BI integration.
• Strong knowledge of data modeling, SQL, and Python for Fabric Notebooks.
• Ability to understand database structures, relationships, and dependencies.
• General understanding of AI for personal productivity, including: Using AI tools for data analysis, report automation, and decision support.
• Awareness of AI trends and their impact on BI workflows.
• Proficiency in MS Office, especially Excel (pivot tables, VLOOKUP, formulas, charts, and graphing).

Nice To Haves

• Insurance industry experience preferred.

Responsibilities

• Design, develop, and manage business intelligence solutions for the organization.
• Build and maintain dashboards, generate reports, and prepare data visualizations to guide business decisions.
• Collaborate with stakeholders to collect, structure, and validate data from multiple sources.
• Audit, compile, and reconcile data to ensure accuracy and integrity.
• Communicate findings internally and externally, answering questions and providing clarity on data and reports.
• Work on complex projects of large scope, ensuring timely and accurate delivery.
• Automate manual reporting processes and implement efficiencies.
• Support the implementation of new practices, processes, and procedures.
• Create ad-hoc datasets and visualizations (graphs, tables, charts) based on business requests.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees