Data Quality Analyst

Johns Hopkins University5 months ago
Baltimore, MD, United States
On-site
Full-time
Junior Level (1-3 years)

Job Description

Job Description

The Data Quality Analyst will review and analyze data. The Data Quality Analyst will create reports, dashboards, and presentations for stakeholders and/or leadership and utilize findings to aid in decision‑making.

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.

Specific Duties & Responsibilities:

  • Collect and analyze quantitative and qualitative data in accordance with applicable privacy laws such as FERPA/HIPAA.
  • Communicate findings compellingly and visually through dashboards, reports, briefing decks, stories, scorecards, executive briefings, etc. For different audiences using solutions like Power BI and Tableau. Proofread and edit reports and other products to attain consistency of format.
  • Regular outreach to offices to learn about upcoming surveys scheduled; maintain up to date documentation.
  • Assist with the development of a detailed communication strategy and plan for the office/assigned area.
  • Maintain office website and produce materials in coordination with the divisional communications team.
  • Other duties as assigned.

Additional Responsibilities:

  • Oversee compliance of data flows into the advancement CRM against data quality standards.
  • Observe patterns in data discrepancies from technical system errors or requests from business offices 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.
  • Use various software applications and databases to assemble, manipulate and/or format data and/or reports for mass data loads or revisions in the system.
  • Maintain and build data quality dashboards in CRM to meet business needs of DAR.

Minimum Qualifications

  • Bachelor's degree.
  • Three years of related experience.
  • Additional education may substitute for required experience and additional related experience may substitute for required education permitted by the JHU equivalency formula beyond a high school diploma/graduation equivalent.

Preferred Qualifications

  • Experience using software for data analysis (Tableau, Power BI, Excel).
  • Experience working in a CRM database (Salesforce preferred).
  • Experience with querying languages such as SQL, SOQL, and/or DMX.

Classified Title: Data Analyst

Job Posting Title (Working Title): Data Quality Analyst, Office of Advancement Services

Role/Level/Range: ATP/03/PB

Starting Salary Range: Minimum: $46,200 - Maximum: $80,799 (targeted salary: $62,000-$68,000; commensurate with experience)

Employee group: Full Time

Schedule: Monday-Friday, 8:30am-5:00pm

FLSA Status: Exempt

Location: JH at Keswick

Department name: 10001639-Data Administration

Personnel area: University Administration

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.

Required Skills

DMX
Data Analysis
Excel
SQL
Dashboard Creation
Power BI
Tableau
SOQL
Salesforce
Data Reporting
Stakeholder Communication