The Enterprise BI and Analytics Analyst serves as a senior analytics subject matter expert responsible for translating complex business needs into scalable analytics solutions that support data-driven decision-making across MCW. This role acts as a critical bridge between business stakeholders, operational leaders, BI developers, reporting analysts, data management teams, IT, and external partners. In addition, this role focuses on cross-system analytics, enterprise data models, and advanced analytical solutions delivered through enterprise BI platforms.
The Senior Analyst leads requirements discovery, performs advanced data analysis, and designs data transformation logic and functional specifications for enterprise analytics dashboards, reports, and data products. This role plays a key part in shaping the organization’s analytics capabilities by improving data accessibility, enabling actionable insights, and promoting modern data visualization practices.
Working both independently and collaboratively, the role investigates complex cross-system data challenges—often spanning enterprise platforms such as Workday, enterprise data warehouse environments, and BI reporting tools—and develops practical solutions. The role requires strong analytical expertise, independent problem solving, and the ability to manage multiple priorities in a fast-paced environment where business requirements evolve rapidly.
Lead complex analytics initiatives by translating business requirements into scalable data models, transformation logic, and analytics solutions.
Conduct advanced requirements analysis and develop detailed functional specifications for enterprise dashboards, analytics applications, and BI reporting solutions.
Partner with Workday reporting teams to translate operational system data into enterprise analytics models and curated datasets within the BI environment.
Design calculations, metrics, and transformation logic to ensure consistent and accurate analytics across reporting platforms.
Perform complex data analysis and root cause investigation across multiple enterprise systems and data sources.
Independently troubleshoot and resolve complex data issues involving enterprise applications, data pipelines, and reporting environments.
Collaborate with internal teams and external partners—including the Workday Solution Center—to investigate and resolve system or data integration challenges.
Work closely with operational leaders, BI developers, reporting analysts, and data management teams to ensure analytics solutions align with business goals and operational workflows.
Provide leadership in analytics design by recommending best practices in data modeling, metric definitions, and data visualization standards.
Mentor analysts and collaborate with BI developers to improve analytics quality, performance, and scalability; with measurable contributions to team capability and delivery outcomes expected as evidence of effective mentorship.
Contribute to the design and continuous improvement of enterprise analytics architecture and reporting standards.
Partner with departments across MCW’s missions and clinical enterprise to expand and mature the organization’s analytics footprint.
Support and enhance the enterprise BI intake and triage process to improve prioritization and delivery of analytics initiatives.
Analyze enterprise reporting usage and recommend improvements to optimize analytics delivery and operational efficiency.
Write advanced SQL scripts for data extraction, transformation, and analysis across enterprise data platforms.
Ensure high standards for data quality, data governance, and data accuracy in analytics deliverables.
Focus on design, development, and maintenance of the enterprise reporting platforms like SSRS, Qlik, and SSAS cubes, rather than operational reports generated directly from transactional systems.
Develop and maintain technical documentation, business logic definitions, and data mapping documentation for analytics solutions.
Manage multiple concurrent analytics initiatives, balancing competing priorities while maintaining high standards of accuracy and reliability; consistently meet agreed-upon timelines and quality deliverables while maintaining transparency and communication with role manager on a regular basis.
Adapt quickly to evolving business requirements and guide analytics solutions through changing priorities and organizational needs.
Participate in enterprise analytics initiatives and cross-functional projects as required.
Perform other duties as assigned.
Advanced analytical and problem-solving skills with the ability to independently diagnose and resolve complex data challenges.
Strong ability to translate complex technical data concepts into meaningful business insights.
Excellent interpersonal, collaboration, and stakeholder engagement skills.
Strong written and verbal communication skills with the ability to produce clear technical and functional documentation.
Demonstrated ability to manage multiple complex projects and competing priorities in a fast-paced environment.
Advanced proficiency in SQL and relational databases for data analysis, transformation, and scripting.
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.
Understanding of data governance, data quality practices, and enterprise reporting standards.
Ability to work independently with minimal supervision while collaborating effectively within cross-functional teams; proactively address risks, scope changes to the role manager in a timely manner.
Strong organizational and task management skills with attention to detail and quality.
Appropriate experience may be substituted for education on an equivalent basis.
Minimum Required Education: Bachelor’s degree
Minimum Required Experience: 8 years
Work requires occasionally lifting moderate weight materials, standing, or walking continuously.
Occasional exposure to dust, noise, temperature changes, or contact with water or other liquids. Work is performed in an environmentally controlled environment.
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-AV
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.
Skills Required
- Bachelor's degree
- Minimum 8 years of relevant experience
- Advanced proficiency in SQL and relational databases
- Experience with SQL Server Analysis Services (SSAS), SSRS, and Microsoft SQL Server Management Studio (SSMS)
- Experience with Qlik or equivalent BI tools (Tableau, Power BI)
- Familiarity with Workday and its integration with analytics platforms
- Understanding of data governance and data quality practices
- Experience designing enterprise data models, transformation logic, and functional specifications
- Strong written and verbal communication and stakeholder engagement skills
- Experience mentoring or leading junior analysts
What We Do
The Medical College of Wisconsin brings a synergy between the best medical education, research and patient care.
