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

• Famili