Senior Data Engineer

York is a leading international teaching and research university, and a driving force for positive change. Empowered by a welcoming and diverse community with a uniquely global perspective, we are preparing our students for their long-term careers and personal success. Together, we can make things right for our communities, our planet and our future.

Under the direction of the Manager, Enterprise Data Management and Analytics, the Senior Data Engineer role leads the development, implementation, and support of data management activities such as data modeling, data ingestion, data mappings, data conversion and data migration, for the University's enterprise data architecture. The role is responsible for the development, implementation and support of the enterprise data platform encompassing enterprise solutions such as Student Information System (SIS), Student Award Cloud, People Soft ERP for Human Resources and Financials, Identity & Access Management, Microsoft Dynamics 365, Learning Management Systems, etc.

The role is responsible for implementing data-related assets that include data ingestion pipelines, cleansing and transformation activities, and data stores for analytical workloads. The role will use a wide range of data platform technologies, including relational and non-relational databases, file stores, and data streams. The role works closely with Data Architect, Senior Integration Developers, Senior Application Analysts, Reporting Analysts, Data Quality Analysts, external solution integrators and the wider York University community to provide technical leadership on the data pipelines that feeds business intelligence tools, enhances system integration capability, increases data accessibility, fosters enterprise data‑driven decision making across the University, and enables Governmental reporting.

Serving as an expert technical resource and subject matter expert, the Senior Data Engineer role takes requirements from concept to implementation. The Senior Data Engineer role is responsible for ensuring that the University's data architecture complies with the University's privacy and security standards and with data quality and governance frameworks. The role is responsible for the development and operation of the University's data governance tools (e.g., Data Cookbook) and supports the wider York University community with the ongoing maintenance of the University's data catalogue.

The role works closely with the Office of Institutional Planning (OIPA) and the wider York University community to ensure adherence to Data Governance standards, and to maintain the enterprise semantic layer that enables efficient deployment of Business Intelligence (BI) analytics tools such as Microsoft Power

BI, Oracle Analytics Cloud, and Tableau, to enable advanced enterprise analytics and reporting required to bring development and operations together for faster delivery times, enable digital transformation, and enhance data exchange/access across the university.

To be considered for this opportunity, you will bring the following:

• University Degree in Computer Science, Engineering, IT, Data Science, Applied Mathematics, Management Information System, or a related technology discipline/area, or an equivalent of four (4) years of recent experience (defined as within the last five years) working at York University and performing the same or similar tasks. This educational equivalency is in addition to the experiential requirements below.

• Seven (7) years' related Information Technology experience with major relational database management systems (e.g., Oracle or Microsoft SQL), with concurrent experience as follows:
• Five (5) year's hands‑on experience with ETL/ELT development
• Five (5) year's hands‑on experience with SQL scripting and managing enterprise relational SQL dimensional databases. Advanced knowledge of Extract, Transfer, Load (ETL) processes and associated technologies required.
• Four (4) year's hands‑on experience with all aspects of the analytics lifecycle:
  Discovery, Design, Build, Test and Deploy with a preference on SaaS data platforms (e.g., Oracle Analytics Cloud, Microsoft…