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