Enterprise BI Systems Analyst

The Medical College of Wisconsin, Inc.; Madison (WI); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health benefits

Tuition reimbursement

Paid holidays

On-campus fitness facility

Job summary

The Medical College of Wisconsin, Inc. is seeking a data warehouse/BI specialist to support enterprise BI data warehouse management, data design, and reporting.

You will build data models, develop ETL processes, and provide insight to business teams for informed decision-making. You will collaborate with administration, finance, HR, and clinical units, ensuring data accuracy and timely delivery of dashboards and reports using SSAS, SSRS, and modern BI tools.

Qualifications

• Bachelor’s Degree required.
• Minimum 6 years of relevant experience.
• Experience with enterprise BI technologies (SSAS/SSRS, SQL Server, Qlik, Tableau/Power BI) is required.

Responsibilities

• Perform data migration and ETL using SSIS or Qlik modeling; develop SQL scripts for data acquisition.
• Clarify and translate business requirements into technical specifications for BI solutions.
• Construct and redesign SSRS reports and SSAS cubes; document BI deliverables.

Skills

ETL

SQL scripting

Data modeling

BI tooling

SQL Server SSAS/SSRS

Qlik/Power BI/Tableau

Communication

Education

Bachelor’s Degree

Tools

SSIS

Qlik

SSRS

SSAS

SQL Server Management Studio

Job description

SummaryUnder 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 ResponsibilitiesData Integration & ETL SupportPerform 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 SupportWork 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 & DocumentationConstruct 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 ResolutionPerform 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 LearningApply 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 – AbilitiesStrong 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.QualificationsAppropriate experience may be substituted on an equivalent basis.Minimum Required Education: Bachelor’s DegreeMinimum Required Experience: 6 yearsPreferred Education: Master’s DegreePreferred 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 RequirementsWork requires occasionally lifting moderate weight materials, standing, or walking continuously.Work EnvironmentOccasional exposure to dust, noise, temperature changes, or contact with water or other liquids. Work is performed in an environmentally controlled environment.Sensory AcuityAbility to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects.#LI-AV1Why MCW?Outstanding Healthcare Coverage, including but not limited to Health, Vision, and Dental. Along with Flexible Spending options403B Retirement PackageCompetitive Vacation and Paid Holidays offeredTuition ReimbursementPaid Parental LeaveEmployee & Family Assistance Program (EFAP)Pet InsuranceOn campus Fitness Facility, offering onsite classesAdditional 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 OverviewFor a full list of positions see: MCW CareersAt 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.