Associate Director, Data Management

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.

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.

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

Princeton University is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law.

The University considers factors such as (but not limited to) scope and responsibilities of the position, candidate's qualifications, work experience, education/training, key skills, market, collective bargaining agreements as applicable, and organizational considerations when extending an offer. The posted salary range represents the University's good faith and reasonable estimate for a full-time position; salaries for part-time positions are pro-rated accordingly.

If the salary range on the posted position shows an hourly rate, this is the baseline; the actual hourly rate may be higher, depending on the position and factors listed above.

The University also offers a comprehensive benefit program to eligible employees. Please see this link for more information.