Senior Data Systems Engineer
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.
Senior Data Systems Engineer
Job ID: 2020-12054
# of Openings: 1
Category: Information Technology
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.
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
- 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
- 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
- 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