Senior Enterprise BI & Data Warehouse Analyst

The Medical College of Wisconsin, Inc.; Wisconsin; Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Paid parental leave

On-site fitness facility

Job summary

The Medical College of Wisconsin, Inc. is seeking a business intelligence professional to lead data warehouse management, data design, and analytics support under BI leadership.

You will partner with administration, finance, HR, and clinical operations to translate requirements into reliable data models and reports. Responsibilities cover data integration, ETL using SSIS, data modeling, and creating SSRS reports and SSAS cubes.

Qualifications

• Bachelor’s Degree required.
• Minimum 6 years of relevant work experience.
• Master’s Degree preferred in Computer Science, Information Systems, Technology, Engineering or related field.
• Experience with enterprise BI technologies and Workday integration is desirable.

Responsibilities

• Data Integration & ETL Support: perform data migration and data integration tasks using ETL tools; develop SQL scripts for data acquisition across sources.
• Business Requirements & Stakeholder Support: translate requirements from admin, finance, HR, clinical and education teams into data solutions.
• Reporting, Cubes & Documentation: design SSRS reports and SSAS OLAP cubes; document development and business rules.
• Quality Assurance & Issue Resolution: ensure data quality and coordinate with IT to resolve BI system issues.
• Tools, Training & Continuous Learning: use Qlik and other tools; train end-users on BI solutions.
• Other duties as assigned.

Skills

Data integration

ETL

SQL

SSIS

Qlik

SSRS

SSAS

SQL Server Management Studio

Data modeling

Analytical thinking

Education

Bachelor's Degree

Master's Degree preferred

Tools

SSIS

Qlik

SSRS

SSAS

SQL Server Management Studio

Power BI

Tableau

Workday

Job description

The Medical College of Wisconsin, Inc. is seeking a business intelligence professional to lead data warehouse management, data design, and analytics support under BI leadership.

You will partner with administration, finance, HR, and clinical operations to translate requirements into reliable data models and reports. Responsibilities cover data integration, ETL using SSIS, data modeling, and creating SSRS reports and SSAS cubes.