You're using an older version of Internet Explorer that is no longer supported. Please update your browser.
IRP- Student, UBC

Data Developer, ETL

Ubc, BC
Full Time
14 days ago
87,340 to 136,468 per year

What UBC is looking for:

We are looking to fill the role of Data Developer, ETL on the IRP Security, Access, Data and Reporting team. This individual will design and implement ETL processes and components including Data Quality analysis, Reference Data Management, Data Cleansing and workflows, Data Augmentation, Data Mapping using logical and physical data models and Data Reconciliation strategies and workflows.

The ideal candidate will have the following:

  • Experience in ETL development - Informatica PowerCentre and Oracle database (PL-SQL)
  • Experience in designing and implementing robust, highly disciplined and maintainable ETL processes; developing data profiling, quality and cleansing requirements.
  • Ability to contribute and adhere to standards, structures, and techniques for capturing data from various sources, including data cleansing, migrating, validating, and auditing data.

The incumbent will work closely with end users, analysts, technical leads, managers, and developers to Clean, Augment and Migrate millions of UBC-related records. The applicant will understand complex data, relationships, and dependencies inherent in enterprise-class systems and understand how translate these complexities into high quality ETL solutions.

This is a hands-on delivery role within a multi-disciplinary technical and business team.

About the program:

UBC has embarked on a multi-year journey to transform its academic and administrative support processes and system environments for the entire UBC community. Following the successful completion of major renewal projects related to UBC’s Human Resources and Finance systems under the Integrated Renewal Program (IRP) in 2020, work is now underway for the next stage of IRP - to renew the Student information ecosystem, anchored by the implementation of Workday Student. 

The Integrated Renewal Program – Student (IRP Student) will leverage the industry-leading cloud enterprise solution, Workday, to replace UBC’s current core Student administration systems with a new integrated, user-friendly, mobile-enabled platform. This project has a high degree of complexity, influence, and impact as our solution is designed for the majority of constituents in the UBC community. UBC is one of the first Canadian institutions to implement Workday for this purpose.

For more information on the IRP Student, please visit

Why work at UBC?

  • UBC is proud to rank 37th globally in the 2022 THE World University Rankings ( ). 
  • UBC is ranked 2nd Best University in Canada
  • UBC has been recognized as one of BC’s Top Employers, UBC offers faculty and staff a family-friendly work environment with paid vacation, as well as a comprehensive benefits plan.
  • The IRP Student Program has implemented a remote work program, modelled to respect the highly different roles and contexts that exist across UBC.

If you are interested in the Data Developer, ETL, please visit our UBC Staff Career portal to see the full job posting and to apply directly no later than January 30, 2022.

Thank you in advance for your interest and application!

Information Technology