Strategic Enterprise BI & Data Warehouse Analyst

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

Benefits offered by this job

Health, Vision, and Dental coverage

403B retirement plan

Paid vacation and holidays

Job summary

Medical College of Wisconsin seeks a senior BI/Data Warehouse professional to lead requirements analysis and independently formulate approaches for data warehouse design, integration, and reporting. You will collaborate with administrators, finance, HR, clinical ops, and IT teams to deliver accurate, decision-supporting BI assets.

Responsibilities include ETL development, data modeling, SSAS/SSRS cube/report design, and maintaining enterprise data warehouse artefacts under BI leadership

Qualifications

• Bachelor's degree required; six years of relevant experience; advanced knowledge of data warehousing concepts and BI tooling.
• Preferred Master's degree; background in Computer Science, Information Systems, Technology, Engineering or related field.

Responsibilities

• Perform data migration and data integration tasks using ETL tools; develop SQL scripts for data acquisition and manipulation across sources.
• Collaborate with senior BI staff to ensure data integration accuracy and timeliness.
• Aggregate data to support creation of dimensions, facts, and data models; design and maintain SSRS reports and SSAS cubes.

Skills

Business requirements analysis

Data modeling

SQL scripting

SSIS

Qlik BI tools

SSAS

SSRS

Critical thinking

Education

Bachelor's Degree

Master's Degree

Tools

SSIS

Qlik

SSRS

SSAS

SQL Server Management Studio

Workday

Job description

Medical College of Wisconsin seeks a senior BI/Data Warehouse professional to lead requirements analysis and independently formulate approaches for data warehouse design, integration, and reporting. You will collaborate with administrators, finance, HR, clinical ops, and IT teams to deliver accurate, decision-supporting BI assets.

Responsibilities include ETL development, data modeling, SSAS/SSRS cube/report design, and maintaining enterprise data warehouse artefacts under BI leadership