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.
Note: Applications will be accepted until 11:59 PM on the Posting End Date.
Job End Date
OngoingAt 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
The Office of the CIO (OCIO) has an extensive list of investment requests for IT enabled projects from across the University of British Columbia. The execution of the portfolio of projects extends out over at least the next five years, and new projects are being added on a regular basis. The execution of each project within the portfolio is approximately one year and most resources from each project will transition onto the next projects upon completion of the delivery of each project. These projects will be managed within the Program Delivery Office (PMO). The Program Delivery office is seeking a Data Conversion Lead to support the usability and outcomes of these projects.
Working closely with Senior Project Managers, and in relation to assigned IT Capital Projects, the Data Conversion Lead will work collaboratively with Business Analysts, Solution Architects, and the Integration Enablement Center (IEC) to implement large-scale Data Migration/Conversion solutions. The incumbent will focus on the design and implementation of Data Migration/Conversion processes and components including Data Quality analysis, Master Data Management, Data Retention strategies and workflows, Data Cleansing strategies and workflows, Data Augmentation, Data Mapping using logical and physical data models, ETLs for Data Migration/Conversion strategies and workflows, 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 data migration solutions.
This is a hands-on delivery role within a multi-disciplinary technical and business team.
Organizational Status
The Data Conversion Lead reports to Senior PMO Delivery Manager, Program Delivery Office and works closely with the Chief Data Officer, Enterprise Data Governance Team. The Incumbent will also be accountable for results to the OCIO Executive and Senior Leadership while working closely with stakeholders and senior colleagues from the UBC IT technical leadership group as well as other units within the University. The incumbent will ensure that all proposed solutions are aligned with the business needs, project constraints and university data model, enterprise architecture standards and any project related exceptions are managed in an informed manner. In addition, the incumbent will ensure that formal project management methodologies established by UBC IT's Program Delivery Office (PMO) are followed.
Work Performed
Specific Duties:
Design robust, scalable, and maintainable data conversion processes; build metadata repositories; develop data quality requirements; design and develop sustainable ETL applications.
Leads the evaluation and selection process of software products for the data migration projects, and advises on options, risk, cost vs. benefits, and impacts on business processes and goals.
Serve as a conversion specialist for functional teams to help define, estimate, and propose solutions for functional opportunities.
Develop proofs-of-concept and prototypes to help illustrate approaches to technology and functional problems.
Define detailed standards for the integration/migration approach for data, and data structure conventions.
Define standards, structures, and techniques for capturing data from sources, cleansing, and integrating data.
Work with the lead architect on the overall ETL conversion design - conceptual, logical, and physical representations.
Works with UBC IT architects to provide input into both the Application and Technical architecture as they relate to software development.
Create technical design documents to communicate solutions that will be implemented by the development team.
Facilitates and conducts design and code reviews for other Programmer Analysts to ensure efficiency and adherence to development standards.
Coach and train other Programmer Analysts in the construction of components necessary to move data between applications and develop enterprise reports.
Leads the coordination of the various design elements associated with software development.
Data Conversion Lead will work closely with other developers, UX Architects/Designers and DBAs and ensure that designs are incorporated into Technical Specifications as required and specifications are updated as changes occur.
Conducts testing of new or customized application modules to ensure applications meet specifications.
Builds and maintains good working relationships and collaborates with others to achieve client objectives.
Makes decisions within established guidelines regarding the application of computing devices or programs to meet set requirements or makes decisions regarding solutions to defined problems.
Core Duties:
Provides technical leadership in the analysis and review of existing or proposed system features and integration, security, scalability and performance requirements with users, business analysts, architects and team members.
Leads the evaluation and selection process for application packages, and advises on options, risk, cost vs. benefits, and impacts on business processes and goals.
Develops system test plans, oversees testing of new or modified applications and ensures applications meet specifications.
Develops integration plans and ensures for the incorporation of plans into integration testing process.
Ensures documentation of functions and changes to new or modified modules, tests activities/results, error handling and backup/recovery procedures.
Designs, develops and programs specialized custom software, prepares functional specifications, and builds prototypes.
Provides expert advice on complex system design issues and contributes to ongoing planning and development of systems enhancements.
Packages in house developed applications for production or integrates vendor supplied applications.
May manage small to medium sized projects.
Provides technical expertise, training, and consultation to other staff.
Provides ongoing maintenance and operational support for applications.
Supports software development lifecycle and applies and follows appropriate programming/development methodologies and best practices as instructed.
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
Transformative institutional and Information Technology initiatives play a key role in enabling the University to achieve its goal of becoming one of the worlds’ leading universities. Major system implementations pose a significant degree of risk to UBC from a financial, people, process and reputational perspective. If programs fail to complete, achieve desired outcomes, or are not in keeping with the University s Information Technology goals, the resulting financial, operational, and reputational impacts could be long lasting.
Supervision Received
The Data Conversion Lead reports to the Senior PMO Delivery Manager, Program Delivery Office.
Supervision Given
May lead and supervise a team of Data Conversion Developers and Specialist across multiple projects to support large scale IT Capital Projects.
Plans, directs and supervises work of other technical project team members and oversee deliverables by consultants, and vendors assigned to the project portfolio. Provide input/recommendations into the hiring and evaluation of staff.
Minimum Qualifications
Undergraduate degree in a relevant discipline. Minimum of ten years of related experience including at least two years of managerial 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
Leadership mindset with a focus on mentoring and coaching team members.
Demonstrated knowledge of Data Migration, 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.
Experience in Python Programing.
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 two large scale enterprise-class Data Migrations and Data Quality best practices. Ability to work in a matrix team environment.
Knowledge in Webservices and MuleSoft APIs.
Knowledge of Student Information Systems is an asset.
Knowledge of Enterprise Resource Planning ERP systems with multiple modules e.g. CRM, Sales, Invoicing, Financial Accounting is an asset.
Competency Proficiency:
Core Competencies:
Collaboration (Advanced - A): Consistently fosters collaboration and respect among team members by addressing elements of the group process that impedes, or could impede, the group from reaching its goal. Engages the "right people," within and beyond organizational boundaries, by matching individual capabilities and skills to the team's goals. Works with a wide range of teams and readily shares lessons learned and credit for team accomplishments.
Communicating for Results (Advanced - A): Converses with, writes reports for, and creates/delivers presentations to all levels of colleagues and peer groups in ways that support problem solving and planning. Seeks a consensus with business partners. Debates opinions, tests understanding, and clarifies judgments. Brings conflict into the open empathetically. Explains the context of multiple interrelated situations, asks searching, probing questions, and solicits expert advice prior to taking action and making recommendations.
Problem Solving (Advanced - A): Diagnoses problems using formal problem-solving tools and techniques from multiple angles and probes underlying issues to generate multiple potential solutions. Proactively anticipates and prevents problems. Devises, facilitates buy-in, makes recommendations, and guides implementation of corrective and/or preventive actions for complex issues that cross organizational boundaries and are unclear in nature. Identifies potential consequences and risk levels. Seeks support and buy-in for problem definition, methods of resolution, and accountability.
Role Based Competencies:
Accountability (Advanced - A): Sets enhanced objectives for self and others. Monitors performance trends and identifies opportunities to improve standards. Provides regular feedback and suggests alternative approaches necessary to ensure that organizational objectives and superior standards are achieved. Delegates responsibility and reallocates resources as needed to ensure that priorities are met for initiatives within area of responsibility.
Business Process Knowledge (Advanced - A): Describes and documents critical cross-functional business process flows. Applies business process reengineering techniques and methods in analyzing process flow and accountability charts. Recommends and advocates substantive process enhancements and assesses both internal and external implications.
Information Systems Knowledge (Advanced - A): Identifies means of integrating technical support requirements with enterprise processes and strategies. Identifies technological opportunities to meet client needs. Creates information system solutions to meet the needs of business stakeholders. Partners with appropriate technical consultants, experts, and managers to resolves complex problems across all IT solutions.