Data Conversion and Reporting Developer
Top Benefits
About the role
The Surrey School District respectfully acknowledges that our schools reside on the traditional, unceded, and shared territories of Coast Salish peoples: The q̓ ícə̓ y̓ - Katzie, the qʼwa:n̓ƛʼə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 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 applications, including the M365 suite of applications (Project, Planner, Teams, and Visio).
- Experience with data and development tools such as SQL Server, Power BI, Power Query, PowerShell.
- Previous experience in translating functional reporting requirements into technical solutions
- Experience in creating interactive dashboards, data extracts and formatted output for finance, HR/Payroll, and procurement users
- Advanced knowledge of Excel worksheets, that will be used to develop data mappings. 2 of 3
- Strong SQL skills and experience working with relational database.
- Strong experience with python programming and use of various python data packages
- Experience in developing and executing test plans, test case and system reconciliation reports for ERP data migration.
Training and Experience
-
Bachelor’s degree in Computer Science, Computer Information Systems or related engineering field (STEM)
Minimum of five years of experience in IT of which a minimum three years experience in an ERP system
This is a unionized position that offers an hourly wage rate of $ 40.97 per hour plus a liberal benefit package including pension, health, vacation, and sick benefits. Please note that as this is a new position, the pay rate is subject to review and potential adjustment after six months.
Qualified applicants can apply by clicking the "apply" button to the right of the posting. The closing date for this position is Friday, October 31, 2205 at 4:00pm.
Surrey Schools recognizes the importance of accessibility and supporting the diverse needs of our community. If there is any accommodation you may require for your interview, whether related to accessibility or otherwise, please do not hesitate to advise and we will make every effort to meet your needs.
Note: Successful applicants will be required to consent to a Criminal Records Search prior to employment. Only those applicants selected for interviews will be contacted. To all others, thank you for your interest.
Data Conversion and Reporting Developer
Top Benefits
About the role
The Surrey School District respectfully acknowledges that our schools reside on the traditional, unceded, and shared territories of Coast Salish peoples: The q̓ ícə̓ y̓ - Katzie, the qʼwa:n̓ƛʼə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 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 applications, including the M365 suite of applications (Project, Planner, Teams, and Visio).
- Experience with data and development tools such as SQL Server, Power BI, Power Query, PowerShell.
- Previous experience in translating functional reporting requirements into technical solutions
- Experience in creating interactive dashboards, data extracts and formatted output for finance, HR/Payroll, and procurement users
- Advanced knowledge of Excel worksheets, that will be used to develop data mappings. 2 of 3
- Strong SQL skills and experience working with relational database.
- Strong experience with python programming and use of various python data packages
- Experience in developing and executing test plans, test case and system reconciliation reports for ERP data migration.
Training and Experience
-
Bachelor’s degree in Computer Science, Computer Information Systems or related engineering field (STEM)
Minimum of five years of experience in IT of which a minimum three years experience in an ERP system
This is a unionized position that offers an hourly wage rate of $ 40.97 per hour plus a liberal benefit package including pension, health, vacation, and sick benefits. Please note that as this is a new position, the pay rate is subject to review and potential adjustment after six months.
Qualified applicants can apply by clicking the "apply" button to the right of the posting. The closing date for this position is Friday, October 31, 2205 at 4:00pm.
Surrey Schools recognizes the importance of accessibility and supporting the diverse needs of our community. If there is any accommodation you may require for your interview, whether related to accessibility or otherwise, please do not hesitate to advise and we will make every effort to meet your needs.
Note: Successful applicants will be required to consent to a Criminal Records Search prior to employment. Only those applicants selected for interviews will be contacted. To all others, thank you for your interest.