Data Analyst - MSI

Why MSI? We thrive on solving challenges. As a leading MGA, MSI combines deep underwriting expertise with insurer 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.

The BI Data Analyst will be responsible for performing analysis, reporting and visualization to support decisions within different areas of the firm. He/she will be responsible for creating and maintaining dashboards, reports, and data visualizations and using Data to forecast or guide business activity. The ideal candidate will have the curiosity and skills to investigate the data from multiple angles, conduct research, and identify trends while partnering with colleagues to match data from multiple resources to make recommendations.

Principal Responsibilities:

• Developing and managing business intelligence solutions for the organization.

• Developing and maintaining dashboards, generating reports, preparing data visualizations, and using data to forecast or guide business activity.

• Collaborating with colleagues for the purpose of collecting and structuring data.

• Collect, audit, compile, and validate data from multiple sources.

• Interpret data, analyze results using statistical techniques or relational databases and produce ongoing as-needed reports to meet client and/or business needs.

• Communicate internally and with clients externally to collect and validate data as well as answer questions regarding reports and data.

• Works on complex projects of large scope.

• Build automation and additional efficiencies into manual reporting efforts.

• Helps implement new practices, processes and procedures.

• Create ad-hoc data sets through graphs, tables and other visuals based upon business requests.

Education, Experience, Skills and Abilities Requirements:

• Bachelor’s degree in related field preferred, equivalent years’ experience considered.

• At least three to five years of data related or analytical work experience.

• Experience Power Automate & Power Apps experience.

• Insurance industry experience preferred.

• MS Azure skills preferred including some experience in Data Factory, Databricks, Synapse Analytics, Power BI or equivalent.

• Basic to intermediate experience with SQL queries, with MS SQL Server database experience preferred.

• Ability to grasp database structures and understand the underlying relationships and dependencies.

• Comfortable compiling data integration from multiple sources; performing quality control on data sets; identifying and scrutinizing anomalies and/or outliers in the data; ability to manipulate data and complete required analysis

• Intermediate SQL / T-SQL experience.

• MS Office skills including intermediate skills in Excel with the ability to create, manipulate and formulate spreadsheets, to include v-look-ups, pivot tables, formulas, charts and graphing.

#LI-DT1

#LI-REMOTE