Enterprise BI Systems Analyst

The Medical College of Wisconsin, Inc.; Wisconsin; Hybrid; USD 85,000 - 125,000; Full time

Benefits offered by this job

Health insurance

403B Retirement Plan

Tuition Reimbursement

Paid holidays

Job summary

The Medical College of Wisconsin is seeking a business intelligence professional to oversee data warehouse management, ETL processes, and reporting. You will collaborate with administrators, finance, HR, clinical operations, and leadership to ensure data accuracy and actionable insights.

Responsibilities include building data models, dashboards, SSRS reports, and SSAS cubes, while documenting methodologies and supporting end‑users with BI tools and training.

Qualifications

• Bachelor's degree required.
• Minimum 6 years of experience.
• Master's degree preferred.
• Experience in data warehousing, BI, and analytics.

Responsibilities

• Perform data migration and ETL using SSIS or Qlik data modeling and scripting.
• Develop SQL scripts for data acquisition and manipulation.
• Construct and redesign SSRS reports and SSAS cubes.
• Document development methods and BI solutions.
• Provide end-user training on BI tools.

Skills

ETL

SQL

Data Warehouse

Qlik

SSIS

SSAS

SSRS

Data Modeling

Stakeholder Communication

Education

Bachelor's Degree

Master's Degree

Tools

SSIS

SSRS

SSAS

Job description

Summary 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.

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.

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.
• 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.

About Us

Together, we can build a healthier world. A student, an educator, a scientist and a community leader - alone, they can do many things. Together, the question isn’t what they can do, but what can’t they. The Medical College of Wisconsin (MCW) brings together the most inquisitive, passionate minds in science, medicine, education and community engagement to tackle today’s toughest challenges in health and society. Academic medicine is at the center of where scientists, physicians and students work hand-in-hand with the community to ask the most important questions and fuel the cycle of innovation that shapes the future of medicine. Medical College of Wisconsin The tireless pursuit of knowledge and the power of academic medicine is at the core of everything we do at MCW. Bringing together the world’s top scientists and clinicians, inspired students and invested communities, we are driven to solve the most complex challenges in health and society. With around 1,600 full-time and part-time faculty and approximately 3,500 full-time employees, MCW is home to a diverse group of thought leaders working in collaboration to pioneer pathways to a healthier world and drive a continuous cycle of life-changing discovery.