This newly created position is the foundation of all data collection and program evaluation for central Human Resources (HR), overseeing the collection of highly confidential data for validation, analysis, visualization, and interpretation of activity. We are seeking a Sr. Data Analyst who will be responsible for the design, implementation, integration and accessibility of information that enables effective and reliable data analytics. This role will lead the development and delivery of reports and other analytical solutions that support the central HR strategy, team, and university leadership.

The Sr. Data Analyst provides high level data analysis to inform strategic planning and analyze the effectiveness of initiatives through data-driven research. The position reviews and understand large sets of historical data while being able to highlight relevant trends and patterns to inform critical decision-making. Must be able to perform advanced data extraction and leverage data analytics expertise to identify/understand organizational needs and contribute to the formation and execution of strategy.

This role interacts with a breadth of clients on a university-wide basis, including senior leadership, lending guidance on data collection processes (which spans a variety of collection systems and methods), and offers training and demonstrations of BI tools to end users. The position generates standing monthly, quarterly, and annual reports that provide a wide variety of feedback on programs, status, volume, trends, and projections.

Specific Duties & Responsibilities

• Develop and execute strategies to provide timely data and analyses concerning the strategic initiatives of the Central HR leadership team and critical programs.
• Create data analysis tools to be used by HR leaders, as well as automated delivery tools for the Central HR function.
• Manage Data projects that will support accurate and efficient management of existing databases within Central HR.
• Maintain uniformity in measurement without compromising specific program goals, to maximize the ability to make university-wide comparisons.
• Lead maintenance and enhancement of complex data systems used to track program usage containing confidential information.
• Communicate data findings in written, graphical, and oral forms.
• Lead improvements in data services, policies, and procedures to increase programs' effectiveness.
• Work with HR leadership to develop data ownership policies, procedures and best practices across all functional areas of HR.
• Maintain relevant databases, records and files.
• Perform data analysis and interpretation, utilize knowledge of statistics and quantitative analysis. Inform strategic planning from a data analysis perspective.
• Foster collaboration across departments/organization to ensure flow of data required for analysis and to identify new opportunities.
• Collaborate with IT@JH to ensure that reporting tools provide results that align with business rules. Act as subject matter expert and trainer as it pertains to HR master data reporting and analysis.
• Generate reports, charts, tables, and create presentations and present data at meetings and trainings upon request.

• Bachelor's Degree.
• Five year's experience.
• Additional education may substitute for experience to the extent permitted by the JHU equivalency formula.

• Experience in human resources in higher education.
• At least five years of experience working with an enterprise resource planning system (SAP, PeopleSoft, Oracle, etc.).
• Proficient in Microsoft Suite (including Word, Excel, and Power Point).
• Experience developing and automating report generation.
• Experience presenting key findings in a non-technical manner to clients.

Special Knowledge, Skills & Abilities

• Ability to plan and think strategically and possess excellent organizational skills.
  
• Ability to establish priorities, make independent decisions, and use independent judgment.
  
• Excellent attention to detail and the ability to plan and manage multiple tasks simultaneously, while achieving pre-determined milestones and completion deadlines.
  
• Ability to remain flexible and prioritize job duties independently.
  
• Must possess skills to convey complex ideas to non-technical audiences and have excellent interpersonal and communication skills to convey information to faculty, staff and University officials.
  
• Highly experienced with the following MS Excel functions: pivot tables, VLOOKUP function and data modeling.
  
• Experience with creating visualizations in Power BI and/or Tableau.
  
• Familiarity with querying databases.
  
• Knowledge of SQL, HTML, JavaScript, PHP, VB, Flash, and ASP or some subset of the technology.
  
• Advanced knowledge and demonstrated understanding of developing and tuning complex queries, stored procedures, and user-defined functions using T-SQL.
  
• Comprehensive knowledge of key analytics and reporting software, including SQL reporting tools, Microsoft Excel, and Tableau (or other data presentation software).
  
• Considerable experience with other software and workplace collaboration products, including Microsoft Office (Word, Outlook, SharePoint, Teams, and PowerPoint) and Zoom.
  
• Ability to work closely with staff in a supportive role.
  
• Ability to work closely with management to provide needed info for feedback loop.

Classified Title: Sr. Data Analyst 
Role/Level/Range: ATP/04/PD  
Starting Salary Range: Min $62,300 - Max $109,000 Annually (Targeted $80,000;Commensurate with experience) 
Employee group: Full Time 
Schedule: M-F/8:30-5:00 
Exempt Status: Exempt 
Location: Hybrid/Eastern High Campus 
Department name: ​​​​​​​VP of Human Resources  
Personnel area: University Administration 

Total Rewards
The referenced salary range is based on Johns Hopkins University's good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

**Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law
Learn more:
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

Accommodation Information

If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit accessibility.jhu.edu.

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.

The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.

Note: Job Postings are updated daily and remain online until filled.