Data Developer, ETL-1

Staff - Non Union

Job Category
M&P - AAPS

Job Profile
AAPS Salaried - Information Systems and Technology, Level D

Job Title
Data Developer, ETL-1

Department
Reporting – Offboard

Compensation Range
$8,063.17 - $12,575.08 CAD Monthly

The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge, qualifications and experience for the position. In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.

Posting End Date
April 20, 2024

Note: Applications will be accepted until 11:59 PM on the day prior to the Posting End Date above.

Job End Date

Nov 30, 2024

At UBC, we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research, innovation, and learning for all faculty, staff and students. Our commitment to employment equity helps achieve inclusion and fairness, brings rich diversity to UBC as a workplace, and creates the necessary conditions for a rewarding career. 

Job Summary

UBC has embarked on a multi-year journey to transform its academic and administrative support processes and system environments for the entire UBC community. In November 2020, UBC successfully went live with its new HR and Finance implementation of Workday. The Integrated Renewal Program (IRP) is now focused on the journey to renew the Student information ecosystem, anchored by the implementation of Workday Student.

The Integrated Renewal Program—Student (IRP Student) vision is to transform the way UBC supports learning and research, and how UBC works, to create a cohesive, integrated, and enriched experience for students, staff, and faculty. This implementation will result in superior support for UBC students, a better user experience, a new set of tools, a new way of working, and improved reporting for informed decision-making. IRP Student will leverage the industry-leading cloud enterprise solution Workday to replace our current core Student administration systems with a new integrated, user friendly, mobile-enabled platform.

For more information on the IRP Student, please visit www.integrated-renewal.ubc.ca

The Data Developer, ETL Dev designs computer application solutions for existing complex or campus-wide computer systems.
This position will contribute to the implementation of large-scale Enterprise Reporting Solution for UBC s Integrated Renewal Program (IRP). IRP is an enterprise-wide program that is transforming the process and systems that are used throughout the student, finance, and HR lifecycle by replacing legacy systems with commercial products.
The incumbent will focus on the design and implementation of 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 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.

Organizational Status
Interacts directly with other University technology professionals and with faculty, staff and students. Reports to the Senior Manager, Reporting and UDAP, IRP Student.
The position will work with other Data Developers, Build Engineers, Business Analysts and Quality Assurance staff in ensuring the highest quality of solution delivery.
Work Performed
Specific Duties:
-Design and implement robust, highly disciplined and maintainable ETL processes; develop data profiling, quality and cleansing requirements.
-Serve as a data quality/cleansing consultant for functional analysts to help define, estimate, and propose solutions for functional data issues.
-Develop proof-of-concepts and prototypes to help illustrate approaches to technology and functional problems.
-Contribute to designing detailed ETL strategies, approaches, and plans under the guidance of the Team Lead.
-Contribute and adhere to standards, structures, and techniques for capturing data from a variety of sources including data cleansing, migrating, validating, and auditing data.
-Participate in the development of technical design documents to communicate solutions that will be implemented.
-Facilitates and conducts design and code reviews for other ETL Developers to ensure efficiency and adherence to development standards.
-Build and maintain working relationships and collaborates with others to achieve client objectives.
Core Duties:
-Designs, develops and programs custom software, defines detailed ETL specifications, standards, and diagrams and develops coding logic flowcharts.
-Packages in house developed ETL applications for production or integrates vendor supplied applications.
-Provides technical expertise, training, and consultation to other staff.
-Conducts ETL testing to ensure application meets specifications.
-Supports software development lifecycle and applies and follows appropriate programming/development methodologies and best practices.
-Maintains appropriate professional designations and up-to-date knowledge of current information technology techniques and tools.
-Performs other related duties as required.
Consequence of Error/Judgement
The position takes an active, participatory role in ensuring the reliability and high availability of UBC mission critical 7x24 systems including application monitoring, tier 2 support, problem analysis and resolution, and ensuring services meet or exceed customer service levels at all times.
Errors in judgment, poor planning, or failure to act decisively could have a detrimental effect on these systems. Unreliable systems and code errors that disrupt the operations of these system, or failure to meet contractual obligations for performance and availability will damage the reputation of UBC and UBC-IT. This could adversely impact the University community, including the large majority of students, faculty and staff, and could cost hundreds of thousands of dollars in lost productivity, funding and revenue.
Supervision Received
Works with considerable latitude and with regard to methods and procedures. Work is reviewed in terms of achievement of broad objectives and goals.
Reports to the Senior Manager, Reporting and UDAP, IRP Student, and may work under the direction of a Senior Data Developer for specific project tasks.
Supervision Given
May provide guidance, coaching and technical leadership to, and provide feedback on performance of less experienced Data Developers.
In a project leader role, the Data Developer, ETL Dev may direct and supervises work of other Data Developers, Business Analysts, Testers, users and other staff assigned to projects.
May provide input/recommendations into the hiring and evaluation of staff.
Minimum Qualifications
Undergraduate degree in a relevant discipline. In-depth knowledge of applications and the business requirements supporting them. Minimum of five years of related experience, or the equivalent combination of education and experience.
- Willingness to respect diverse perspectives, including perspectives in conflict with one’s own
- Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion
Preferred Qualifications

