Research Data Analyst
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 & 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, & Abilities
- Familiarity with ArcGIS Online and Operational Dashboard or QGIS.
- Familiarity with public sector data, policies.
- 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 Matplotlib Python 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
Role/Level/Range: ACRP/04/MC
Starting Salary Range: $47,500 - $83,300 Annually ($75,000 targeted; Commensurate with experience)
Employee group: Full Time
Schedule: Monday - Friday 9am-5:30pm
Exempt Status: Exempt
Location: Hybrid/Homewood Campus
Department name: Ctrs for Govt Excellence & Public Innova
Personnel area: Academic and Business Centers