Create Alert
Apply now »
Requisition ID:  118434

Contribution Data Analyst, Advancement Services

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 remote work arrangement with an onsite presence of two 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 Assistant Director, Data Administration/Major Gifts unit, the Contribution Data Reporting Analyst provides Data Administration and OAS partners with contribution data reporting and validation support, and a variety of development accounting and constituent maintenance activities related to the processing of gifts and pledges for the Johns Hopkins Institutions. This role is primarily responsible for developing, documenting, and maintaining contribution reports to ensure that contribution data is optimized for pipeline and organizational reporting. The Contribution Data Reporting Analyst will collaborate with staff members, business units, and partners to create, update, and support data sources, databases, related technologies, and reports in order to deliver products that support Data Administration contribution data reporting and validation.


Key responsibilities: 

Contribution Data Reporting and Validation Support (30%):

  • Production, distribution, and/or validation of various detailed and summary gift reports, surveys, and ad hoc financial reports with internal and external partners. Validate bimonthly cash receipt, progress, and campaign reports. Participate in the production of cyclical external reports and surveys such as the VSE, 990, Section 117, etc.
  • Various collectability management cycles (deletion and reconciliation of expired pledges). Assists in the validation of the development receivable balance for the Institutions and works with development staff to verify the accuracy of the information, and proposes modifications to processes.

Data Manipulation (40%):

  • Manipulate data from primary or secondary data sources to produce complex reports and data sets; streamline workflows to eliminate duplication of efforts and manual data manipulation.
  • Implement new business intelligence requirements using SQL, ETL (extract, transform, and load), business intelligence tools, and database programming and reporting tools.
  • Support routine audits and determine the root cause problems for data integrity and data quality issues identified through QA or by business report owners.

Visualization and Reporting (10%):

  • Compile, prepare, and distribute reports and data visualizations.
  • Support the development and implementation of Salesforce, Tableau, and Power BI data visualization solutions for staff members, business units, and partners across DAR.
  • Extract and translate data into interactive graphics, data visualizations, and dashboards using the appropriate tools.
  • In conjunction with team members, respond to ad-hoc query requests from OAS partners.

Project Management (10%):

  • Prepare documentation of all procedures used to ensure scalability and transparency.
  • Continuously evaluating departmental tools and resources.

Contribution Processing/other duties as assigned (10%):

  • Records, classifies, and summarizes accounting transactions.
  • Assembles documents for computer input, verifying and ascribing dates of credit, accuracy of account numbers and allocations, total cash received, and segregation of gift verses non-gift transactions.
  • Responsible for specialized transactions including gifts of securities, private grants, and deferred life-income gifts.
  • Verifies documents for completeness and compliance with government agencies (IRS) and Development accounting standards as defined by NACUBO and CASE.
  • Provides accounting services to Development staff and other related parties.
  • Checks accounting transactions to locate and resolve discrepancies.
  • Reconcile donors’ gift and pledge account activity and make appropriate adjustments.
  • Analyze and research donor giving histories as required.
  • Maintains gift, pledge, and supporting application data records through filing, retrieval, retention, storage, compilation, coding, updating, and purging.
  • Initiate and respond to inquiries (oral and written) from divisional staff, business offices, and other institutional parties regarding all constituent data.


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
  • Three (3) years related experience required, including at least one (1) year of experience developing and using business intelligence reporting and data visualization tools. Data visualization tools could include Power BI, Tableau, etc. Additional education may substitute for experience to the extent permitted by the JHU equivalency formula.
  • Demonstrated experience utilizing ETL (extract, transform, load) to design, build, test, and distribute customized reports, dashboards, and data visualizations to business leaders.
  • Experience developing, running, and managing SQL queries in conjunction with Python and/or R.
  • Knowledge of relational database structures.
  • Effective written and verbal communication skills with good analytical skills.
  • Able to work multi-functionally to tackle problems.
  • Familiarity with Salesforce reporting and dashboard solutions.
  • Familiarity with SOQL
  • Understanding of and experience with data analytics and predictive models.
  • Familiarity with higher education, fundraising, and/or financial transactions. Knowledge of HIPAA regulations is a plus.
  • Ability to read, analyze, and interpret emerging technology information and reports for application to support business operations and improvements as well as setting goals related to technology use and solutions, best practices, or innovation.
  • Fluency in approaches to a wide variety of interactive products, and the ability to rapidly learn and adapt to new ones.

 

 

Classified Title: Data Analyst 
Job Posting Title (Working Title): Contribution Data Analyst, Advancement Services   
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:30am-5:00pm 
FLSA Status: Exempt 
Location: JH at Keswick 
Department name: 10001639-Data Administration 
Personnel area: University Administration 

 

 

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

EEO is the Law
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

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.
JH at Keswick

Apply now »