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: Proven working experience as a data analyst or business data analyst. Technical experience regarding data modeling, database design and development, data mining and segmentation techniques. 2+ years' data mining experience. 4+ years' in a data analyst role.
Preferred Education, Experience and Skills: Proven working experience as a data analyst or business data analyst. Technical experience regarding data modeling, database design and development, data mining and segmentation techniques. 2+ years' data mining experience. 4+ years' in a data analyst role.
Required Skill/ability 5: Ability to work in diverse, cross-functional teams with limited guidance. Actively solicits differing opinions to ensure understanding of complex issues and acts in a manner that builds and maintains trust. Demonstrated ability to work independently to meet deadlines. Ability to build strong relationships with all business partners and suppliers.
Posting Position Title: Data Analyst
Required Skill/ability 3: Advanced skills in using the Microsoft Office suite, particularly Excel, Access, Word, Project, Outlook and PowerPoint. Working knowledge of ERP Systems and Procurement/Supply Chain Management-related software.
Work Week: Standard (M-F equal number of hours per day)
University Job Title: Spend and Savings Analyst
Required Skill/ability 1: Ability to analyze large data sets; ability to recognize patterns in data, information or events to draw logical conclusions and make recommendations. Demonstrated advanced analytical skills.
Required Skill/ability 4: Strong research, analytical and problem solving skills, including but not limited to quantitative and qualitative analysis of internal and external data to support the development and execution of business improvement strategies. Experience with data models and reporting packages. Good interpersonal and organization skills with strong attention to detail.
Required Skill/ability 2: Excellent oral and written communication skills with the ability to present information in a clear and concise manner and to write comprehensive reports.
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: 54498BR
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.