Associate Director, Data Management

Overview

Reporting to the Director, Data & Analytics, the Associate Director is a member of the Data & Analytics Management Team within the department of Data Strategy & Innovation (DS&I). DS&I is dedicated to housing, managing, analyzing and disseminating information and data to inform Advancement Office strategy; foster strong relationships with donors, volunteers and campus partners; and promote effective integration.

The Associate Director manages a Data Systems Engineer, and performs a variety of tasks to deliver technology improvements to the Data Warehouse environment. The specific responsibilities of this position include developing and testing extraction, transformation, and load (ETL) processes; defining and capturing metadata and rules associated with ETL processes; adapting ETL processes to accommodate changes in source systems and new business user requirements; working with both technical staff and business constituents to translate business requirements into technical solutions; maintaining technical and user documentation.

This is a hybrid role.

Responsibilities

Data Warehouse Development and Strategy:

• Lead the design, implementation, and ongoing enhancement of the Advancement Data Warehouse platform.
• Develop and maintain conceptual, logical, and physical data models supporting reporting, analytics, and operational intelligence.
• Design and oversee ELT pipelines that ingest and transform data.
• Establish standards for data modeling, business rules implementation, and warehouse development practices.
• Lead development of curated reporting and analytic data structures that balance usability, performance, and long-term maintainability.
• Maintain technical documentation, source-to-target mappings, and data lineage associated with warehouse assets.

Cross-Team and Departmental Collaboration:

• Partner with reporting analysts and business stakeholders to translate information needs into scalable warehouse solutions.
• Serve as the primary technical authority on Advancement reporting data structures and warehouse design.
• Collaborate with analysts to ensure reporting assets accurately reflect institutional business definitions and reporting requirements.
• Support implementation of enterprise reporting and analytics initiatives through the delivery of trusted data assets.
• Guide stakeholders in effective use and interpretation of warehouse data.

Best Practices and Process Improvements:

• Establish and maintain data quality controls within the data warehouse environment.
• Define and manage warehouse business rules, transformation logic, and metadata standards.
• Collaborate with institutional data governance partners to implement approved data standards within reporting and analytics platforms.
• Develop monitoring and reconciliation processes to identify and resolve data integrity issues.
• Promote best practices in warehouse development, documentation, testing, and release management.
• Identify opportunities to improve scalability, automation, performance, and maintainability of warehouse processes.

Staff Management:

• Recruit, mentor and direct the development of direct reports, including setting performance standards and measures; providing appropriate levels of training, mentoring and professional development; and fostering a strong sense of teamwork and cross-functional communication and collaboration among direct reports, the ADM staff, and with other groups within Advancement and the University.

Qualifications

• Bachelor's degree required
• 5+ years of related work experience
• Strong experience designing relational and multi-dimensional models
• Good analysis and problem-solving skills to understand business information requirements and resolve data quality issues in delivered BI solutions
• Experience performing data selection and SQL development using PL/SQL and Oracle Stored Procedures
• Strong understanding of data architecture requirements for BI reporting tools (Cognos, MS Reporting, and Tableau preferred)
• Experience developing solutions using Excel and MS Access
• Experience with office tools such as PowerPoint and Word
• Familiarity with project management
• Strong customer service orientation
• Organizational skills to handle several projects simultaneously to accommodate shifting priorities and meet deadlines
• Effective communication, presentation and facilitation skills
• Strong initiative, self-motivation and the ability to work both independently and in teams
• Demonstrated ability to work effectively and collaboratively with others
• High degree of professionalism, a positive 'can do' attitude and strong work ethic
• Commitment to University Advancement's mission to inform, involve, and inspire Princeton's global community of alumni and friends, and adhering to its guiding principles of High Performance, Innovation, Civility, and Collaboration.
• Demonstrated ability to work effectively and build relationships with individuals from diverse backgrounds, identities, abilities, and experiences.

Preferred:

• Prior business or technical staff management experience in delegating, planning and mentoring to ensure staff meet and exceed expectations.
• Knowledge of Princeton's mission
• Experience in higher education
• Familiar with the applications in use by the Office of Development including SunGard Advance and OnBase is preferred
• Sense of humor is a plus.

Standard Weekly Hours

36.25

Eligible for Overtime

No

Benefits Eligible

Yes

Probationary Period

180 days

Essential Services Personnel (see policy for detail)

No

Physical Capacity Exam Required

No

Valid Driver's License Required

No

Experience Level

Director

#LI-JJ1

Salary Range

$140,000 to $157,000