Responsible for leading and performing data warehouse design, data analysis, design and developing ETL (Extract, Transform and Load) and reporting solutions using Microsoft Business Intelligence (BI) tools. Performs design and code reviews while leading and mentoring BI developers to ensure best practices and the review process are being followed. Performs all duties in accordance with all company policies and procedures, and all federal, state and local laws, wherein the Company operates.

ESSENTIAL DUTIES AND RESPONSIBILITIES Participates in establishing the data management framework that improves the data quality and standards for both database structures and the warehouse repository.

Designs, leads and develops requirements for data mapping and ETL processes.

Designs, leads and participates in the development of the data model(s) for the data warehouse.

Provides recommendations for all data strategies and innovative reporting solutions.

Performs analysis and design, and maps data between source systems and the Enterprise Data Warehouse; analyzes data in source systems to assess data quality and makes recommendations for addressing within the source systems or as part of the ETL process.

Develops SSAS Tabular Models, Power BI Dashboards and other appropriate data access objects for end user reporting depending on business need.

Performs design and code reviews to ensure best practices and standards are being followed by all team members.

Other duties as assigned.

QUALIFICATIONS EDUCATION / EXPERIENCE Bachelor’s Degree in Computer Science or equivalent combination of education and experience

Seven (7) or more years Requirements Gathering, data analysis, design and coding of data warehouse database, processes and reporting

Insurance Industry experience a plus

SKILLS

Sharp analytical and problem-solving skills

Strong leadership skills

Proficient in Microsoft BI Tools (SQL, SSIS, SSRS, SSAS, Power Query, Power BI)

Strong ability to manage multiple projects simultaneously and adapt to rapidly changing priorities

Excellent verbal and written communication skills

Excellent customer service skills

Proven ability to work in a team and to foster teamwork

Demonstrated understanding of system integrations and database structures

Proficient in Microsoft Office suite applications

LI-DR2

We are proud to provide comprehensive, high quality employee programs to meet employees’ needs now and in the future, including a very competitive financial package. We encourage you to explore what we have to offer.

At Alliant Insurance Services, we thrive on creating employee benefits solutions built on the idea that health makes growth possible. As top tier professionals dedicated to solving our clients’ health and welfare insurance challenges, Alliant team members deliver an unrivaled depth of service, and our unique approach enables us to help clients stay resilient and turn change into opportunity. This position is a chance to join a dynamic, expanding company with prospects for individual and career growth.

As one of the 5 largest insurance brokerage firms in the U.S., Alliant provides property and casualty, workers’ compensation, employee benefits, surety, and financial products and services to clients nationwide.