Skip to main content

This job has expired

Associate Director, Data Management

Employer
Princeton University
Location
New Jersey, United States
Salary
Salary Not specified
Date posted
Jan 11, 2023

Associate Director, Data Management

US-NJ-Princeton

Job ID: 2022-15914
Type: Full-Time
# of Openings: 1
Category: Information Technology

Princeton University

Overview

Reporting to the Assistant Vice President for Data Strategy & Innovation, the Associate Director Data Management is a member of the Analytics & Data 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 two professionals, including a Data Systems Engineer and a Senior 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.

Princeton University Advancement works to inform, inspire, and involve Princeton’s global community of alumni, parents, and friends in ways that enable the University to fulfill its mission of advancing learning through scholarship, research, and teaching to serve humanity.



Responsibilities

Data Warehouse Development and Strategy
• Develop a Business Intelligence solution framework according to architectural specifications to integrate the following components: operational data store (ODS), APIs, ETLs, as well as complementary tools
• Creation and maintenance of the logical and physical data models for the Business Intelligence data warehouse
• Design and build Cognos metadata via Framework Manager
• Create detailed documentation of the ODS and report specifications as part of project solutions and general production support

Cross-Team and Departmental Collaboration
• Work closely with business intelligence analysts to gather, analyze, and document business and technical requirements
• Work with other Development partners to analyze, and resolve, data quality issues
• Provide business analysis support to the Office of Development on production issues
• Participate with cross-departmental teams in support of the priorities and information needs of the Office of Development
• Serve as a solid contributor and driver of the data management team and act as a mentor to the Information Delivery Analyst

Best Practices and Process Improvements
• Responsible for quality management surrounding production support and project initiatives
• Review existing business processes and analyze to provide and implement solutions for process improvements
• Develop solutions using Lean and Agile software development principles and processes
• Serve in a consultative capacity to identify and recommend system improvements and next generation applications of our CRM system

Staff Management
Recruit, mentor and direct the development of two 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

Essential Qualifications:

• Bachelor’s degree required
• Minimum of five years of related 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.

Preferred Qualifications

• 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

Princeton University is an Equal Opportunity/Affirmative Action 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. KNOW YOUR RIGHTS

PI201183431

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert