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.
The Lead Data Analyst is part of the Data and Analytics Organization and is responsible for the design, development, and delivery of actionable insights and data-driven solutions to support strategic decision-making within the organization. Exemplifying technical excellence and thought leadership, the Lead Data Analyst will work closely with stakeholders across the business and within the Data and Analytics organization to define requirements, propose options, and deliver innovative BI solutions that support the organization's goals and objectives.Responsibilities include designing, developing, and delivering dashboards, reports (using Power BI), and other data-driven solutions that provide actionable insights to stakeholders across the organization. Providing technical thought leadership, conducting code reviews, technical mentorship, and aiding the BI Manager in the development of data analysts on the team. The ideal candidate has a knack for seeing solutions in sprawling data sets and the business mindset to convert insights into strategic opportunities for our company. The Lead Data Analyst will work closely with the BI Leadership to ensure successful implementation and delivery of innovative solutions.Principal Responsibilities:
- Design and lead the development of business intelligence solutions for the organization using Power BI, Power Automate and Power Apps.
- Develop and maintain dashboards, reports, prepare data visualizations, and use data to forecast or guide business activity.
- Monitor database reporting systems performance, troubleshoot and resolve data related issues.
- Identify and implement technical and/or process changes to improve the performance, accuracy, timeliness, and/or efficiency of database, reporting, and dashboard operations.
- Minimize instances of redundant data, data bases, and data base related solutions,
- Act as a subject matter expert on the Power BI application, promoting its use and acting as a mentor to other colleagues.
- Comply with IT Security and SOX General Control requirements, with a focus on change control and data access provisioning.
- Collect, audit, compile, and validate data from multiple sources.
- Support Agile transformation and best practices within the BI team by participating in Agile ceremonies, backlog grooming, feature prioritization, and capacity management.
- Collaborate with team members and development partners to reach project milestones and deadlines.
- Conduct code reviews and provide feedback
- Apply advanced knowledge and understanding of concepts, principals, and technical capabilities to manage a wide variety of projects.
- Provides solutions that may set precedent or have significant impact.
- Build automation and additional efficiencies into manual reporting efforts.
Education, Experience, Skills and Abilities Requirements:
- Bachelor’s degree in related field preferred, equivalent years’ experience considered.
- At least seven years of data related or analytical work experience.
- Must have experience building BI solutions using Power BI, Power Automate and Power Apps.
- Insurance industry experience preferred, but not required.
- MS Azure skills preferred including intermediate skills in Data Factory, Synapse Analytics, Power BI or equivalent.
- Intermediate to advanced SQL / T-SQL experience.
- 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.
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 modified to reasonably accommodate physically or mentally challenged colleagues.
#LI-BM1
#LI-REMOTE
Click here for some insight into our culture!
Top Skills
What We Do
BRP is now The Baldwin Group! We’ve updated our name to reflect our unified group of talented teams across the country.
The Baldwin Group is a cohesive group of experts in business insurance, employee benefits, retirement planning, and all areas of private and personal insurance. Since our founding in 2011, we’ve evolved from a local business into a national firm with a vast network of specializations and industry practices for the benefit of our more than two million clients across the country.
In addition, we have built excellent relationships with a wide range of insurance company partners. These relationships, coupled with our entrepreneurial and family-oriented culture, and deep expertise enable us to seamlessly deliver a breadth of innovative solutions to clients.
At The Baldwin Group, we help provide the solutions our clients need to have confidence and gain peace of mind as they pursue what’s possible for themselves, their families, and their businesses. Whether they are renting their first apartment or buying a larger home, opening a small business or taking their company public, we offer solutions to support them on every step of their journey. This has been our story since the beginning—we provide the indispensable expertise and quality insights that give our clients peace of mind to pursue their purpose, passion, and dreams. And that’s what The Baldwin Group will continue to do for years to come: we Protect the Possible℠.