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, PeopleSoft 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 PowerBI, 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: Education 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. Experience 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 Azure data services). Two (2) year's hands‑on experience in production support and maintenance Comprehensive knowledge of data architecture, including data modelling, data governance (policies, standards, processes & quality) and data management (identify, collect/ingest, process, orchestrate, store, organize, secure, access & integrity). Comprehensive knowledge of data management patterns, techniques, and solutions, including master data management, data pipeline, data warehousing, data lakes, data ingestion & connectivity tools (Informatica, Profisee, Azure Data Factory, etc.) Extensive experience in data warehousing technologies (e.g., Oracle Autonomous Data Warehouse), enterprise database solutions (e.g., Oracle Autonomous Database, Microsoft Azure SQL) and business intelligence environments (e.g., Oracle Analytics Cloud, Microsoft PowerBI, Tableau, Oracle Business Intelligence Enterprise Edition). Experience with analyzing and profiling data, designing, and implementing data management solutions. handling sensitive data sets, production deployment, troubleshooting and production support, data conversion. Data Management or Data Architecture certification is an asset. For full position details, including skills and knowledge requirements, and to apply to this exciting opportunity visit the External Career Portal ( and refer to posting . We offer comprehensive benefits and access to superb educational and recreational facilities. For more information on what York has to offer U please visit: Seniority level Mid‑Senior level Employment type Contract Job function Information Technology, Engineering, and Science Industries Higher Education #J-18808-Ljbffr