Enterprise BI Analyst: Data Warehouse & Insights

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

Benefits offered by this job

Health insurance

Retirement plan

Paid time off

Onsite fitness facilities

Job summary

Medical College of Wisconsin is seeking a BI/Data Warehouse professional to design and maintain enterprise BI data warehouse, data models, and reports. You will work with cross-functional teams to clarify requirements and ensure accurate data for decision-making.

The role emphasizes ETL, data integration, and analytics, supporting strategic goals and enterprise reporting capabilities.

Qualifications

• Minimum Required Education: Bachelor’s Degree.
• Minimum 6 years of relevant experience; master’s degree preferred.
• Experience with BI data warehouses, data integration, and analytics.
• Proficiency with SSAS/SSRS/SSIS and SQL Server tools.

Responsibilities

• Lead data integration and ETL tasks for BI data warehouse.
• Develop and maintain data models, cubes, and reports.
• Collaborate with business teams to clarify information needs.
• Document development processes and BI solutions.
• Ensure data accuracy and timely delivery for dashboards.

Skills

SQL development

Data modeling

ETL

Analytical thinking

Communications

Education

Bachelor's Degree

Tools

SSIS

SSRS

SSAS

SQL Server Management Studio

Qlik/Power BI

Job description

Medical College of Wisconsin is seeking a BI/Data Warehouse professional to design and maintain enterprise BI data warehouse, data models, and reports. You will work with cross-functional teams to clarify requirements and ensure accurate data for decision-making.

The role emphasizes ETL, data integration, and analytics, supporting strategic goals and enterprise reporting capabilities.