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 with Google Cloud Platform (BigQuery, Cloud SQL, Cloud Datastore, and Cloud Storage). Experience working with geospatial biodiversity data. Experience developing geospatial applications. Strong technical skills and relevant experience with Python and Shell scripting. Experience with hosted platforms such as Google App Engine and CARTO.
Preferred Education, Experience and Skills: Experience with Google Cloud Platform (BigQuery, Cloud SQL, Cloud Datastore, and Cloud Storage). Experience working with geospatial biodiversity data. Experience developing geospatial applications. Strong technical skills and relevant experience with Python and Shell scripting. Experience with hosted platforms such as Google App Engine and CARTO.
Posting Position Title: Data Analyst
Required Skill/ability 3: Demonstrated ability in conducting written and oral presentations that summarize the analysis of data, interprets the finding and provides conclusions and recommendations. Resourceful and able to solve problems in an organized and logical manner. Ability to function effectively independently and as part of a team with a professional demeanor.
Work Week: Standard (M-F equal number of hours per day)
University Job Title: Data Analyst
Required Skill/ability 1: Demonstrated success working with "big data" on the order of hundreds to billions of records. Understanding of entity relationship diagrams (ERD) and the inherited cardinality rules of schemas/tables. Demonstrated record of documentation through GitHub and workflow optimization. Basic proficiency in Unix-based systems.
Required Skill/ability 4: Ability to plan, organize and manage a large volume of varied work in a complex, fast-paced environment. Ability to multi-task, prioritize, and work under pressure to meet deadlines. Ability to concentrate and perform with interruptions. Excellent time management skills. Excellent attention to detail and accuracy.
Required Skill/ability 2: Ability to work in a collaborative environment, receiving and providing feedback on code. Capacity to incorporate user feedback directly into products. Excellent written and oral communication skills.
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: 54075BR
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.