Senior Analyst, Data Quality - Office of Advancement

Georgetown University comprises two unique campuses in the nation’s capital. With the Hilltop Campus located in the heart of the historic Georgetown neighborhood, and the Capitol Campus, just minutes from the U.S. Capitol and U.S. Supreme Court, Georgetown University offers rigorous academic programs, a global perspective, and unparalleled opportunities to engage with Washington, D.C. Our community is a close-knit group of remarkable individuals driven by intellectual inquiry, a commitment to social justice, and a shared dedication to making a difference in the world.

Requirements

The Senior Analyst, Data Quality, Constituent Records, will work closely with teammates to maintain high quality biographical and engagement data in a database of over 800,000 alumni households and donor records for the Georgetown University Office of Advancement. This Salesforce-driven database, GU360, is the foundation for donor strategy, analytics, and communications; the Sr. Analyst will be a key member of the team that ensures this core data is of exceptional quality & consistency. This position will work across teams to create a biographical and engagement data hygiene plan; use SQL, Salesforce dashboards, and other utilities to identify duplicative data and processes; and test new features thoroughly, ensuring the continuity of large amounts of data during transitions.
 

Duties include but are not limited to:

• Remediate data quality issues in GU360 system to ensure biographical and engagement data are reliable for Data Analytics team and Advancement users.

• Consult on the implementation of enhancements in collaboration with Records team and Salesforce Architect.

• Ensure enhancements are consistent with existing data, and that team members are informed of needed changes to processes.

• Develop an error management ecosystem of reports, dashboards, and procedures.

• Maintain a suite of documentation, guides, and training materials that clearly define standards.

Work Interactions
The Constituent Records team oversees biographical and engagement data for the GU360 database. We input, verify, and manage any data that tells us who a person or entity is and what their relationship to Georgetown is. The Constituent Records Sr. Analyst will work collaboratively with a team of 10-15 employees and student workers to proactively identify problematic data or rapidly respond to stakeholder critical errors. Further, the Sr. Analyst is expected to work very closely with other members of the Data team, particularly the Director of Data Integrity, and University Information Services (UIS) developers to resolve large-scale system issues or test new developments. While the Sr. Analyst is not a supervisory position, they will be allocated student workers on a project basis if needed and will be expected to work with the Coordinator to organize full-time staff on data cleaning projects for their respective expertise. The Sr. Analyst will report to the Associate Director, Constituent Records.

Requirements and Qualifications

• Bachelor’s degree

• 2+ years of professional experience in data management, preferably in higher education or non-profit setting

• Proficient with Salesforce and Salesforce Standard Reports

• Skilled in leveraging SQL for extraction, transformation and analysis of data

• Demonstrated skill with Excel, particularly in using formulas such as V-Lookup or power query to synthesize data between multiple files

• A self-starter, able to independently ideate and propose well-thought-out solutions

• Highly organized and detail-oriented, independent and motivated by achieving milestones

• Ability to relay complex issues and data terminology in a comprehensible way to a variety of audiences

• Comfortable with reporting, data analysis and marketing terminology

• Ability to successfully handle multiple tasks and priorities simultaneously, and consistently meet all deadlines

• Able to assimilate data, exercise sound judgment and discretion, and work independently

• Accuracy in materials preparation and ability to maintain confidentiality

• Able to work with internal and external partners in positive and collaborative interactions

Preferred Qualifications

• Familiarity with Salesforce CRM Analytics

• Familiarity with Apsona

• Familiarity with Ellucian Banner, Cvent, iModules, and Gravity Forms platforms

• Familiarity with SOQL

• Familiarity with APEX

• Familiarity with Higher Education or Nonprofit fundraising environment

Work Mode Designation
This position has been designated as Hybrid, two days in office. Please note that work mode designations are regularly reviewed in order to meet the evolving needs of the University. Such review may necessitate a change to a position’s mode of work designation. Complete details about Georgetown University’s mode of work designations for staff positions can be found on the Department of Human Resources website: https://hr.georgetown.edu/mode-of-work-designation.

Pay Range:

The projected salary or hourly pay range for this position which represents the full range of anticipated compensation is:

Compensation is determined by a number of factors including, but not limited to, the candidate’s individual qualifications, experience, education, skills, and certifications, as well as the University’s business needs and external factors.

Current Georgetown Employees:

If you currently work at Georgetown University, please exit this website and login to GMS (gms.georgetown.edu) using your Net ID and password. Then select the Career worklet on your GMS Home dashboard to view Jobs at Georgetown.

Submission Guidelines:

Please note that in order to be considered an applicant for any position at Georgetown University you must submit a resume for each position of interest for which you believe you are qualified. Documents are not kept on file for future positions.

Need Assistance:

If you are a qualified individual with a disability and need a reasonable accommodation for any part of the application and hiring process, please click here for more information, or contact the Office of Institutional Diversity, Equity, and Affirmative Action (IDEAA) at 202-687-4798 or ideaa@georgetown.edu.

Need some assistance with the application process? Please call 202-687-2500. For more information about the suite of benefits, professional development and community involvement opportunities that make up Georgetown's commitment to its employees, please visit the Georgetown Works website.

EEO Statement:

GU is an Equal Opportunity Employer. All qualified applicants are encouraged to apply, and will receive consideration for employment without regard to age, citizenship, color, disability, family responsibilities, gender identity and expression, genetic information, marital status, matriculation, national origin, race, religion, personal appearance, political affiliation, sex, sexual orientation, veteran status, or any other characteristic protected by law.

Benefits:

Georgetown University offers a comprehensive and competitive benefit package that includes medical, dental, vision, disability and life insurance, retirement savings, tuition assistance, work-life balance benefits, employee discounts and an array of voluntary insurance options. You can learn more about benefits and eligibility on the Department of Human Resources website.