Economic Inclusion Data Analyst
HopkinsLocal is a joint economic inclusion initiative between Johns Hopkins University and Johns Hopkins Health System to leverage Hopkins’ economic power to expand the participation of local and minority-owned businesses in construction opportunities; increase Hopkins’ hiring of city residents, with a focus on neighborhoods in need of job opportunities; and enhance economic growth, employment, and investment in Baltimore City through Hopkins’ purchasing activities. BLocal is a commitment of 28 Baltimore area companies, including Hopkins, to buy, build and hire in Baltimore City.
The Economic Inclusion (EI) Data Analyst works to create systems and analyze data to support both HopkinsLocal and BLocal. This includes creating monthly, quarterly and annual reports summarizing progress in all of these areas. This resource assists functional, university and other stakeholders to assess and document progress towards established goals.
- HopkinsLocal: The analyst will oversee data management of applicant flow/hiring statistics as well as retention/employee movement metrics and then generate standardized reports to monitor program effectiveness for Human Resource leaders. The analyst will also ensure maintenance of current and accurate data for participating companies in the PaymentWorks and SAP database of vendors for procurement leaders.
- Blocal: The analyst will also support data gathering and cleaning for the BLocal initiative.
In order to execute the objectives and responsibilities of this role, the analyst must possess excellent interpersonal and communication skills, experience in the field of data management, and a demonstrated capacity to refine processes and systems such as the establishment of a dynamic feedback loop between various divisions, leaders within those divisions and the Director of Economic Inclusion.
DUTIES & RESPONSIBILITIES
- Analyze and synthesize data and trends, using university systems, databases and standard software packages
- Conduct in-depth research and analysis on financial, organizational and budget issues
- Assist in developing presentation materials and memoranda in order to communicate context, findings and recommendations to senior leadership
- Work independently to manage multiple tasks/assignments simultaneously
- Evaluate and analyze data to suggest policies and processes that improve HopkinsLocal outcomes
- Review submitted data of companies engaged in the BLocal initiative (annual data submission) and develop templates to track impact against each company’s baseline
- Work with the BUILD team to track and report retrospective BLocal BUILD College information to document program impact
- Develop systems to track the growth of small businesses as a result of HopkinsLocal and BLocal, i.e. increased revenue and net new job creation
- Assess and report upon HopkinsLocal in comparison to other institutions, noting best-practices when applicable
- With subject matter experts (SMEs) develop and maintain metrics for, and monitor performance of human resources, purchasing and design and construction groups
- Gather and track relevant internal and external statistics related to the development of a successful candidate pipeline for identified positions
- With SMEs develop appropriate outcomes reporting to share results of the EI initiative with leadership and other interested parties, developing slide decks, charts and graphs
- Work regularly with automated application tracking and/or HRIS or Success Factors systems
- Develop responsive dashboards and other infographics to inform leadership decisions
- Communicate professionally with a variety of stakeholders
- Participate on JHU and JHHS committees, as assigned
- Perform other related tasks and duties as assigned or required
- Bachelor's degree required. Degree in Economics, Public Administration, Business, Math, Applied Economics, Public Policy, Political Science or related field strongly preferred
- Three years of data management, analysis or other related experience required
- Additional education (Master's level) may substitute for required experience, to the extent permitted by the JHU equivalency formula
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.
- Master’s Degree in a related field is preferred
Special Knowledge, Skills, or Abilities/Competences.
- Advanced experience with Microsoft Excel, including the ability to create and manipulate large datasets through pivot tables and other data manipulation tools
- Experience working with diverse datasets, including protocols for optimizing data hygiene and working with sensitive data
- Knowledge of best practices in data presentation
- Experience creating graphs and Microsoft PowerPoint decks
- Ability to create data visualizations in D3.js, RStudio and/or Tableau
- Must be proficient working with Microsoft Word applications and flexible in learning new software applications (e.g. Success Factors, SAP and Payment Works)
- Requires a high level of analytical and critical thinking skills, including the ability to generate organized reporting tools and statistics
- Requires the ability to work independently, to assess situations and respond appropriate
- Requires a willingness to accept change and demonstrate flexibility
- Ability to work in partnership with management and staff on human resources, purchasing or design and construction data management issues
- Must be able to interact effectively with all levels of management and employees
- Must possess strong organizational skills
Starting Salary Range: $43,101 to $59,000 per year
Employee group: Full Time
Schedule: M-F, 8:30 am - 5:00 pm
Exempt Status: Exempt
Location: 45-MD:JH at Keswick
Department name: 60001052-Strategic Initiatives
Personnel area: University Administration
The successful candidate(s) for this position will be subject to a pre-employment background check.
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 HR Business Services Office at email@example.com. For TTY users, call via Maryland Relay or dial 711.
The following additional provisions may apply depending on which campus you will work. Your recruiter will advise accordingly.
During the Influenza ("the flu") season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.
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.
Equal Opportunity Employer
Note: Job Postings are updated daily and remain online until filled.
EEO is the Law
Important legal information
JH at Keswick