The Data Analyst supports divisional efforts toward a data-driven environment. The Data Analyst is responsible for obtaining, validating, cleaning, and organizing data for the Academic Services Assessment and Analysis office, developing reports, and developing web-based, interactive tools to make information accessible to decision makers, with a special emphasis on undergraduate FLI (first generation/low income) student data. The Data Analyst is expected to provide technical support for associated reporting tools and resources, as well as work with a variety of applications to produce reliable, accurate, and dependable information.
Consults with colleagues to understand the information needs of Homewood Student Affairs staff and constituents and to implement solutions to meet those needs. Thinks creatively to ensure the best use of technology.
Works with IT to set up, maintain and document the hosting of student data on university servers.
Gathers, curates, and manages student data which is outside of the main student information system from various sources and offices; cleans and validates it using tools such as SAS, R, Python, Tableau Prep, or Veera Construct; uploads to university servers. Keeps documentation current.
Works with campus partners (Career Center, advisors, Center for Social Concern, and others) to help maintain a system for tracking internships, research experiences, volunteer experiences, and other so-called high impact experiences. Trains student affairs staff on the system.
Creates and/or maintains dashboards focused on FLI students for functional users such as advisors, to showcase academic metrics, involvement in high impact experiences, and other student engagement.
Assists with monthly reporting of FLI metrics.
Writes advanced programs/queries in response to data requests, using SAS, R, Python, SQL, or Veera Construct.
Supports research analyst and director by compiling data sets ready for analysis, as requested.
Bachelor's degree in information technology, a social science, or related field required.
Master's degree preferred. Additional education (Master's level) may substitute for required experience, to the extent permitted by the JHU equivalency formula.
Three years of experience directly related to job functions
Excellent oral, written, and interpersonal communication skills.
Strong analytical, conceptual, and problem-solving abilities.
Experience with statistical analysis.
Promotes responsive, customer-oriented service in job responsibilities, exhibiting a commitment to anticipating, understanding, and responding actively to customer needs.
Ability to independently analyze and resolve complex problems in a fast-paced environment with frequent interruptions.
Experience with data manipulation/cleaning using tools such as SAS, R, Python, Tableau Prep, or Veera Construct.
Experience with a general purpose programming language (Java, Python, etc.), with an ability to develop medium complexity scripts in the areas of data manipulation and web automation.
Strong understanding of relational database concepts such as data normalization and relationship types (one-to-many, many-to-many, etc.).
Data loading and ETL experience.
Some experience with database modeling and design.
Classified Title: Data Analyst Role/Level/Range: ATP/03/PB Starting Salary Range: Commensurate with Experience Employee group: Full Time Schedule: M-F, 8:30-5 Exempt Status: Exempt Location: 01-MD:Homewood Campus Department name: 60007228-Assessment and Analysis Personnel area: Homewood Student Affairs
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 firstname.lastname@example.org. 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.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.