IN-IDOH Trauma System Data Analyst

Theincumbent will analyze trauma and injury data for the Division of Trauma andInjury Prevention. The role will include exploratory data analysis, reporting,descriptive statistics, dataset curation, data visualization, and data linkage.

PURPOSEOF THE POSITION

Incumbent works for the Division of Trauma and Injury Prevention at the Indiana Department of Health (IDOH) on analysis of data related to Indiana s trauma system. Incumbent reports to the Surveillance and Evaluation Director, IDOH Division of Trauma and Injury Prevention. The incumbent seeks to improve trauma care across the spectrum of trauma system activities by focusing on all aspects of the statewide trauma data collection and analysis, including trauma registry and emergency medical services (EMS)data.

DUTIESAND RESPONSIBILITIES

Conducts general analysis of trauma-related data; serves as project lead, as assigned.

Performs and documents procedures for data preparation including record linkage, data cleaning, standardization, analysis and interpretation;

Works with Trauma System Epidemiologist to improve quality, accuracy and timeliness of data submitted to the Indiana Trauma Registry;

Queries and analyzes trauma registry and related data (e.g., emergency medical services[EMS] data) for data requests as necessary, in conjunction with the Data Release Committee;

Applies principles of good ethical, legal, and public health practice as they relate to data reports, design and data collection, dissemination and use;

Provides operational support for the database to the Division, ensuring data integrity, database availability, and performance;

Develops integration of database systems through standardized database design techniques;

Develops data collection and evaluation methodologies, including format design, project criteria and requirements, data compilation, relevancy and usage;

Incorporates interpersonal skills in communication with agency personnel, colleagues, and the public;

Collaborates with trauma stakeholders for best practices in data analysis and effective data reporting;

Some travel may be required;

Performs related duties as assigned.

JOB REQUIREMENTS

Bachelor s degree in Health Data Analysis/Management, Statistics, Public Health(Epidemiology/Biostatistics), Epidemiology or related field of study required; Master s degree preferred.

Experienced with SAS, R, Python or other relevant statistical software and statistical procedures, including data cleaning, running descriptive statistics, and full analyses;

Experience with Tableau and other data visualization software;

Working knowledge of epidemiological methods, study design, and analysis needed with an understanding of both qualitative and quantitative data.

Ability to manage multiple projects and priorities;

Possess significant process and people skills to appropriately perform the duties of the position;

Ability to query trauma databases, including Indiana Trauma Registry;

Ability to translate trauma data requests into descriptive summaries and appropriate statistical tests;

Ability to work closely with colleagues to identify data-related problems and to provide quality customer service;

Ability to communicate effectively, both orally and in writing;

Ability to teach others how to submit data to a registry and respond to stakeholder questions;

Ability to analyze, communicate and recommend future needs and direction for agency s data processing software/hardware environment, specifically related to trauma data needs;

Ability to ensure that complex diagnostic, structure, logic, performance and tuning procedures relative to the operating system are performed;

Demonstrated ability to lead strategically;

Expert in the collection and use of data and skilled in working with data for data analysis purposes;

Knowledge of relational database and data warehouse design techniques and dimensional modeling processes;

Knowledge of computer hardware/software capabilities and configurations;

Knowledge of specialty area(s) of database administration and/or system software such as communication, storage management, operating systems or capacity planning;

Previous experience working with health care databases is preferred;

Working knowledge of MS Office Suite including Excel, Word, and PowerPoint.

DIFFICULTYOF WORK

Incumbent uses judgment in selecting the guidelines to follow, but also relies on the direction of the Surveillance and Evaluation Director. Work is broad in scope and requires in-depth analysis of multiple variables to fit various circumstances of a medium to complex enterprise-wide system.

RESPONSIBILITY

Incumbent exercises professional judgment in situations requiring sensitivity and/or confidentiality. Incumbent works closely with higher-level staff and/or management to outline general objectives and boundaries that incumbent will follow to meet the requirements of the agency. Unusual problems or deviations from guidelines or practice are discussed with the Surveillance and Evaluation Director.

General goals, objectives and problems affecting agency policy and practices are discussed with superiors, but incumbent utilizes own initiative in performing and data analysis of the Indiana Trauma Registry and other data sets. Generalmethodology and handling of procedures are at the discretion of the incumbent.His/ her work is reviewed by superiors concerned for compliance with policy andagency program goals.PERSONAL WORK RELATIONSHIPS

Incumbentworks primarily with personnel from within the agency, including divisionstaff, other state agency staff, EMS providers, hospital employees and othersfor the purpose of analyzing trauma registry data. Contacts are for the purposeof informing, gathering information and interpreting that information to arriveat appropriate solutions, provide technical expertise and coordinate workflow.Contacts can involve persuading and negotiating to accomplish mission whilemaintaining good client relations.

Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceBachelor s degree in Health Data Analysis/Management, Statistics, Public Health (Epidemiology/Biostatistics), Epidemiology or related field of studyRequired0Experience working as a data analyst, epidemiologist, or related roleRequired2YearsExperience analyzing data using SAS, R, Python or other statistical software to perform data cleaning and analysisRequired2YearsDemonstrated experience performing data cleaning, calculating descriptive statistics, and performing appropriate statistical analysesRequired2YearsExperience using the MS Office Suite in a professional setting (Excel, Word, PowerPoint)Required2YearsAbility to prepare reports including descriptive statistics, statistical analyses, and interpretation of findingsRequired0Possess significant process and people skills to appropriately perform the duties of the positionRequired0Previous experience working with health care databases is preferredHighly desired0Experience with data visualization in TableauHighly desired0Master's degree in Health Data Analysis/Management, Statistics, Public Health (Epidemiology/Biostatistics), Epidemiology or related field of studyDesired0Working knowledge of data linkage techniquesDesired0Knowledge of database administration and/or system software such as communication, storage mgmt, operating systems or capacity planningNice to have0Knowledge of relational database and data warehouse design techniques and dimensional modeling processesNice to have0
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement?Question2Please provide candidate email address.Question3Candidate must currently be located in Indiana with the ability to work onsite in Indianapolis. Please provide the address the candidate resides.Question4Candidate must be paid $$$ for this engagement. The provider markup for this position is 15%. Do you accept this requirement?Question5Selected resource will be required to work a hybrid schedule with 3 days onsite per week with one of those days being Wednesday. Please confirm the resource understands the work schedule.Question6Candidates selected for further evaluation will be required to complete an analytic project and submit it for review. Instructions for the project will be sent to candidates selected for interview, but no additional guidance will be given beyond the initial instructions. Candidates who fail to provide a deliverable by 24 hours prior to interview will be removed from consideration; candidates may also be excluded if an incomplete deliverable is provided. Please affirm your understanding of this requirement.