Data Analyst

Company: The Johns Hopkins University
Location: Baltimore
Posted on: May 22, 2025

Job Description:

Press Tab to Move to Skip to Content LinkJohns Hopkins strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine. The seasonal flu vaccine requirement remains unchanged. Exceptions may be provided under certain circumstances.Click here for more information. .Select how often (in days) to receive an alert: Create AlertDevelopment and Alumni Relations (DAR) supports Johns Hopkins' focus on research, teaching and patient care, and its role as a national and global leader in higher education. We create and foster enduring relationships that result in advocacy and philanthropic support for Johns Hopkins University & Medicine-strengthening the institution through partnerships with donors, alumni, volunteer leaders, faculty, students, staff, and patients.Johns Hopkins University supports a flexible work model which includes four different work modalities. This role has a modified hybrid work arrangement with an onsite presence of 2 days per week. The manager will confirm the team's core onsite days where the majority/all team members will work in the office. Employees who travel on university business can count those days towards their onsite days.Reporting to the Associate Director of Data Quality, the Data Quality Analyst performs a variety of data processing, review, and maintenance activity to support development efforts for the Johns Hopkins Institutions. Additionally, the data quality analyst researches and reports on the status of critical data related to institutional donors and other constituents, and completes tasks related to development data quality initiatives.Key responsibilities:Mass Data Processing Activities (30%):

