Senior Data Systems Engineer

Job description


Reporting to the Director of Analytics & Data Management, the Sr. Data Systems Engineer is a member of the Analytics & Data Management Team within the Advancement Operations unit of Princeton University Advancement. 


The senior systems engineer 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.


Principal Duties


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 Advancement partners to analyze, and resolve, data quality issues
  • Provide business analysis support to University Advancement on production issues
  • Participate with cross-departmental teams in support of the priorities and information needs of the Office
  • Serve as a solid contributor and driver of the data management team and act as a mentor to other staff

 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

Essential Qualifications:


  • Bachelor’s degree required
  • Strong experience designing relational and multi-dimensional models
  • Minimum of five years of related experience
  • 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
  • Familiar with the applications in use by the Office of Development including SunGard Advance and OnBase is preferred


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. EEO IS THE LAW.


Salary GradeAIT, 030Standard Weekly Hours36.25Eligible for OvertimeNoBenefits EligibleYesEssential Services Personnel (see policy for detail)NoComments Related to End DateOne year termPhysical Capacity Exam RequiredNoValid Driver’s License RequiredNo




Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 10/15/2020
Application Due: 10/22/2020
Work Type: