Purpose:
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 on-going 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.
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.
Skills:
Ability to learn an unfamiliar business process quickly and adaptable to rapidly evolving requirements.
Ability to understand business rules, data architecture, and explain data requirements.
Efficient analytical and evaluative skills.
Effective organizational skills.
Effective communication skills to elicit, interpret and summarize information.
Ability to work and communicate in a professional manner.
Ability to use tact, diplomacy, and discretion when dealing with others.
Ability to recognize and respect others' diversity and individual differences.
Service-oriented, with an ability to assess the operational significance of a problem and set priorities accordingly.
Ability to exercise good judgment in analyzing and evaluating situations/circumstances and solving problems.
Effective organizational skills with an ability to handle conflicting priorities, multi-task and meet deadlines.
Ability to work independently to identify and accomplish key objectives in an environment of high volume and frequent interruptions.
Ability to exercise initiative and work effectively as a team member to support unit/organizational goals.
Ability and willingness to keep up to date with application development tools.
Effective deployment skills across DEV, QA, UAT and production environments.
Additional Notes:
Please note: This position requires the candidate to produce a verification of degree(s), credentials(s), or equivalences from accredited institutions and/or international equivalents at the time of interview.
If you are a current York University employee in the YUSA-1 bargaining unit and/or are using your job posting rights under the collective agreement to view and apply for jobs, you must apply through the Employee Career Portal - YU Hire to be considered an internal applicant.
As per Article 12.02(f) of the YUSA-1 Collective Agreement, to be considered an internal applicant, employees in the YUSA-1 bargaining unit must submit the application 5 working days following the first day of posting. This is referred to as the 'Posted Date' on the job posting. Please refer to the 'Posting Intent' on the job posting.
The University welcomes applications from all qualified individuals, including, but not limited to women, persons with disabilities, visible minorities (racialized), Indigenous Peoples and persons of any gender identity and sexual orientation. York University is committed to a positive, supportive and inclusive environment.
York University offers accommodation for applicants with disabilities in its recruitment processes. If you are contacted by York University regarding a job opportunity or testing, please advise if you require accommodation.
We are committed to enhancing our environmentally and socially responsible practices for the benefit of all members of the York community. Our long term perspective recognizes our responsibility to be innovators and to continually work as a community to reduce our ecological impact.
York University employees must apply to jobs through the Employee Career Portal - YU Hire. If you are a current York University employee and/or are using your rights under a collective agreement to view and/or apply to jobs, you MUST log into YU Hire to access the York University Employee Career Portal.
PLEASE NOTE: This job posting is for an existing vacancy. Applications must be received by 11:55 pm EST on the posted deadline date, if applicable. Posting deadlines can be updated, or modified, at any time based on hiring needs. Please refer to the York U Career Portal when confirming posting deadlines.
