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.
Position Summary:
The DI Data Analyst will be responsible for performing analysis, reporting and visualization to support decisions to support Partner Organizations and Integrations within 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 years of data related or analytical work experience.
·Basic to intermediate experience with SQL queries, with MS SQL server database experience.
Experience Power Automate & Power Apps experience preferred.
·Insurance industry experience preferred.
MS Azure skills preferred including some experience in Data Factory, Databricks, Synapse Analytics, Power BI or equivalent.
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
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.
Special Working Conditions:
Fast paced, multi-tasking environment.
Important Notice:
This position description is intended to describe the level of work required of the person performing in the role and is not a contract. The essential responsibilities are outlined; other duties may be assigned as needs arise or as required to support the organization. All requirements may be subject to reasonable accommodations to applicants and colleagues who need them for medical or religious reasons.
#LI-DT1
#LI-REMOTE
Click for some insight into our culture!