Enterprise BI Systems Analyst

Medical College of Wisconsin; Wisconsin; On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

Health insurance

403B Retirement Package

Paid vacation and holidays

Tuition reimbursement

Parental leave

EFAP

Job summary

Medical College of Wisconsin is seeking a Business Intelligence Data Warehouse Analyst to design and support enterprise BI data warehouses, data models, and reporting. You will work with clinical, administrative, and financial teams to translate requirements into actionable BI solutions.

The role emphasizes ETL development (SSIS/Qlik), data integration, and dashboard reporting, with strong focus on data accuracy, governance, and end-user training. Collaboration with BI leadership is essential.

Qualifications

• Minimum education: Bachelor's Degree.
• Minimum experience: 6 years in BI/data warehouse environments.
• Preferred education: Master's Degree.
• Experience with enterprise BI tools and Workday integration is valued.

Responsibilities

• Review business requirements and design BI data warehouse solutions.
• Develop and maintain ETL processes and data models.
• Create and update SSRS reports and SSAS cubes.
• Collaborate with stakeholders to ensure data accuracy and timely delivery.
• Document methodologies and BI deliverables; support end users.

Skills

Communication

Critical thinking

Attention to detail

Independent judgment

Analytical abilities

Team collaboration

BI technologies

Workday integration

Education

Bachelor's Degree

Master's Degree

Tools

SSAS

SSRS

SSMS

Qlik

Tableau/Power BI

Workday

Job description

Under general supervision, conduct business requirements review and independently formulate business approaches for providing business intelligence data warehouse management, data design, architecture, repository creation and information presentation. Work closely with business teams (Department Administrators, Accounting, Budgeting/Planning, Clinical Operations, Human Resources, Senior Leaders, etc.) and business intelligence staff to clarify and provide insight into integrating information to support business processes and business decisions. Support the overall information needs of the college in supporting strategic vision and goals. Assure information accuracy for all data presentation purposes. This role provides foundational support for the enterprise BI data warehouse, building and maintaining reports, data models, and analytical tools under the guidance of senior team members and BI leadership.

Primary Responsibilities

Data Integration & ETL Support

• Perform data migration and data integration tasks such as Extract, Transform, and Load (ETL) using SSIS or Qlik data modeling and scripting, limiting manual intervention whenever possible; develop SQL scripts for data acquisition and manipulation across SQL-compliant and other data sources.
• Work with senior Enterprise BI staff to ensure data integration tasks meet established accuracy and timeliness standards.
• Work with the Data Warehouse team to aggregate data as needed to support the creation of dimensions, facts, and data models.

Business Requirements & Stakeholder Support

• Work with business users across administration, finance, human resources, clinical, research, and education to clarify and provide insight into integrating information that supports business processes and decisions.
• Understand and support business processes and informational needs, translating them into clear, written requirements.
• Coordinate data requirement gathering and support business information activities; support coordination with system-specific reporting teams, such as the Workday reporting team, under the direction of senior staff or the manager.
• Provide organizational support to operational leaders (administration, finance, human resources, clinical, research, and education) through internal data management, reporting, dashboards, and business analysis.

Reporting, Cubes & Documentation

• Construct new and redesign existing SQL scripts and stored procedures, applying a working understanding of dimensions, facts, and data architecture.
• Construct new and redesign existing SSRS reports for deployment on the SQL Server Reporting Services platform.
• Construct new and maintain SSAS OLAP cubes deployed on SQL Server Analysis Services.
• Document application development, including business rules, methodologies, and solutions used in business intelligence deliverables; documentation is expected to be kept current and accessible to the broader BI team.

Quality Assurance & Issue Resolution

• Perform quality assurance on data management processes, escalating any data discrepancies or quality concerns to senior analysts or the manager in a timely manner.
• Coordinate with the Information Services Help Desk to troubleshoot and resolve problems with BI systems.

Tools, Training & Continuous Learning

• Apply and build knowledge of the Qlik BI toolset, including data visualization capabilities, to support enterprise reporting needs.
• Train end-users on BI solutions and applications.
• Other duties as assigned.

Knowledge - Skills - Abilities

• Strong interpersonal, oral, and written communication skills, with a collaborative, team-oriented approach.
• Strong critical and creative thinking skills, with the ability to generate practical, sound solutions to technical and business challenges.
• High attention to detail and accuracy in data management, reporting, and documentation.
• Ability to exercise sound independent judgment and decision-making when faced with complex or competing priorities, escalating appropriately when issues exceed the scope of independent judgment.
• Strong analytical abilities and proficiency with standard business software, including spreadsheets, presentation tools, word processing, databases, and graphics applications.
• Ability to work independently on assigned tasks while collaborating effectively within cross-functional teams.
• Experience with enterprise BI technologies including, but not limited to, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft SQL Server Management Studio, Qlik analytics tools or equivalent (for example, Tableau, Power BI).
• Familiarity with enterprise systems such as Workday and their integration with enterprise analytics platforms.

Qualifications

Appropriate experience may be substituted on an equivalent basis.

Minimum Required Education: Bachelor's Degree

Minimum Required Experience: 6 years

Preferred Education: Master's Degree

Preferred Experience: Computer Science, Information Systems, Technology, Engineering or related field is required in order to understand computer systems principles in relevant technology acquired through a combination of education and experience is required.

Physical Requirements

Work requires occasionally lifting moderate weight materials, standing, or walking continuously.

Work Environment

Occasional exposure to dust, noise, temperature changes, or contact with water or other liquids. Work is performed in an environmentally controlled environment.

Sensory Acuity

Ability to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects.

#LI-AV1

Why MCW?

• Outstanding Healthcare Coverage, including but not limited to Health, Vision, and Dental. Along with Flexible Spending options
• 403B Retirement Package
• Competitive Vacation and Paid Holidays offered
• Tuition Reimbursement
• Paid Parental Leave
• Employee & Family Assistance Program (EFAP)
• Pet Insurance
• On campus Fitness Facility, offering onsite classes
• Additional discounted rates on items such as: Select cell phone plans, local fitness facilities, Milwaukee recreation and entertainment etc.

For a brief overview of our benefits see: Benefits Overview

For a full list of positions see: MCW Careers

At MCW all of our endeavors, from our internal operations to our interactions with our partners, are driven by our shared organizational values: Caring - Collaborative - Curiosity - Inclusive - Integrity - Respect. We are committed to fostering an inclusive environment that values diversity in backgrounds, experiences, and perspectives through merit-based processes and in alignment with all applicable laws. We believe that embracing human differences is critical to realize our vision of a healthier world, and we recognize that a healthy and thriving community starts from within. Our values define who we are, what we stand for and how we conduct ourselves at MCW. If you believe in embracing individuality and working together according to these principles to improve health for all, then MCW is the place for you. For more information, please visit our institutional website.

MCW as an Equal Opportunity Employer and Commitment to Non-Discrimination

The Medical College of Wisconsin (MCW) is an Equal Opportunity Employer. We are committed to fostering an inclusive community of outstanding faculty, staff, and students, as well as ensuring equal educational opportunity, employment, and access to services, programs, and activities, without regard to an individual's race, color, national origin, religion, age, disability, sex, gender identity/expression, sexual orientation, marital status, pregnancy, predisposing genetic characteristic, or military status. Employees, students, applicants or other members of the MCW community (including but not limited to vendors, visitors, and guests) may not be subjected to harassment that is prohibited by law or treated adversely or retaliated against based upon a protected characteristic.