Senior/Intermediate Data Analyst

How to Apply

To help the hiring team understand your experience, please submit both a cover letter and resume as one file. In the cover letter, explain how this role aligns with your career goals and skills. This position is not eligible for immigration sponsorship.

This position may be underfilled at the Intermediate level, depending on qualifications. The salary range for the Senior level is $85,000-$105,000 and the Intermediate level is $70,000-$85,000. 

For questions about this position or accommodation requests, please contact talent.acqusition@umich.edu.

Job Summary

The School of Dentistry (SoD) Dental Informatics IT department invites you to be an important part of our team as a Data Analyst. You'll collaborate with clinicians, educators, researchers, and leaders to maximize the power of data for evidence-based decision-making, operational excellence, and strategic growth. At Dental Informatics, your professional development is a priority. You'll have access to exciting project opportunities, cross-unit collaboration, and the university's professional development resources to support your growth. You will report to the Assistant Director of Data Analytics and Development.

You will need to be fully onsite at our office in Ann Arbor, MI for the initial orientation period. After the orientation period, you will be eligible for a hybrid schedule (with weekly onsite requirements).

What You'll Do

• Partner with clinics, academic departments, and research areas to define requirements and use your expertise to deliver best-in-class analysis.
• Lead data analysis and automation efforts for the School of Dentistry.
• Build data products, visualizations, and reports for researchers, faculty leadership, clinical directors, and finance colleagues.
• Work mostly with Tableau, SQL, and Python, but learn about services like Denodo and Airflow.
• Collaborate with other data analysts, developers, and the larger IT team and embody the role of a subject matter expert.
• Work with other units on campus to leverage University-wide tools, services (e.g. Business Intelligence Community of Practice) and national networks (e.g. Healthcare Data and Analytics Association) to bring new technologies to the School of Dentistry.

Why Work at Michigan?

The School of Dentistry is consistently ranked as the #1 dental school in the United States and the world. We embrace diversity in many forms and champion diversity of thought and culture. Our Mission, core values, and additional information about our school can be found on our website. The University of Michigan also offers comprehensive benefits to help you stay well and to support you as you plan for a secure future. Benefits include:

• Generous paid time off for vacations, holidays, sick time, season days, and paid parental leave.
• A retirement plan that provides two-for-one matching contributions after the first year of employment.
• Many choices for comprehensive health insurance.
• Life insurance.
• Flexible spending accounts for healthcare and dependent care expenses.
• Work-life programs to strengthen a workplace culture that supports personal and family life, including child care, elder care, lactation resources, and mental and emotional health services.

Required Qualifications*

• Bachelor's degree
• 5+ years of experience working with data
• Proficiency in building impactful dashboards and visualizations with Tableau
• Proficiency with SQL & Python
• Experience with creating charts, graphs, and reports and working with users to improve understanding
• Experience with a variety of databases (Oracle, MySQL, PostgreSQL)

Work Schedule

The School of Dentistry operates from Monday-Friday, 7:30 AM-5:30 PM. Our clinics may operate until 7:30 PM one to two evenings a week and occasionally on Saturdays. IT system upgrades, critical fixes, and maintenance are performed outside of normal business hours.

Work Locations

This is a hybrid position with an onsite presence at 1011 North University Ave, Ann Arbor, MI 48109. Your primary working location will be within a set area within the School of Dentistry with the ability for a hybrid schedule. The School of Dentistry comprises multiple clinics and administrative locations in Ann Arbor. On occasion, you may travel to those locations.

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

Underfill Statement

This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

Salary range for the Intermediate level is $70,000 -$85,000/yr

What You'll Do as an Intermediate Data Analyst:

• Consult with clinics, academic departments, and research areas to analyze requests and define requirements.
• Contribute in advancing data automation and analysis.
• Build data products, visualizations, and reports for School of Dentistry stakeholders.
• Work mostly with Tableau & SQL, and Python, but learn about technologies like Python, Denodo, and Airflow.
• Collaborate with other data analysts, developers, and the larger IT team to creatively solve problems.
• Work with other units on campus to learn about University-wide tools and services (e.g. Business Intelligence Community of Practice) and national networks (e.g. Healthcare Data and Analytics Association).

Required Qualifications for an Intermediate Data Analyst:

• Bachelor's degree
• 3 to 5 years of experience working with data
• Familiarity with and experience building visualizations and dashboards
• Experience with creating reports and working with users to improve understanding
• Experience with SQL & Python
• Experience with a variety of databases (Oracle, MySQL, PostGreSQL)

Additional Information

This position is not eligible for immigration sponsorship.

Your primary working location will be within a set area within the School of Dentistry. The School of Dentistry comprises multiple clinics and administrative locations in Ann Arbor. On occasion, you may travel to those locations.

Hours of Operation: The School of Dentistry operates from Monday-Friday, 7:30 AM-5:30 PM. Our clinics may operate until 7:30 PM one to two evenings a week and occasionally on Saturdays. IT system upgrades, critical fixes, and maintenance are performed outside of normal business hours.

Background Screening

The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third party administrator to conduct background checks.  Background checks are performed in compliance with the Fair Credit Reporting Act.

Application Deadline

Job openings are posted for a minimum of seven calendar days.  The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.

U-M EEO Statement

The University of Michigan is an equal employment opportunity employer.