Senior/Intermediate Business Intelligence Analyst

Senior / Intermediate Business Intelligence Analyst

Apply Now

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 (one page or less), explain how this role aligns with your career goals and skills.

This position may be underfilled as an Intermediate Data Analyst

What You'll Do

Consult with clinics, academic departments, and research areas to analyze requests and define requirements.

Have a hand in furthering data automation and developing analysis.

Build data products, visualizations, and reports for researchers, faculty leadership, clinical directors, and finance colleagues.

Work mostly with Tableau, SQL, and Python, but will learn about services like Denodo and Airflow.

Collaborate with other data analysts, developers, and the larger IT team

Work with other units on campus to use University-wide tools and services (e.g. Business Intelligence Community of Practice) and national networks (e.g. Healthcare Data and Analytics

Who We Are

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.

This position is eligible for hybrid work (with weekly onsite requirements). You will report to the Assistant Director of Data Analytics and Development.

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 ourwebsite () . The University of Michigan also offerscomprehensive 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

BA or BS

5 years of experience

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)

Demonstrated ability to apply new or different ways of thinking to creatively solve problems

Work Schedule

Monday-Friday, 7 : 30 AM-5 : 30 PM. 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 thework 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

• Required Qualifications for an Intermediate Data Analyst BA or BS 3 to 5 years of experienceFamiliarity with and experience building visualizations and dashboardsExperience with creating reports and working with users to improve understandingExperience with SQLExperience with a variety of databases (Oracle, MySQL, PostGreSQL)

Job Functions / Duties Inter

Assists in data management, automation, virtualization, and integration efforts Understand data needs to maintain existing reporting services while developing new capabilities that drive business value. Current technologies include Tableau, PL / SQL, Sheets / Excel, Business Objects, PHP, Python, and proprietary adhoc reporting tools.Lead functional design for capturing, extracting, storing, and disseminating data across the organization. Help assess data quality and completeness Verify, integrate or blend data sets. Assume responsibility for data-related projects.

Develop and present data analytics solutions and datasets, dashboards, and other visualizations Develops Tableau dashboardsEnsure visualizations are relevant, actionable, and accessibleParticipates in qualitative and quantitative data analysis efforts at the School

Develop organizational understanding of the business of patient care, education, research, and related processes and information sources. Develop a comprehensive and cross-functional understanding of patient care, education, and research processes for Informatics service to faculty, staff, and students.Participates in master data management planning with data sources and access, and assist with data modeling and mapping, interoperability, web services, and / or migrations.Helps support strategic assessments and initiatives by applying qualitative and quantitative methods, modeling, and analytical techniques.Helps support data governance efforts

Functional and technical coordination of projects. Utilize collaborative methods, communication and documentation tools to ensure successful adoption and sustainability of solutions.Facilitate successful change management through immersion in client environment, testing, support, training, documentation, and compliance efforts using a variety of methods Partner with University of Michigan Information Technology Services (ITS), other universities, and informatics specialists to share efforts, leverage successes, promote sharing, and enhance value.

Other systems projects as assigned for support, data delivery, and interoperability.

Additional Information

This position is not eligible for immigration sponsorship.

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 / AA Statement

The University of Michigan is an equal opportunity / affirmative action employer.

Job Detail

Job Opening ID

260741

Working Title

Senior / Intermediate Business Intelligence Analyst

Job Title

BI Analyst Senior

Work Location

Ann Arbor Campus

Ann Arbor, MI

Modes of Work

Hybrid

Full / Part Time

Full-Time

Regular / Temporary

Regular

FLSA Status

Exempt

Organizational Group

School Dentistry

Department

DENT Informatics

Posting Begin / End Date

2 / 26 / 2025 - 3 / 08 / 2025

Salary

85,000.00 - $105,000.00

Career Interest

Administration

Apply Now

Salary : $70,000 - $85,000