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’ 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, BLocal and other initiatives of the Office of Economic Development. 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. The Office of Economic Development conducts a wide variety of community facing and economic impact work. The analyst will formulate and execute a data collection and analysis framework to ensure that there is accurate reporting of the social and economic impact of the work of the Office of Economic Development.

With respect to HopkinsLocal and BLocal, the data analyst will perform the following duties and functions. Hire: 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. Buy: 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. BUILD: The analyst will work with our Real Estate, Facilities, and Design and Construction teams to ensure maintenance and accurate data reporting for prime contractors and subcontractors for Real Estate and Facilities leaders. Invest: The analyst will work with our Treasury, Accounting, and Investment teams to ensure accurate data reporting of our treasury and investment portfolios. Professional Services: The analyst will work with our IT, Legal, Auditing, and other professional services teams to devise a data reporting framework to ensure accurate reporting. 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, recommend and advocate for 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
• Track outcomes – including revenue growth and net new job creation of the BLocal BUILD College participants
• Develop system to track the growth of small businesses as a result of HopkinsLocal, i.e. increased revenue and net new job creation.
• Develop system to track the economic and social impact of the work of the Office of Economic Development and other collaborating departments on community initiatives
• Assess and report upon HopkinsLocal in comparison to other institutions, noting best-practices when applicable
• 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
• 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

Minimum Qualifications:

• Bachelor's degree required. Degree in Economics, Public Administration, Business, Math, Applied Economics, Public Policy, Political Science or related field 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.

Preferred qualifications:

• 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 provide appropriate counsel and work in partnership with management and staff on human resources, purchasing or design and construction issues.
• Must be able to interact effectively with all levels of management and employees.
• Must possess strong organizational skills.

Classified Title:Economic Inclusion Data Analyst
Working Title: Economic Inclusion Data Analyst
Role/Level/Range: ATP/04/PD
Starting Salary Range:
Employee group: Full Time
Schedule: M-F 8:30 AM - 5:00 PM
Exempt Status: Exempt
Location: 03-MD:Eastern High Campus
Department name: 10000004-Economic Development
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 atjhurecruitment@jhu.edu. 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
Learn more:
https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf