Senior Enterprise BI Analyst (Data Warehouse & Insights)

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

Benefits offered by this job

Health coverage

403B retirement plan

Paid vacation & holidays

Tuition reimbursement

Parental leave

EFAP

Pet insurance

On-campus fitness facility

Employee discounts

Job summary

The Medical College of Wisconsin seeks a skilled BI/Data Warehouse professional to lead data integration, ETL, and reporting initiatives across administration, finance, HR, clinical, and research domains. You will partner with senior BI staff to design data models, ensure data accuracy, and deliver actionable insights through dashboards and analytical tools.

Responsibilities include building SSAS cubes, SSRS reports, and maintaining documentation while training end-users on BI solutions.

Qualifications

• Bachelor's degree required.
• 6+ years of experience.
• Master's degree preferred.
• Background in Computer Science, Information Systems, Technology, Engineering or related field is preferred.

Responsibilities

• Perform data migration and ETL tasks using SSIS or Qlik; develop SQL scripts.
• Ensure data integration accuracy and timeliness.
• Aggregate data to support dimensions, facts, and data models.
• Clarify and support enterprise reporting needs across admin, finance, HR, clinical, research, and education.
• Translate business needs into written requirements.
• Coordinate data requirements gathering and Workday reporting activities.
• Develop dashboards, data management, and analytics for leaders.

Skills

Interpersonal skills

Communication (oral & written)

Critical thinking

Detail orientation

Independent judgment

Analytical abilities

Data analysis

BI tools knowledge

Workday familiarity

Education

Bachelor's Degree

Master's Degree preferred

Tools

SSAS

SSRS

SSMS

Qlik analytics

Tableau/Power BI

Job description

The Medical College of Wisconsin seeks a skilled BI/Data Warehouse professional to lead data integration, ETL, and reporting initiatives across administration, finance, HR, clinical, and research domains. You will partner with senior BI staff to design data models, ensure data accuracy, and deliver actionable insights through dashboards and analytical tools.

Responsibilities include building SSAS cubes, SSRS reports, and maintaining documentation while training end-users on BI solutions.