1. Creates a relational database from existing study data currently stored in multiple data sources. Designs comprehensive and relational databases with advance knowledge of relevant applications impacting on the data analyses and reporting. 2. Develops and documents operational procedures for the collection, editing, verification and management of study data. Documents all study data files, data structure and relationships, variable definitions and data codes. Writes detailed specifications for analysis files and performs consistency checks. 3. Develops and implements relevant statistical programs to incorporate data from multiple studies/projects. 4. Organizes and creates documents and tables related to datasets; communicates with data sources about data accuracy and data dictionary. 5. Evaluates and analyzes data using accepted statistical techniques and statistical analysis software. Performs descriptive and multivariate statistical analyses of data, using computer software. 6. Uses advanced statistical knowledge to provide support in managing and analyzing data. 7. Designs and implements quality control measures to ensure accurate collection and processing of data. Ensures the integrity of databases used in analyses through development of essential data cleaning and checks, and data back-ups. 8. Responsible for the documentation and transmission of study data. Ensures that data are collected and completed in a timely manner at each site location. 9. May perform other duties as assigned.
Preferred Education: Experience executing queries against relational databases. Experience or training in survey design; experience with Workday, Hyperion (Brioquery) and Tableau.
Preferred Education, Experience and Skills: Experience executing queries against relational databases. Experience or training in survey design; experience with Workday, Hyperion (Brioquery) and Tableau.
Required Skill/ability 5: Excellent collaborative interpersonal communication skills with ability to communicate technical information to non-technical audiences. Ability to work both independently and collaboratively, interacting with a diverse array of faculty, students and staff; exercises sound judgment, tact, and discretion. Proficiency with Microsoft Office products.
Posting Position Title: Data Analyst
Required Skill/ability 3: Expertise with popular database programming languages for relational and non-relational databases. Experience working with heterogeneous datasets to build, manage and integrate data pipelines. Expertise with scripting using languages such as R, Python, Java, C++, Scala, SQL, others.
Work Week: Standard (M-F equal number of hours per day)
University Job Title: Data Resource Analyst
Required Skill/ability 1: Proven ability to create large, complex data sets from disparate sources while managing data quality - both for statistical analysis and data management. Skilled with survey data a plus.
Required Skill/ability 4: Ability to develop, recommend and execute solutions to complex problems often under time constraints, handle multiple tasks/projects at the same time; complete projects successfully and on time. Ability to adapt to changes in work demands, priorities and procedures exercising good judgment, seeking alternatives and creative solutions.
Required Skill/ability 2: Statistical analysis skills including multiple regression. Demonstrated ability with statistical software, e.g. SAS, R, SPSS, STATA, or MATLAB.
Master's degree in statistics, computer science or a related field and two years of experience in data management and analysis or equivalent combination of education and experience. Experience with data collection and in coordinating efforts of multiple groups.
Internal Number: 58082BR
About Yale University
Yale University is an American private Ivy League research university located in New Haven, Connecticut. Founded in 1701 in the Colony of Connecticut, the university is the third-oldest institution of higher education in the United States.