Designs and maintains new health information systems and databases and extracts data from existing databases to create relevant datasets for subsequent analyses
Develops documentation and procedures for databases and health information systems
Coordinates the maintenance of existing health information databases including updating datasets and deriving new variables, in consultation with the Supervisor, epidemiologists and other users
Adheres to Divisional and other statistical standards for data analysis, mapping and reporting, and complies with the conditions set out in all data licences
Retrieves, organizes, analyzes, interprets and reports data using appropriate methods to support timely surveillance and reporting on health status and diseases, in consultation with managers, epidemiologists, and other users
Writes and executes computer programs for data extraction, data set creation and analysis using spreadsheets and statistical software packages (e.g., Excel, Access, SAS, STATA, R)
Develops, uses, and archives standard syntax files for routine analyses
Prepares and disseminates health status information in various forms including reports, charts, graphs, maps and community health profiles based on analysis of existing or generated data for internal and external users
Applies proven analytical approaches to identify errors or limitations in data, and implements processes and to improve data validity
Defines data needs and selects methods and procedures for collecting and analyzing health data for managers, staff and others
Orients staff to available databases and the use of population health information in program development, monitoring and evaluation
Responds to enquiries regarding health status data and related information systems
Liaises with City departments and external agencies to obtain and/or share health related data
Provides in-service training to divisional staff in health information related to health status and diseases, socio-demographics and related computer programs
Designs data collection and survey instruments including coding formats, questionnaire design and data entry and storage
Provides on-the-job instruction to staff concerning the input, or preparation for input, of data
Assists with epidemiological studies and surveys related to disease surveillance and population health assessment. Provides support and consultation to divisional programs and services
Represents the division on internal and external committees dealing with population health assessment, disease data and health status information.
Requirements
University degree in Health Sciences, Biostatistics, or a related discipline, i.e. Biological Sciences, Mathematics
Considerable experience using statistical software to conduct analyses of large health data sets, including SAS, STATA, R or equivalent.
Considerable experience applying population health statistical methods and in the collection, analysis, communication, and interpretation of disease data OR population health assessment
Experience using data visualization tools e.g. Tableau
Strong customer service, communication, and consulting skills
Familiarity with current public health issues, epidemiological concepts, trend analysis and forecasting techniques
Ability to communicate effectively, to prepare written reports, and to display statistical data in appropriate and understandable formats
Ability to work effectively with staff at all levels of the organization
Knowledge of database design and development
Knowledge of Word, Excel, PowerPoint, Access and other software packages relevant to the analysis and presentation of population health
Excellent organizational skills with the ability to meet changing priorities
Ability to work in a high-pressure environment, take initiative and respond to competing priorities
Ability to work flexible hours (i.e. occasional evenings and weekends) when necessary.