Data Analyst

Data Analyst jobs at

Data Analyst

The Baltimore Education Research Consortium (BERC) is a research-practice partnership between Maryland institutions of higher education and child, youth and family serving partners that is administratively housed within the Johns Hopkins University, School of Education. BERC`s mission is to conduct and disseminate long- and short-term strategic data analysis and research that informs decisions about policy and practice to improve the educational and life outcomes of children in Baltimore.

BERC is a small, highly focused team that works independently and collectively to problem-solve and find innovative solutions to challenges in a fast-paced, deadline-oriented environment to achieve its mission. We are looking for a new remote team member to join us as a Data Analyst who will play a lead role in the ongoing development of BERC`s data operations, integrating diverse datasets from a broad range of child and family-centered agencies and programs within Baltimore.

The successful applicant will be an inquisitive self-starter, have excellent attention to detail, be effective and comfortable with communicating technical matters across a broad range of partners and researchers. An ideal candidate will be willing to wade into complex and sometimes not clearly defined datasets and identify problem-solving strategies. Applicants should be proficient in the R programming language, SQL server, and have the ability to learn new technologies as needed.

This position reports to the managing director of BERC. Review of applications will begin immediately. The position will remain open until filled.

Specific Duties & Responsibilities:
Data Discovery
Work with partners to understand potential data sources
Find and understand potentially relevant open or public data sources
Data ETL
Import raw data from variety of sources and file formats
Write scripts to find data errors or inconsistencies
Conduct probabilistic record linkage
Work with data providers to ensure data quality
SQL Server Database Creation and Management
Design tables
Create indices and key field relationships
Create functions and stored procedures for common tasks
Work with DBA to organize permissions for views and tables
Summary information for documentation purposes
Ad-hoc data exploration using SQL, R, and other frameworks.
Queries to provide researchers with data extracts or to re-shape data for certain types of statistical analysis


Minimum Qualifications (Mandatory):
Bachelor`s degree
Three years of experience
Additional education (Master`s level) may substitute for required experience, to the extent permitted by the JHU equivalency formula.

Preferred Qualifications:
Fluency with multiple data management tools and programming languages:
R programming language, especially packages in the tidyverse such as dplyr
SQL Server relational database
Manipulation of structured data / ETL processes
Some knowledge of Python
Comfort with notebook-style programming documentation, using tools like R Markdown and Jupyter Notebooks.

Special Knowledge, Skills & Abilities:
Describe data sets as we receive them from agencies. In some cases, the data provider will already have a useable data dictionary, but sometimes these will need to be created.
Document areas of concern in data sets, such as missing/inconsistent data, that could pose a problem for researchers attempting to use the data.
Document source data changes (differences in methodology) over time (i.e., explain adding / dropping fields from an otherwise stable dataset over time).
Provide technical assistance to researchers who will be using the data.

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 the 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.

Classified Title: Data Analyst
Role/Level/Range: ATP/03/PB
Starting Salary Range: $43,530 - $ 59,795 annually (commensurate with experience)
Employee group: Full Time
Schedule: 37.5/ Monday - Friday
Exempt Status: Exempt
Location: Homewood Campus
Department name: Baltimore Education Research Consortium
Personnel area: School of Education

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 protected] . 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:


Published 2021-11-25

Johns Hopkins University looks for a Data Analyst in Baltimore, MD 21218 location.

How much Data Analyst Jobs professional earns at Johns Hopkins University?

The proposed salary for Data Analyst Jobs position at Johns Hopkins University is $43,530 - $59,795 a year.

Data Analyst responsibilities at Johns Hopkins University

According to the common industry standard, Data Analyst Jobs specialist is in charge for the following activities.

Required Data Analyst Jobs qualifications at Johns Hopkins University

To be disscussed with candidate