Job Specifications
Data Conversion and Reporting Developer - 2 Year Temporary Position
The Surrey School District respectfully acknowledges that our schools reside on the traditional, unceded, and shared territories of Coast Salish peoples: The q ic@ y - Katzie, the q'wa:nl'@n - Kwantlen and the SEMYOME - Semiahmoo First Nations, who have been stewards of this land since time immemorial.
Surrey Schools values an inclusive school district where equity is deeply embedded, and diversity welcomed. We acknowledge the profound responsibility we all have in ensuring that our schools and district sites foster an atmosphere where everyone feels secure, respected, and valued. Our commitment to providing a quality education extends beyond academic excellence; we are committed to creating and cultivating diverse, inclusive, and barrier-free environments for all applicants, employees, students, and their families. Our identity, as Surrey Schools, is expressed in the shared values of openness, fairness and tolerance and recognizes the importance of diversity of identity and thought. We are an equal opportunity employer and welcome applicants from all backgrounds.
Surrey Schools is the largest school district in BC and the second largest employer in Surrey. Spread across one of the fastest-growing cities in British Columbia, Surrey Schools provides quality education to over 82,000 students with 124 schools sites and a variety of other learning facilities, offering a broad range of innovative programs and services to support the learning of our students. The Surrey School District team of approximately 13,000 employees works tirelessly every day to ensure that children are getting the best start they can, providing the preparation to be our leaders of tomorrow.
THE ROLE
The Data Conversion Developer plays a senior technical role within the Information Technology department, supporting the transition to a new (Enterprise Resource Planning) ERP. Reporting to the Enterprise Data Architect, this position collaborates with management, steering committees, departmental subject matter experts, and external system integration consultants to deliver valuable services supporting school and district operations. The role is critical to the success of the enterprise system transformation, with specific responsibilities including mapping, extracting, cleansing, transforming, validating, and loading historical and operational data from the previous to the new ERP Financials, HCM, and Procurement modules. The Data Conversion Developer will also support testing cycles and reconciliation efforts between the systems, perform conversion tasks and system cutover activities under the direction of the Enterprise Data Architect.
Typical Responsibilities
Play a key role in the district's strategic project to implement a modern cloud-based ERP, directly supporting the Enterprise Data Architect and other project leaders.
Lead and perform data extraction and transformation processes for all relevant modules (Finance, HCM and Procurement).
Analyze previous database schema and source data structures to produce accurate data mappings to enterprise data objects
Collaborate with functional teams and leads to understand business requirements, data cleansing rules, and field-level validation.
Develop scripts, Extract Transform Load (ETL) routines, and data conversion programs to transform legacy data into ERP compatible formats.
Collaborate with Test Lead and functional leads to design and execute unit, system integration and user acceptance testing for all data conversion activities.
Develop and maintain test cases and scripts related to data loads and post data load activities.
Coordinate with business subject matter experts (SME), Test Lead and external system integrator teams to validate converted data for completeness, accuracy and compliance with functional requirements.
Develop python scripts to clean and convert data 1 of 3
Create and maintain data validation and reconciliation procedures to ensure accuracy and integrity post load.
Support mock loads, data dress rehearsals, cutover activities, including error resolution and root cause analysis.
Document all mapping logic, transformation rules, exceptions, test results and reconciliation outcomes.
Support data governance efforts by identifying data quality issues and collaborating on remediation effort. As well as defining data attributes and data domains during conversion exercise with business SME and external system integrator.
Maintain documentation enabling IT staff to provide end-user support and training.
Research emerging technologies, tools, frameworks, and methodologies to enhance system performance and security.
Job Requirements
Knowledge, Abilities and Skills
Excellent oral and written communication skills, including the ability to explain technology solutions in business terms, establish rapport, influence others, negotiate and mediate resolutions to complex situations.
Excellent analytical skill
About the Company
Surrey Schools (School District #36) operates schools in Surrey and White Rock, British Columbia. It is the largest school district in British Columbia with approximately 77,000 students. Surrey Schools includes 103 elementary schools, 21 secondary schools, five student learning centres, three adult education centres and a variety of other programs serving a wide range of specific student needs. The district is Surrey's largest employer with about 12,000+ employees, including more than 6,000 teachers.
Know more