Enterprise BI Systems Analyst

Medical College of Wisconsin

Madison (WI)

On-site

USD 90,000 - 130,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

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

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.

Summary

Primary Responsibilities

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.

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.

Get your free, confidential resume review.

or drag and drop your file here.