Lead Data Analyst

Millennial Specialty Insurance, LLC is one of the largest non-carrier-affiliated Managing General Agencies (MGAs) in the United States. Combining expert underwriting with industry-leading technology, MSI creates a superior insurance experience for carriers, distribution partners, and customers. MSI collaborates with insurance carriers to design and distribute products through agents, brokers, and technology partners. Founded in 2015, MSI has grown to offer a wide range of insurance products across commercial, specialty, and personal lines. In 2019, MSI joined BRP Group, Inc. (NASDAQ: BRP).

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!