• Oversees compliance of data flows against data quality standards.
• Evaluates incoming constituent biographic and demographic data against existing system data and manually merges data onto existing constituent records if determined to be a match or creates a new constituent record to store data if new to database.
• Resolves data discrepancies on incoming data to maintain quality and validity.
• Observes trends in imported data discrepancies or technical system errors and flags for supervisor review and possible refinement of source data and integration algorithms.
• Monitors various data sources and reports to prioritize and expedite incorporation into the database.
• Conducts mass data loads by reformatting customer provided data to match database structure.
• Documents and reports to the Associate Director on status of data processing projects/goals.Data Quality Maintenance (30%):
  • Initiates and responds to inquiries (oral and written) from divisional staff, business offices, and other institutional parties regarding biographic and demographic data edits, additions, and deletions.
  • Observes patterns in requests from divisional staff, business offices, and other institutional parties and alerts manager and/or suggests root cause analyses, customer communications, ticket request forms adjustments, and any other changes to streamline meeting the business needs.
  • Creates and maintains biographical, contact, employment/organizational relationship data for constituents, as well as other supporting data through filing, retrieval, retention, storage, compilation, coding, updating, and purging.
  • Completes any activity required to support the development data quality goals and initiatives.
  • Maintain reports that detail progress of targeted maintenance activities and projects.Measurement and Analysis (25%):
    • Monitors reports and metrics of established data quality and customer data requests and reports on status to supervisor.
    • Observes trends in data and make recommendations to Associate Director, Data Quality.
    • Creates reports as needed to analyze scope of observed data quality issues.
    • Maintains and builds data quality dashboards in CRM to meet business needs of DAR.
    • Uses various software applications and databases to assemble, manipulate and/or format data and/or reports.Knowledge Management (10%):
      • Aids in developing policy and procedure documentation for various data quality operations.
      • Creates templates for customers to provide data updates to streamline system import.
      • Refines customer facing webpages and request forms within DAR to support awareness of data quality efforts and streamline addressing of data quality concerns.Additional Position Requirements (5%):
        • Supervises staff and/or operations (work delegation/assignment) in manager's absence.
        • Acts as user acceptance test participant in the enhancement of Development software products.
        • Assists immediate supervisor in cross-training and new employee orientation within the area.
        • Other duties as assigned.Development and Alumni Relations (DAR) supports Johns Hopkins' focus on research, teaching and patient care, and its role as a national and global leader in higher education. We create and foster enduring relationships that result in advocacy and philanthropic support for Johns Hopkins University & Medicine-strengthening the institution through partnerships with donors, alumni, volunteer leaders, faculty, students, staff, and patients.Johns Hopkins University supports a flexible work model which includes four different work modalities. This role has a modified hybrid work arrangement with an onsite presence of 2 days per week. The manager will confirm the team's core onsite days where the majority/all team members will work in the office. Employees who travel on university business can count those days towards their onsite days.Reporting to the Associate Director of Data Quality, the Data Quality Analyst performs a variety of data processing, review, and maintenance activity to support development efforts for the Johns Hopkins Institutions. Additionally, the data quality analyst researches and reports on the status of critical data related to institutional donors and other constituents, and completes tasks related to development data quality initiatives.Key responsibilities:Mass Data Processing Activities (30%):
          • Oversees compliance of data flows against data quality standards.
          • Evaluates incoming constituent biographic and demographic data against existing system data and manually merges data onto existing constituent records if determined to be a match or creates a new constituent record to store data if new to database.
          • Resolves data discrepancies on incoming data to maintain quality and validity.
          • Observes trends in imported data discrepancies or technical system errors and flags for supervisor review and possible refinement of source data and integration algorithms.
          • Monitors various data sources and reports to prioritize and expedite incorporation into the database.
          • Conducts mass data loads by reformatting customer provided data to match database structure.
          • Documents and reports to the Associate Director on status of data processing projects/goals.Data Quality Maintenance (30%):
            • Initiates and responds to inquiries (oral and written) from divisional staff, business offices, and other institutional parties regarding biographic and demographic data edits, additions, and deletions.
            • Observes patterns in requests from divisional staff, business offices, and other institutional parties and alerts manager and/or suggests root cause analyses, customer communications, ticket request forms adjustments, and any other changes to streamline meeting the business needs.
            • Creates and maintains biographical, contact, employment/organizational relationship data for constituents, as well as other supporting data through filing, retrieval, retention, storage, compilation, coding, updating, and purging.
            • Completes any activity required to support the development data quality goals and initiatives.
            • Maintain reports that detail progress of targeted maintenance activities and projects.Measurement and Analysis (25%):
              • Monitors reports and metrics of established data quality and customer data requests and reports on status to supervisor.
              • Observes trends in data and make recommendations to Associate Director, Data Quality.
              • Creates reports as needed to analyze scope of observed data quality issues.
              • Maintains and builds data quality dashboards in CRM to meet business needs of DAR.
              • Uses various software applications and databases to assemble, manipulate and/or format data and/or reports.Knowledge Management (10%):
                • Aids in developing policy and procedure documentation for various data quality operations.
                • Creates templates for customers to provide data updates to streamline system import.
                • Refines customer facing webpages and request forms within DAR to support awareness of data quality efforts and streamline addressing of data quality concerns.Additional Position Requirements (5%):
                  • Supervises staff and/or operations (work delegation/assignment) in manager's absence.
                  • Acts as user acceptance test participant in the enhancement of Development software products.
                  • Assists immediate supervisor in cross-training and new employee orientation within the area.
                  • Other duties as assigned.
                    
                    Minimum Qualifications
                    
                    • Bachelor's degree.
                    • Three years of related experience.
                    • Additional education may substitute for experience to the extent permitted by the JHU equivalency formula.
                      
                      Preferred Qualifications
                      
                      • One year of experience preferred in collecting and analyzing data, preparing reports, identifying and solving problems.
                      • Proficiency in the Microsoft Office Suite (including Word, Excel).
                      • Knowledge of database structures and ability to use multiple information systems and software.
                      • Experience working in a CRM database (Salesforce preferred).
                      • Familiarity with SOQL.
                      • Strong oral and written communication skills.
                      • Demonstrated analytic, planning, and organizational skills.
                      • Attention to detail and ability to manage multiple projects or responsibilities.
                      • Ability to transform raw data into meaningful information for business and analysis purposes.
                      • Ability to work with limited supervision and make decisions within established procedures.Classified Title: Data Analyst
                        Job Posting Title (Working Title):Data Analyst
                        Role/Level/Range: ATP/03/PB
                        Starting Salary Range: Minimum: $46,200 - Maximum: $80,799 (targeted salary: $65,000; commensurate with experience)
                        Employee group: Full Time
                        Schedule: Monday-Friday, 8:30-5:00pm
                        FLSA Status:Exempt
                        Location:JH at Keswick
                        Department name: 10001639-Data Administration
                        Personnel area: University AdministrationTotal Rewards
                        The referenced base salary range represents the low and high end of Johns Hopkins University's salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which may include the successful candidate's geographic location, skills, work experience, market conditions, education/training and other qualifications. 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/ .Education and Experience Equivalency
                        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 Completing Studies
                        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.Background Checks
                        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.Diversity and Inclusion
                        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.Accommodation Information
                        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 Talent Acquisition Office at jhurecruitment@jhu.edu . For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit https://accessibility.jhu.edu/ .Vaccine Requirements
                        Johns Hopkins University strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine.The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine . Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry.This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/ .The following additional provisions may apply, depending upon campus. Your recruiter will advise accordingly.
                        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.
                        #J-18808-Ljbffr

Keywords: The Johns Hopkins University, Wheaton-Glenmont , Data Analyst, Professions , Baltimore, Maryland