Research Data Analyst

Key Skills

Database, Git, Github, matplotlib, MySQL, Pivotal Tracker, PowerBI, Python Programming, SQL, Tableau, Web APIs

Job Description

The Bloomberg Center for Public Innovation at Johns Hopkins University (the Center) seeks a Research Data Analyst to join the Data & Insights team. The first of its kind in the world, the Center aims to advance the field of public sector innovation by marrying cutting-edge practice with world class research in order to transform the culture of government, deliver exceptional results for residents, and inspire trust in public service.

Data & Insights establishes and unites key performance indicators, generates internal and external intelligence, advances our relationship intelligence, and informs future practice. You will report to the Senior Advisor, Data and Insights. This position includes:

• Data-oriented research
• Data collection
• Cleaning, exploration, analysis
• Visualization to uncover insights
• Answer policy-related questions
• Innovate, creative solutions that help local governments solve problems that matter to leaders and residents
• You should have a strong understanding of Quantitative analysis methodologies
• Curiosity and commitment to unlocking the full potential of data for the public good

The Center is committed to addressing structural and entrenched racism and recognizes the public sector’s role in perpetuating these legacies. We are looking for candidates committed to dismantling structural and entrenched racism and addressing these issues, both as we build a new organization and advance this work in communities.

Specific duties and responsibilities:

• Identify and use public open data sources (like the U.S. Census) and other research data sources
• Clean and combine data from internal and external sources to tell a multifaceted story
• Visualize data to explore trends and relationships
• Collect insights from qualitative data, such as interviews, and combine it with quantitative data
• Create proxies for unattainable data (e.g. number of closed pothole complaints on 311 rather than actual potholes in a city)
• Help to produce new resources related to data governance and tool adoption including reports,tutorials, and guides to strengthen the Center's internal knowledge base
• Provide research and analytical support to Communications team and other practice areas
• Collaborate with other analysts, data scientists, researchers, policy experts, and other technical and non-technical partners
• Perform routine administrative tasks, including scheduling and document management
• Other duties as assigned

Special knowledge, skills, and abilities:

• Familiarity with ArcGIS Online and Operational Dashboard or QGIS
• Familiarity with public sector data, policies, and
• Familiarity with qualitative research methods and how to combine qualitative and quantitative data for analysis
• Familiarity with Salesforce
• Knowledge of open-source relational databases such as MySQL or PostgreSQL
• Knowledge of how to use SQL to access and modify relational databases
• Experience translating complex analytical findings into clear summaries for many different audiences
• Ability to work with, and understand, complex datasets - including protocols for optimizing data hygiene and working with sensitive data
• Ability to fill-in the holes of incomplete datasets with additional data and/or proxies for missing results
• Ability to self-initiate in a results-oriented workplace
• Desire to go beyond the immediate requested task and 'follow the data' wherever it leads
• Interest in learning new tools and skills necessary to perform the work
• Excellent oral, written, and research skills
• Excellent attention to detail and a systematic approach to problem solving
• Commitment to a collegial workplace

Minimum Qualifications

• Bachelor's degree in related discipline
• Three years related experience
• Additional education may substitute for required experience to the extent permitted by the JHU equivalency formula

Preferred Qualifications

• Bachelors' Degree in Mathematics, Statistics, Data Science, Computer Science, Engineering,Information Science, or related field
• Programming proficiency in Python for data cleaning and analysis. Familiarity with the MatplotlibPython library is preferred. Experience with a different programming language such as R will be considered.
• Proficiency in Microsoft Excel (including Pivot tables)
• Proficiency in Google Suite (including Sheets, Docs, Slides)
• Experience collecting data and/or modifying data in databases via APIs
• Experience automating data pipelines
• Experience with entity relationship diagrams
• Experience with version control software (e.g. GitHub)
• Experience building and maintaining dashboards in PowerBI and Tableau Cloud
• Experience using project management and collaboration software such as Asana
• An understanding of quantitative and qualitative research methods

Classified Title: Research Data Analyst

Working Title: Research Data Analyst

Role/Level/Range: ACRP/04/MC 

Starting Salary Range: $46,560 - $64,100 - $81,650 annually (commensurate with experience)

Employee group: Full Time

Schedule: 37.5/5

Exempt Status: Exempt

Location: Homewood Campus (Hybrid)

Department name: ​​​​​​​Ctrs for Govt Excellence & Public Innova 

Personnel area: Academic and Business Centers

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.