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.
Acts as a liaison between the analytic team and the data management team to implement new products and programs (e.g. disease registries and reporting) including collection of data requirements, data capture and storage, and testing. Works with internal and external stakeholders to develop processes for data exchange and data manipulation. This position works under the direction of senior and lead staff to utilize SQL, PL/SQL and ETL tools to load and manipulate internal and external healthcare data. Assists in creation of merged data sets and may combine information across systems internal and external to the UMHS, including the electronic medical record and the health system data warehouse to build analytically ready tables and data sets. Coordinate with other team members to determine timing of development efforts and key milestones. Create documentation related to data management activities. Designs and delivers analyses and reports using Tableau. This position is directly responsible to the Manager of Quality Analytics and works directly with the Team Lead of Population Health, senior staff and analytic team members to achieve departmental goals.
Gather and define data requirements and specifications for data capture, storage and testing. Work with internal and external stakeholders, and senior team members to develop processes for data exchange and data manipulation. Perform testing to ensure data quality and integrity. Develop solid understanding of various billing, scheduling and other clinical operational processes and applications in order to better support analytic requirements. Utilize SQL, PL/SQL and ETL tools to load and manipulate internal and external healthcare data. Listen, observe, discuss, read existing code, review internal and external data dictionaries and documentation, and analyze data in order to understand various processes and available data sources. Create reports that have roll up and drill down capabilities using Business Intelligence tools. Write the specifications for patient registries.
Create documentation related to data management activities.
Coordinate with other team members to determine the timing of development efforts and key milestones.
Other duties as assigned.
Bachelor’s degree in Computer Science, or related field, or another bachelor’s degree with equivalent experience
3 plus years of experience in information technology business analysis or data management
Experience with clinical healthcare data, including data management, and integration of multiple data sources
Excellent collaboration, interpersonal, presentation, written, listening, and verbal communication skills
Experience in an analytical environment (e.g., data warehouse, business intelligence)
Use of BI reporting tools like Tableau, Cliq, OBI
Strong customer service skills
Excellent analytical and problem-solving ability
Excellent organizational skills and attention to detail
Flexibility to adapt to a changing environment
Epic (vendor) applications, especially Clarity
Experience with reporting tools (e.g., Crystal Reporting, Brio Query, MS Access)
Experience with ETL tools (e.g., Pentaho, Informatica)
Understanding of web-based application technologies
Experience with the University of Michigan
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.
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.
Job openings are posted for a minimum of seven calendar days. This job may be removed from posting boards and filled anytime after the minimum posting period has ended.
The University of Michigan is an equal opportunity/affirmative action employer.
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For..." survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.