Harvard University HR Data Analyst III in Cambridge, Massachusetts

45728BRAuto req ID:45728BRJob Code:H0357P HR Data Analyst III Location:USA - MA - Cambridge Business Title:HR Data and Reporting AnalystSub-Unit:Harvard Human Resources Salary Grade:057Time Status:Full-time Union:00 - Non Union, Exempt or Temporary Additional Qualifications:• Proficient in MS Office products, in particular advanced Excel skills such as pivot tables, vLookup and graphs.• Experience with SQL, QlikView, R, Python a plus.• Strong oral and written communication skills. Department:Analytics & ReportingPre-Employment Screening:Education, IdentitySchedule:The standard business hours are Monday - Friday, 9-5pm.Job Function:Human Resources School/Unit:University Administration EEO Statement:We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.Job Summary:Collect, analyze, and disseminate data for a host of business subject areas within Human Resources. Provide support on various analyses and reporting services that include: conducting complex statistical and quantitative analyses and presenting data in written reports, oral presentations and graphical displays.Typical Core Duties:Interview business owners to understand business problem, document solution and timelineWrite programs to analyze data in a complex data environment and advance cross-functional workforce planning projects thru project management and consultative servicesDesign and evaluate test data and generate reports and tables of statistical results using a variety of tools (query and database)Define system requirements, conduct gap analysis and identify alternative solutions that meet project development standards as well as project milestones and deadlinesResearch, develop and analyze metrics for human resource projects and programs such as; workforce planning, compensation assignments, benefits, payroll and program utilization, employee demographics and turnover trendsMember of cross-organizational end-user support team responsible for maintaining production systems including developing processes for triaging and addressing production support issuesMay conduct regression analyses of salary data to provide expected salary ranges of employees for new hire offers, equity reviews, or reclassification requestsEnsure compliance with University Human Resources policies, procedures, and requirements and applicable legal regulationsBasic Qualifications:Bachelor’s degree or equivalent work experience requiredMinimum of 5 years’ relevant work experienceWorking Conditions:Work is performed in an office settingJob-Specific Responsibilities:The team’s mission is to deliver workforce information to leaders responsible for strategy and decision making, to develop relevant practices and procedures for preparing business reports, ad hoc analysis related to patterns and trends, to educate users on the meaning and use of HR workforce information and to expand our existing portfolio of Analytic Data Discovery self-service QlikView business applications. Imagine yourself as a Workforce Data Analyst at Harvard where your natural curiosity about data gives you the opportunity to use your strong analytical and communication skills, and excellent interpersonal skills. She/he will support a variety of operations including, but not limited to gathering business requirements, be the primary contact to the community on how to answer business questions using data, troubleshoot problems, quality assurance of data and applications, project support, data access administration, data dictionary and other duties as required within HHR (e.g., QlikView HR Analytics, Operational applications and SQL) for a host of business subject areas. Those areas include Human Resources Compensation, Benefits, Recruitment Management, Position Management and Training to support operational and strategic requests of the central administration Human Resources Office. The Analyst will report to the Associate Director of HR Analytics and Reporting.