Overview

Employee must have a diverse background concerning data analysis and reporting. This person should understand how to decipher existing data schemas for reporting and analysis; how to translate user needs into reports and dashboards; and how to merge data from disparate systems into usable datasets.

Responsibilities

• Work with other business units to determine reporting needs and assist building reports and/or dashboards to meet them.
• Generate documentation on reporting design and data schemas used as needed.
• Assist with auditing data integrity and consistency of various systems.
• Availability to work on weekends and evenings to complete time sensitive projects.
• Acquires knowledge for new technology and policy/procedure revisions.
• All other duties as assigned.

Qualifications

EDUCATION AND/OR EXPERIENCE:

• Bachelor’s degree, with a technical major and/or a minimum of one years’ experience in data analysis.
• Professional experience reporting from relational database systems (e.g. Microsoft SQL, MySQL/MariaDB).
• Experience in reviewing file-based data (e.g. csv or MS Excel) for consistency and quality.
• Experience in interviewing business colleagues to define data analysis and reporting needs.

OTHER SKILLS AND ABILITIES:

• Demonstrates the ability to recognize priorities in organization of workflow.
• Able to perform duties independently, with a minimal need for direct supervision.
• Ability to interpret, comprehend, and transmit complicated and detailed instructions accurately.
• Experience with central reporting tools for paginated reporting and visualizations.
• Ability to quickly learn software packages as needed.
• Ability to effectively communicate with others verbally and in writing.
• Advanced knowledge and proficiency in using personal computer equipment and related software.
• Ability to meet assigned deadlines.
• Knowledge and proficiency in grammar and spelling skills.
• Experience training users on basic reporting best practices.
• Experience adhering to HIPAA/HiTech, FERPA, or 21CFR Part 11 guidelines.
• Experience reporting Electronic Health Record system data, primarily Epic and/or Cerner.

INTERPERSONAL REQUIREMENTS:

• Demonstrates excellent interpersonal skills and ability to interact in a positive and helpful manner with all constituents both internally and externally in a culture of collaboration, innovation, and accountability.
• Ability to work effectively on group projects with internal and external customers in a collaborative manner.
• Applies knowledge of principles and process for providing exemplary stakeholder service and support. This includes assessment of stakeholder needs, meeting quality standards for services, and evaluation of stakeholder satisfaction.
• Maintains the confidentiality of patient, employee, physician, student, and institutional information.
• Supports and assists enhancing the diversity, culture and inclusiveness of the medical school.

About Western Michigan University Homer Stryker M.D. School of Medicine (WMed)

We are committed to excellence and health equity through transformative medical education, high-quality, patient- and family-entered care, innovative research, and community partnerships within a just culture of diversity, equity, inclusion, and belonging. Our vision is health equity for all in Southwest Michigan through innovation in the practice and study of medicine.

The medical school is a collaboration of Western Michigan University and Kalamazoo's two teaching health systems, Ascension Borgess and Bronson Healthcare. The medical school is a private nonprofit corporation supported by private gifts, clinical revenues, research activities, tuition, and endowment income. WMed is the recipient of a $100 million foundational gift and the Empowering Futures Gift, a philanthropic commitment of $300 million to support the mission of the medical school. WMed contributes to the economic vitality of Southwest Michigan through the services we provide as well as the creation of 1,600 new jobs and an annual estimated economic impact of $353 million in Kalamazoo and Calhoun counties.

WMed is fully accredited by the Liaison Committee on Medical Education and the Higher Learning Commission. The medical school offers a comprehensive, innovative four-year Doctor of Medicine degree program and a Master of Science degree program in Biomedical Sciences. We train physicians in 10 residencies and five fellowships accredited by the Accreditation Council for Graduate Medical Education. To support our educational mission, we have Joint Accreditation for interprofessional continuing education, which incorporates accreditation by the Accreditation Council for Continuing Medical Education.

WMed Health is the clinical practice of the medical school with more than 300 providers offering comprehensive primary care and specialty services in several locations throughout the Kalamazoo and Battle Creek areas. Faculty in the Department of Pathology serve as the Office of the Medical Examiner for counties throughout Michigan and northern Indiana.

The W.E. Upjohn M.D. Campus located in downtown Kalamazoo serves as the primary educational facility with student study and social spaces, team-based learning halls, faculty and administrative offices, a state-of-the-art Simulation Center accredited by the Society for Simulation in Healthcare, basic science research labs, as well as toxicology and forensic pathology labs.

WMed builds upon Kalamazoo’s century-long foundation of drug discovery and medical device development with a strategic investment in clinical, laboratory, community, and educational research. The Center for Immunobiology, Center for Clinical Research, Research Histology Lab, Innovation Center, and Human Research Protection Program contribute to the medical school’s advancement of knowledge through innovation and discovery. 

Western Michigan University Homer Stryker M.D. School of Medicine is an Equal Employment Opportunity/Affirmative Action employer of females, minorities, individuals with disabilities, and protected veterans, and actively strives to increase diversity within its community. We provide a drug- and tobacco-free workplace. 

EEO Minorities/Women/Disabled/Protected Veterans.