New

Sr. Data Analyst, Alumni Relations

Johns Hopkins University
United States, Maryland, Baltimore
Jul 08, 2025
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 an onsite work arrangement with an onsite presence of 3 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. The Office of Alumni Relations is a central unit of 30 professionals within Development and Alumni Relations, dedicated to engaging nearly 260,000 alumni across all Johns Hopkins University schools. The office leads seven key functional areas: (1) Reunion Programs, (2) Lifelong Learning and Travel, (3) Regional, Student, and Young Alumni Programs, (4) Mentoring Initiatives, (5) Communications, (6) Identity and Shared Interest Communities, and (7) the university-wide Alumni Council. The Sr. Data Analyst serves as the primary expert on alumni and constituent engagement data within the Office of Alumni Relations (OAR), a team of 30 professionals supporting a global alumni community of approximately 260,000. Reporting to the Assistant Vice President of Alumni Relations with a dotted line to the Assistant Vice President of Advancement Services, this role will lead the management and analysis of engagement data, ensuring data integrity, creating reports. optimizing reporting systems and generating business intelligence to drive alumni relations strategies, programs, and tactics, along with program evaluation (ROI, etc.) Key responsibilities: 1. Data Management and Integrity Collaborate with OAS to maintain and ensure the integrity of alumni data within the Johns Hopkins Advancement System (JHAS), a Salesforce-based CRM. In collaboration with OAS, develop and enforce data governance policies to standardize alumni engagement data across schools. Manage data imports, exports, and integrations, resolving discrepancies to ensure accuracy. Collaborate with the OAR Communications team to improve the number of contactable alumni, including addressing invalid data and unsubscribe designations. Oversee involvement and volunteer coding, ensuring accurate tracking of alumni engagement. Monitor and integrate relevant data sources into JHAS. Oversee maintenance and updating of biographic and demographic alumni data. 2. Data Analytics and Reporting Serve as the subject matter expert on alumni engagement data and reporting within JHAS. Develop and manage reports, dashboards, and data visualization tools (Salesforce, Power BI, etc.) to track alumni engagement. Conduct trend analysis and generate insights to enhance alumni programming and outreach. Collaborate with OAS on Campaign Engagement Measures reporting and data management to support enterprise-level reporting on engagement for the Hopkins Campaign. Lead Alumni Engagement Score reporting and provide training on best-use scenarios. Partner with OAR Communications on annual reporting, infographics, and data-driven storytelling. Oversee annual CASE Alumni Engagement Metrics reporting and track non-philanthropic campaign engagement. Support the development of internal KPIs and process improvement initiatives. 3. CRM & Technology Optimization Train OAR staff on data tools, JHAS functionality, and best practices. Support segmentation and targeting strategies for alumni outreach. Identify CRM enhancements to meet evolving needs. Oversee AlumniQ data migration and event registration processes. 4. Survey & Assessment Design and analyze alumni survey dashboards to assess engagement and satisfaction. Interpret qualitative and quantitative data to inform programming improvements. 5. Collaboration & Strategy Development Partner with Advancement Services to align on best practices and optimize database functionalities. Serve as a strategic partner in fundraising and engagement initiatives. Stay current on CRM developments by participating in JHAS training and workshops. 6. Data Governance & Compliance Ensure data handling aligns with university policies and legal regulations (FERPA, GDPR, etc.). Identify opportunities for workflow and process optimization. Document and enforce data quality standards across OAR. Represent OAR in pipeline management and data integrity committees. 7. Supervision Manage and mentor the Data Analyst, including hiring, training, goal setting, and performance evaluation. Minimum Qualifications Bachelor's degree. Five years' experience. Additional education may substitute for required experience and additional related experience may substitute for required education beyond HS Diploma/Graduation Equivalent, to the extent permitted by the JHU equivalency formula. Preferred Qualifications Master's degree in a related field. Five+ years of experience in data analytics, preferably in higher education or alumni relations. Expertise in SQL, SOQL, and ETL processes. Familiarity with data warehousing concepts. Experience managing data pipelines and workflow automation. Strong project management skills with the ability to prioritize and execute multiple initiatives. Proficiency in advanced Excel functions (Power Query, VBA, Macros, Pivot Tables). Strong interpersonal and presentation skills, with experience presenting data-driven insights to leadership. Experience with data analytics, reporting, and visualization tools (Salesforce, Tableau, Power BI, SQL, ETL). Strong analytical and problem-solving skills with the ability to manage large datasets. Excellent communication skills to interpret data and engage stakeholders. Knowledge of data governance best practices and reporting methodologies. Ability to work independently and collaborate in a dynamic environment. Classified Title: Sr. Data Analyst Job Posting Title (Working Title):Sr. Data Analyst, Alumni Relations Role/Level/Range: ATP/04/PD Starting Salary Range: Minimum: $62,899 - Maximum: $110,100 (targeted salary: $90,000; commensurate with experience) Employee group: Full Time Schedule: Monday-Friday, 8:30am-5:00pm FLSA Status:Exempt Location:Mount Washington Campus Department name: 10001651-Alumni Relations 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. EEOis 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.