1. Support and/or lead the implementation of processes and projects that help ensure fair and reasonable compensation for faculty across YSM; support endeavors aimed at improving clarity and transparency in compensation setting and communications with faculty. 2. Evaluates and analyzes salary and benefit data for YSM faculty. Interprets compensation and benefit plan documents and applies plan principles to compensation practices and benefit plan administration. 3. Assists in the administration of YSM faculty compensation programs, including the annual merit review process. 4. Provide YSM and departmental leadership with customized, usable benchmarking evaluations of YSM faculty compensation against published benchmark statistics and supplemental reports and analytics to inform and influence compensation setting practices. 5. Work with YSM faculty, school leadership, and departmental staff to develop a comprehensive understanding of data and business needs. Develop and clearly present reports and analyses that help answer questions and guide decision making. 6. Conduct research on various topics, including but not limited to compensation and benefit plan designs and programs and trends in academic medicine (e.g., faculty diversity). Clearly summarize and present findings and formulate recommendations. 7. Utilize technical expertise, including an understanding of relational databases and the use of a variety of query and data retrieval tools, to extract, combine, manage and present data. Join data from disparate data sets in support of the goal of creating faculty centric reports and analyses that are holistic and span across mission areas (teaching, research, and patient care). 8. On-going data management that promotes effective and efficient preparation of monthly, quarterly and annual standard reports. Design and development of custom and ad hoc reports that are clear, well-organized, and help users answer questions. 9. Support data preparation for annual surveys and compensation related analyses. Work collaboratively with department business offices to collect and validate academic data, with an emphasis on data relevance and integrity. 10. Identify process inefficiencies and make recommendations for improvements which serve to streamline processes and enhance and optimize productivity. 11. Develop an understanding of the academic organizational structure and related data, including demographics, compensation, clinical measures, grant and contract information, and research space. 12. Perform other projects as required.
Preferred Education: MBA. Faculty compensation experience a plus. Experience with Workday.
Preferred Education, Experience and Skills: MBA. Faculty compensation experience a plus. Experience with Workday.
Required Skill/ability 5: Strong aptitude for systems and technical solutions; willingness to learn new systems and software applications. Proficiency in the use of MS Excel, MS Access and other query tools. Ability to perform lookups, parse and combine data, format worksheets, work with pivots, charts, graphs; create and use macros; understand VBA and other advanced Excel skills.
Posting Position Title: Business Analyst, Academic Analytics
Required Skill/ability 3: Ability to work independently, prioritize multiple projects and perform well under deadlines in a fast-paced environment. Project management skills; ability to engage project teams, keep tasks moving forward, and see projects through to completion.
Work Week: Standard (M-F equal number of hours per day)
University Job Title: Business Analyst, Academic Analytics
Required Skill/ability 1: Highly motivated and achievement oriented. Ability to be a proactive contributor who is detail-oriented, analytical, flexible, creative and has a high comfort level with ambiguity. Ability to work as a collaborative team player who values a feedback rich culture and transparency.
Required Skill/ability 4: Ability to analyze and interpret complex business data, processes and reporting. Strong understanding of relational databases and table relationships; ability to build large complex queries combining data from many sources.
Required Skill/ability 2: Effective communicator with strong interpersonal skills capable of working with faculty and staff at all levels across the organization. Excellent writing and presentation skills.
Bachelor's degree in a related field and four years of related experience or equivalent combination of education and experience.
Internal Number: 57756BR
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.