Data Conversion and Reporting Developer

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.

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

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 skills, the ability to manage multiple priorities under strict timelines, as well as the ability to work well in a dynamic environment to meet overall objectives.

Thorough working knowledge of various Microsoft…