Senior Data Systems Engineer

Job description

Senior Data Systems Engineer


Job ID: 2020-12054
Type: Full-Time
# of Openings: 1
Category: Information Technology

Princeton University


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 toolsCreation and maintenance of the logical and physical data models for the Business Intelligence data warehouse Design and build Cognos metadata via Framework ManagerCreate 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 issuesProvide business analysis support to University Advancement on production issuesParticipate 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 initiativesReview existing business processes and analyze to provide and implement solutions for process improvementsDevelop solutions using Lean and Agile software development principles and processesServe in a consultative capacity to identify and recommend system improvements and next generation applications of our CRM system


Essential Qualifications:

    Bachelor’s degree requiredStrong experience designing relational and multi-dimensional modelsMinimum of five years of related experienceGood 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 management Strong customer service orientation Organizational skills to handle several projects simultaneously to accommodate shifting priorities and meet deadlinesEffective communication, presentation and facilitation skills Strong 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 ethicFamiliar 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.





Diversity Profile: University



View more

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

Arrow pointing right
Job No:
Posted: 10/14/2020
Application Due: 10/20/2020
Work Type: