Job Description

Job Description Summary:
Under guidance from a faculty biostatistician, bioinformatician, data scientist or director of research information technology; carry out data cleaning, database queries, and custom report generation; perform intermediate-level statistical analysis and report generation of various data types that arise; participate in project meetings with collaborators; train employees on the use of BI applications; and assist with the preparation of written reports, manuscripts, and grant applications with investigators with moderate supervision of a Biostatistics & Data Science member. The data manager will also play a key role with Environmental influences on Child Health Outcomes (ECHO) Institutional Development and Data Coordinating Center (ISPCTN DCOC) in ensuring high-quality data management across multi-site clinical research studies. This position will serve as the primary point of contact between the DCOC and the participating ISPCTN sites for all data-related activities.
Job Description:
Job Description Summary

Under guidance from a faculty biostatistician, bioinformatician, data scientist or director of research information technology; carry out data cleaning, database queries, and custom report generation; perform intermediate-level statistical analysis and report generation of various data types that arise; participate in project meetings with collaborators; train employees on the use of BI applications; and assist with the preparation of written reports, manuscripts, and grant applications with investigators with moderate supervision of a Biostatistics & Data Science member. The data manager will also play a key role with Environmental influences on Child Health Outcomes (ECHO) Institutional Development and Data Coordinating Center (ISPCTN DCOC) in ensuring high-quality data management across multi-site clinical research studies. This position will serve as the primary point of contact between the DCOC and the participating ISPCTN sites for all data-related activities.

Job Responsibilities:

Serve as the primary data management liaison with participating clinical sites.

Respond to site inquiries and provide timely resolution for data-related issues, including electronic data capture (EDC) access, data entry, and query management.

Lead the development and maintenance of study-specific data dictionaries and case report forms (CRFs), ensuring alignment with protocol requirements and standardized data elements.

Coordinate with stakeholders to incorporate feedback and maintain consistency across studies.

Develop and maintain SOPs and workflows related to data management, EDC use, and site communication.

Ensure SOPs are current, aligned with best practices, and effectively implemented across the consortium.

With moderate supervision, develop specific custom reports using Oracle, Tableau, SAS, or Shiny R.

Create electronic case report forms (eCRFs).

Participate in internal quality assurance efforts for form development, system performance monitoring, and report testing.

Develops or "codes" BI Applications to enhance business decision-making capabilities, primarily using Tableau or R.

Analyze existing databases, reports, and processes for opportunities to automate further or simplify utilizing BI tools.

Analyze data within various databases (Oracle, SQL Server, etc.) utilizing various SQL-based tools, BI tools, and Reporting Tools to inform business decisions.

Develop and maintain procedures for deploying R shiny projects as needed.

Write database documentation, including data standards, procedures, and definitions for the data dictionary ('metadata').

Train pertinent staff and other end-users as needed on BI Applications; and trains other BI Specialists on various BI Tools, including Tableau.

Troubleshoot user issues with the BI Applications.

Responsible for reviewing and maintaining Standard Operating Procedures and the change control documents.

Attend project meetings with collaborators, with a Biostatistics & Data Science faculty member.

Prepare reports, manuscripts, and grant applications for investigators with moderate supervision of Biostatistics & Data Science member.

Work Environment

Work is normally performed in a typical interior work environment, which does not usually subject the employee to any unpleasant elements.

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. It is only a summary of the typical functions of the job, not an exhaustive list of all possible job responsibilities, tasks, duties, and assignments. Furthermore, job duties, responsibilities and activities may change at any time with or without notice.

Required Qualifications

Education:

Bachelor’s Degree in Computer Science, Information Technology or related field. Experience may be substituted for education on a year-for-year basis. Certifications/Licenses: n/a

Work Experience:

3 years of experience with: PL/SQL, SQL functions, triggers, complex queries, SQL reports.

Experience in relational databases such as Oracle, MySQL, SQL Server, and Business Intelligence tools.

Experience with database migration, database development, database maintenance performance tuning and optimization, and setting up and managing database connections.

Experience in automation of ETL process between databases.

Experience in one of these: R, SAS or Python.

Experience working in a Windows and LINUX/UNIX environment.

Experience with troubleshooting data-related issues using logical problem-solving methods and process of elimination.

Experience with Microsoft Office products or equivalent.

Languages: n/a

Preferred Qualifications

Education: Masters degree in a similar field of study. Experience may be substituted for education on a year for year basis.

Certifications/Licenses:

Work Experience:

2 years of experience in academic or private health-related research environments.

Experience in creating, conducting training and documenting Metadata such as data dictionaries that are utilized for research.

Languages: n/a

Skills

Superior analytical skills

Proficiency in one of these: R, SAS or Python.

Proficiency with Microsoft Office products or equivalent.

Customer service skills.

Communication skills (written and verbal) and be able to work with a wide variety of faculty and staff

Attention to detail and thoroughness in completing work tasks