Data Conversion Developer

Job Category

Job Profile

Job Title

Department

Compensation Range

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 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

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

Job End Date

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

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 few years and new projects are being added on a regular basis. These projects will be managed within the Program Delivery Office (PMO). The Program Delivery office is seeking a Data Conversion Developer 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 Developer will work collaboratively with Enterprise Data Governance (EDG) 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
Interacts directly with other University technology professionals and with faculty staff and students. Reports to the Senior PMO Delivery Manager.

The position will work with other Enterprise Data Governance Architects Programmer Analysts Build Engineers Business Analysts and Quality Assurance staff in ensuring the highest quality of solution delivery.

Work Performed

Specific Duties:

• Design robust highly disciplined and maintainable data migration/conversion processes; build master data repositories; 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 data migration/conversion strategies approaches and plans under the guidance of the Data Conversion 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.
• Create technical design documents to communicate solutions that will be implemented by the development team.
• Facilitates and conducts design and code reviews for other Data Developers to ensure efficiency and adherence to development standards.
• Gather scope and requirements of assigned data migration/conversion units.
• Contributes to the development of data specifications.
• Build and maintain working relationships and collaborates with others to achieve client objectives.

Core Duties:

• Designs develops and programs custom software defines detailed application specifications standards and diagrams and develops coding logic flowcharts.
• Develops overall systems design researches and evaluates vendor supplied applications provides customize or develop recommendations and implements accordingly.
• Analyzes and reviews existing or proposed system features and integration security scalability and performance requirements with clients business analysts and team members. -Manages small to medium sized projects and related budgets.
• Packages in house developed applications for production or integrates vendor supplied applications.
• Provides technical expertise training and consultation to other staff.
• Develops or modifies software application design and specific modules.
• Conducts testing of new or customized application modules to ensure application meets specifications.
• Documents functions and changes to new or modified modules tests activities/results error handling and backup/recovery procedures.
• Provides ongoing maintenance and operational support for applications.
• 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 PMO Delivery Manager and may work under the direction of a Data Conversion Lead for specific project tasks.

Supervision Given

May provide guidance coaching and technical leadership to and provide feedback on performance of less experienced Programmer Analysts.

In a project leader role the Data Conversion Developer 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 -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 ones own

- Demonstrates a commitment to enhancing ones own awareness knowledge and skills related to equity diversity and inclusion

Preferred Qualifications

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.

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.