HOME
VIEW ACADEMIC JOBS
CREATE A FREE ACCOUNT
JOB SEEKER ENTRANCE
EMPLOYER ENTRANCE
 
 
 
 
 
 
 
Job Seekers
Register
Post Resume
Find Jobs
Get jobs by email
 
 
Employers
Register
Post Jobs
Find Resumes
Get resumes by email
 
 
 
 
 
 
 
 
Database Analyst/Programmer Senior / Intermediate
University of Michigan in Ann Arbor, Michigan
 
 
Apply
 
Date Posted 05/11/2022
Category
Admin-Computing-Programming/Analyst
Employment Type Full-Time
Application Deadline Open until filled
 
 
 
 
 

How to Apply

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

Summary

The Department of Internal Medicine is looking for a Data Analyst/Programmer to support the financial data needs of the Department.  Under the supervision of the Senior Finance Business Consultant, this person will help navigate complex data, assist in report development, help improve our finance and reporting processes through access to necessary data.  The Internal Medicine financial database is 3 years old and it continues to grow. We are looking for a team member who communicates well, is goal oriented and has the technical data skills to navigate our complex data needs.  This person will help us maintain and improve our current reporting needs and provide insight to improve our processes and documentation.

Functional supervision of this position will be provided by the Senior Finance Business Consultant.  This supervision will include training, mentoring, daily management of work and technical evaluation of work components.  Administratively, this position will report to the Finance Director. 

Mission Statement

Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally.  Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.

Who We Are

The aim of Michigan Medicine is to advance health to serve Michigan and the world. With annual revenues of approximately $5.0 billion, Michigan Medicine ranks as one of the top academic health centers in the country, and is committed to providing exceptional patient care, facilitating groundbreaking research, and developing the next generation of physicians and scientists. Michigan Medicine consists of the University of Michigan Hospitals, the University of Michigan Medical School and its Medical Group, Michigan Health Corporation, and affiliated health systems. 

 

What Benefits can you Look Forward to? 

  • Excellent medical, dental and vision coverage effective on your very first day 

  • Flexible spending accounts  

  • Prescription Drug Plan  

  • Mental and emotional health programs  

  • Child Care Resources  

  • Life Insurance  

  • Legal Services Plan  

  • 2:1 Match on 401K 

 

Another reason to Go Blue!  

  • Nationally Recognized for work/life effectiveness by WorldatWork 

  • Top 5 employer in Michigan by Crain’s Detroit Business  

  • Forbes #1 Best Employer in Michigan 

  • Ranked #11 in the US and best in Michigan “Best Hospitals” rankings for 2020-21 

  • Five medical specialties ranked in the nation’s top 10 and was ranked No. 1 in the state of Michigan. 

  • Michigan Medicine ranked #15 in Newsweek’s “World’s Best Hospitals” rankings 

Responsibilities*

  • Provide programming and process development support for the Internal Medicine Finance Department, Department Leadership and our 13 Divisions.  
  • Interface with end-users and programmers to create complex data sets. 
  • Translate abstract concepts and business requirements into technical solutions. Design and implement databases with respect to access methods, access time, batch processes, validation checks, ETL tasks, security, documentation, and analyses methods. Model information in a way such that customers can easily consume the data. 
  • Write programs to extract, transform and load data into Oracle tables from various data sources. Maintain documentation of decisions made during the build of SQL queries. 
  • Design, develop and test database objects, such as Stored Procedures, Triggers, Functions, Tables, Views and Scripts. 
  • Write SQL queries that validate the data accuracy and fulfillment of business requirements. 
  • Develop, maintain, and manage advanced reporting, analytics, dashboards, and other BI solutions. 
  • Create ERD, data mapping document and technical specifications. 
  • Collaborate effectively with System Administrators, Network Administrators, and DBAs on best practices for all our reporting solutions.

Required Qualifications*

  • Hands-on experience in creating complex Views, Functions, and Stored Procedures in the Oracle environment. 
  • ?Demonstrated ability to integrate large data sets from various data sources.  Experience with ETL tools, Oracle Database Link and Materialized Views
  • ?Excellent skills in relational database design and query optimization.  Ability to translate business requirements into program codes to support comprehensive data collection and complex analyses.
  • Strong aptitude for debugging problems independently and tracing root causes across multiple functional teams.
  • Committed to data security and the protection of sensitive information with demonstrated knowledge of applicable data use/sharing safeguards

 

 Senior Level: 

  • Bachelor’s degree or higher with 5-7 years of relevant professional experience

 Intermediate Level: 

  • Bachelor’s degree with 3-5 years of relevant professional experience

Desired Qualifications*

  • Extensive experience with U-M maintained datasets (i.e., Revenue Cycle, Sponsored Projects, Payroll, Human Resources, Financial...etc.) and data analysis & visualization tools.
  • Hands-on experience with creating Tableau Dashboards from concept inception to completion.  Working knowledge of Tableau architecture, security, and administration.
  • Knowledge and experience with SAP Business Objects Universe Designer.
  • Hands-on experience in creating ERD, data mapping, and business requirements documentation.
  • Experience in OLTP and OLAP systems.
  • Familiarity with Active Directory, AD Group Security, and single sign-on environment.

Underfill Statement

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

Background Screening

Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings.  Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.

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.


U-M COVID-19 Vaccination Policy

COVID-19 vaccinations, including boosters when eligible, are required for all University of Michigan students, faculty and staff across all campuses, including Michigan Medicine.  This includes those working remotely.   More information on this new policy is available on the Campus Blueprint website or the UM-Dearborn and UM-Flint websites.

Apply
*Please mention academicjobs.net to employers when applying for this job*
 
 
 
Academic Jobs
Academic Advertising
260 Peachtree Street, N.W.
Suite 2200
Atlanta, GA 30303
 
Twitter
LinkedIn
Facebook
Google Plus
 
About Academic Jobs
Advertise Jobs
Contact Us
 
Site Map
Privacy Policy
Terms of Use
Resources / Links
Copyright © 2022 Academic Jobs - All Rights Reserved.