Data Analyst, Foundry

Reporting to the Research Manager, Foundry and providing support to the Evaluation Lead, Foundry, the Data Analyst works as part of a team, collaborating and providing support for research and evaluation for Foundry - a provincial initiative with the goal of providing youth and young adults with enhanced access to integrated services, thereby easing transition points for youth and their families. The Data Analyst will work in close collaboration with Foundry Central Office evaluators and researchers in the development, management and analysis of various datasets. The Data Analyst summarizes and collects data from multiple databases to develop and deliver datasets and analytical outputs; including understanding the project requirements, validating variables for errors and missing data, ensuring the integrity of data and writing codes and complex statistical macros to merge/ link data. This position will evaluate the data process, liaise with researchers, evaluators, and stakeholders, and make changes to the process and delivery of data as required.

**Skills**: Demonstrated high proficiency with SAS, R, Stata, and SPSS software.
Demonstrated ability to work with relational databases, large data sets and multiple data sources.
Demonstrated ability to work with large data sets and extrapolate conclusions from large data sets.
Demonstrated ability working with information systems and data files, including large and complex files: analysing file structure, transforming raw data into finished products.
Knowledge of data administration and management functions (collection, analysis, distribution etc.), with attention to security and confidentiality.
Knowledge of modern database and information system technologies.
Ability to validate and audit data.
Demonstrated proficiency in MS Office (Excel, Access, Power Point, Word etc.).
Demonstrated ability to work both independently, and collaboratively within a team environment.
Ability to self-motivate, with managerial, leadership and project management skills.
Excellent oral and written communication, organizational, multi-tasking and problem solving skills.

Ability to prioritize, plan, coordinate, and organize work under pressure and meet deadlines.
**Education**: Bachelor’s degree in a relevant field such as Computer Science, Epidemiology, Mathematics, Medical Health Information or an equivalent combination of education training and experience.
Undergraduate or graduate coursework in statistics, data analysis or research methods.
Three (3) to five (5) years’ recent related experience providing data management and analysis support, including supervising and managing large complex datasets.
Experience handling sensitive and confidential information, including client information, in a trusted and responsible manner, in adherence with organizational standards and relevant privacy legislation.
Experience working with population level data sets such as health (and/or other) administrative data sets considered an asset.
**Duties**: Prepares reduced datasets specific to the project by understanding project requirements, needs and restrictions, ensuring data is clean and accurate. Collects variables from multiple databases to create datasets.
Codes and develops relevant statistical macros (SAS, SPSS, Stata) to merge data and provide linkages from a variety of databases/ data sources.
Develops complex statistical macros and scripts, datasets and reports for internal stakeholders.

Contributes to the development of new datasets. Evaluates process and provides improvement in data delivery and presentation.
Engages with relevant staff members and stakeholders during the evaluation and research processes, to determine their data needs and advise on data structure, restriction and creation of the novel variables.
Works closely with data stewards and researchers/evaluators to understand data definitions and standards in order to support the development of accurate data access requests, data linkage processes, and the extraction of appropriate data for the defined analysis plan.
Monitors records in various databases. Reviews data by performing data validation, looking for missing variables, errors, communicates with relevant staff members/researchers and updates existing datasets as required. Confirms integrity of data before presenting findings.
Follows privacy and research ethics protocols (where applicable), maintaining confidentiality.
Ensures that the development and execution of data analysis plans comply with organizational standards and best practices, including any relevant data governance policies or agreements such as information sharing agreements.
Performs other related duties as required.