Undergraduate degree in Computer Science preferred.

5 years of experience, in-depth knowledge of applications and the business requirements supporting them or the equivalent combination of education and experience. Demonstrated knowledge of ETL, Data Quality, Data Cleansing, and Extract-Transform-Load ETL concepts, principles, and tuning strategies; experience with SQL programming including advanced queries in multiple database technologies such as Oracle and SQL Server.
Prior experience developing ETLs with Informatica is required.
Experience with data analysis and modeling tools and concepts.
Experience performing technical analysis, technical design, implementation planning and delivery, and technical and end-user documentation.
Practical experience with delivery of large scale enterprise-class ETLs and Data Quality best practices.
Ability to work in a matrix team environment.
Knowledge of Student Information Systems is an asset.
Knowledge of Enterprise Resource Planning ERP systems with multiple modules e.g. CRM, Sales, Invoicing, and Financial Accounting is an asset.
Collaboration - Actively solicits ideas and opinions from others to efficiently and effectively accomplish specific objectives targeted at defined business outcomes. Openly encourages other team members to voice their ideas and concerns. Shows respect for differences and diversity, and disagrees without personalizing issues. Utilizes strengths of team members to achieve optimal performance.
Communication for Results - Conducts discussions with and writes memoranda to all levels of colleagues and peer groups in ways that support troubleshooting and problem solving. Seeks and shares relevant information, opinions, and judgments. Handles conflict empathetically. Explains the context of interrelated situations, asks probing questions, and solicits multiple sources of advice prior to taking action when appropriate.
Problem Solving - Applies problem-solving methodologies and tools to diagnose and solve operational and interpersonal problems. Determines the potential causes of the problem and devises testing methodologies for validation. Shows empathy and objectivity toward individuals involved in the issue. Analyzes multiple alternatives, risks, and benefits for a range of potential solutions. Recommends resource requirements and collaborates with impacted stakeholders.
Accountability - Sets objectives that meet organizational needs. Provides recommendations to individuals and teams on ways to improve performance and meet defined objectives. Monitors and provides feedback on individual and team performance against defined standards.
Business Process Knowledge - Maps full business processes and designs operational process flow. Facilitates group input and drafts proposals for process improvements. Identifies resource implications. Implements process improvement recommendations within the context of overall business processes.
Information Systems Knowledge - Resolves escalated problems of technical support. Identifies root causes. Sets up and integrates new and enhanced information systems. Identifies customer needs and determines the appropriate approach to apply and ensure resolution. Solicits the input of appropriate technical experts and managers as required.