Senior Enterprise BI & Data Warehouse Analyst

Medical College of Wisconsin; Wauwatosa (WI); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Health insurance

403B retirement plan

Paid vacation & holidays

Tuition reimbursement

Parental leave

Employee assistance program

Pet insurance

On-campus fitness facility

Discount programs

Job summary

The Medical College of Wisconsin seeks an experienced BI/Data Warehouse professional to manage data integration, modeling, and reporting. You will work with administration, finance, HR, and research teams to deliver accurate, timely BI insights and maintain enterprise data assets.

You will design data models, build ETL pipelines, and develop SSRS reports and SSAS cubes, while guiding end-user reporting and analytics with Qlik or similar tools. Strong communication and detail focus required.

Qualifications

• Bachelor's degree required; Master's preferred with advanced analytics focus.
• 6 years of relevant experience in BI/data warehousing and analytics.
• Experience integrating Workday data and BI platforms is a plus.
• Proven ability to design data models, ETL pipelines, and reports.

Responsibilities

• Data Integration & ETL: implement ETL tasks using SSIS and data modeling.
• Business requirements: translate needs into technical specs for BI.
• Reporting & cubes: develop SSRS reports and SSAS OLAP cubes.
• Quality assurance: validate data accuracy and coordinate issue resolution.
• Tools & training: leverage Qlik, sustain documentation and user training.

Skills

Data modeling

ETL development

SQL

SSIS

SSRS

SSAS

Qlik

Workday integration

Data visualization

Analytical thinking

Communication

Education

Bachelor's Degree

Master's Degree preferred

Tools

SSIS

SSRS

SSAS

Power BI

Tableau

SQL Server

SSMS

Job description

The Medical College of Wisconsin seeks an experienced BI/Data Warehouse professional to manage data integration, modeling, and reporting. You will work with administration, finance, HR, and research teams to deliver accurate, timely BI insights and maintain enterprise data assets.

You will design data models, build ETL pipelines, and develop SSRS reports and SSAS cubes, while guiding end-user reporting and analytics with Qlik or similar tools. Strong communication and detail focus required.