Qlik/Tableau Analyst

The Medical College of Wisconsin (MCW) is where a diverse group of thought leaders in science, medicine, education and community engagement work together to build a healthier future. At the core of everything we do with our partner Froedtert Hospital is academic medicine, a model—and a way of thinking—that finds scientists, physicians and students working hand-in-hand with community to solve the toughest challenges in health and society at large. Together, and with the support of the philanthropic donations through MCW or the Froedtert Hospital Foundation, we are committed to exploring every possibility to improve health in the region, the state and beyond.

More than 1,400 students are enrolled in MCW’s medical school and graduate school programs in Milwaukee, Green Bay, and Central Wisconsin. MCW’s School of Pharmacy opened in 2017. A major national research center, MCW is the largest research institution in the Milwaukee metro area and second largest in Wisconsin. In FY2016, faculty received more than $184 million in external support for research, teaching, training and related purposes. This total includes highly competitive research and training awards from the National Institutes of Health (NIH). Annually, MCW faculty direct or collaborate on more than 3,100 research studies, including clinical trials. Additionally, more than 1,500 physicians provide care in virtually every specialty of medicine for more than 525,000 patients annually.

Purpose

To achieve the fundraising goals aligned with the institutional priorities of the Medical College and Froedtert Hospital Foundation, the Database Analyst III supports and guides the Operations teams initiatives around data and data analytic programming and management using advanced data visualization tools.

This role is a business intelligence pro with a talent for blending creativity, critical thinking, and strategy to help visualize data. This role will collect, program, analyze, and report on data using data visualization tools and business intelligence acumen to provide key knowledge and value for our department as well as institutionally across MCW and Froedtert Hospital Foundation. Current areas include strategic and operational dashboards and metrics, as well as the database and reporting supporting the healthcare philanthropy program.

Responsibilities:

Programming:

• Bring together and link data from multiple sources and provide a complete, accurate, and up-to-date dataset for BI, data analysis and other applications and business processes.
• Proficient in load script editors, expressions, set analysis and variables, as well as dimension tables to develop programming for new applications as well as maintain current applications.
• Understanding of third-party integrations via API’s and classic programming languages, including SQL, Excel (VBA) Object Orient Programming, NET and JavaScript, to leverage data functionality and integration.

Data Collection

• Responsible for data collection, management, analysis, and visualization of large datasets, integrating different data sources for optimal impact of reporting.
• Conducts data collection, cleaning, database management, descriptive analysis, and dissemination to transform data into valuable insights and actionable knowledge.
• Skilled in quantitative data management tools, methods of data collection, and written and oral communication to reinforce the link between data analytics and department strategies.

Data Reporting

• Builds data visualizations and reporting of key data for healthcare philanthropy program, dashboards, and metrics
• Creates and maintains dashboards to assess and monitor trends, performance, and goal progress
• Ensures data is accurate and well-utilized to support fundraising

Other Responsibilities:

• Ensures compliance with organizational and departmental policies and procedures as well as regulatory and HIPAA standards.
• Performs related duties as needed.

Preferred Schedule:

Position Requirements:

Minimum Qualifications:

Appropriate experience may be substituted for education on an equivalent basis

• Bachelor’s Degree
• 4 Years Experience

Preferred Qualifications:

• Proficient in the use of data visualization tools like Power BI, QlikSense, and Tableau, along with advanced Excel skills.
• Understand data warehouse concepts, dimensional data models, and architectures
• Experience working with large sets of data and integrating data across different platforms
• Experience with finance and billing systems desired. Healthcare claims experience a plus.
• Strong analytical and quantitative skills
• Skilled as a business translator (identifying business problem, interpretation, data analytics, reporting, and storytelling)
• Excellent customer service skills with the ability to understand user needs
• Exceptional attention to detail and ability to work effectively with minimal supervision

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
• 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 full list of positions see:

For a brief overview of our benefits see:

Eastern Wisconsin is a vibrant, diverse metropolitan area. MCW is intent on attracting, developing, and retaining a diverse workforce and faculty body that reflects the community we serve. We value diversity of backgrounds, experience, thought, and perspectives to advance excellence in science and medicine. MCW is a welcoming campus community with a strong culture of collaboration, partnership, and engagement with our surrounding community.

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 a diverse 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.