Associate Director, Data Management

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., 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 required5+ years of related work experienceStrong experience designing relational and multi-dimensional modelsGood analysis and problem-solving skills to understand business information requirements and resolve data quality issues in delivered BI solutionsExperience performing data selection and SQL development using PL/SQL and Oracle Stored ProceduresStrong understanding of data architecture requirements for BI reporting tools (Cognos, MS Reporting, and Tableau preferred)Experience developing solutions using Excel and MS AccessExperience with office tools such as PowerPoint and WordFamiliarity with project managementStrong customer service orientationOrganizational skills to handle several projects simultaneously to accommodate shifting priorities and meet deadlinesEffective communication, presentation and facilitation skillsStrong initiative, self-motivation and the ability to work both independently and in teamsDemonstrated ability to work effectively and collaboratively with othersHigh degree of professionalism, a positive ‘can do’ attitude and strong work ethicCommitment 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 missionExperience in higher educationFamiliar with the applications in use by the Office of Development including SunGard Advance and OnBase is preferredSense of humor is a plus.

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. Standard Weekly Hours 36.25