Job descriptionA public sector organization is seeking an experienced ETL Developer (SSIS) to support a large-scale enterprise ERP transformation initiative. The role focuses on data migration, integration, and transformation activities, enabling the successful transition from legacy systems to a modern cloud-based ERP platform.
The successful candidate will work closely with the data migration team, architects, and technical leads to design, develop, and maintain SSIS packages that support enterprise-wide data transformation and analytics. This is a critical role in ensuring data accuracy, integrity, and availability across HR, finance, and procurement domains.
Advantages
Contribute to a multi-year ERP transformation program impacting enterprise-wide operations
Work with modern cloud ERP (Oracle SaaS) and large-scale data migration initiatives
Opportunity to design and implement enterprise data pipelines and ETL solutions
Collaborate with cross-functional teams including business SMEs, architects, and implementation partners
Long-term engagement (2 years + extension options) with strong project stability
Work in a collaborative, high-impact environment focused on data-driven decision making
Responsibilities
ETL Development & Data Migration
Design, develop, test, and deploy SSIS packages for data migration activities
Perform Extract, Transform, Load (ETL) processes to migrate data from legacy systems to enterprise platforms
Develop and maintain data transformation logic and workflows
Data Analysis & Solution Design
Analyze functional and technical requirements and translate them into data transformation solutions
Work with architects and technical leads to clarify specifications and implement business logic
Develop data views and data structures to support reporting and analytics
ERP Transformation Support
Support enterprise ERP data migration strategy using SSIS as the primary tool
Contribute to data cleansing, validation, and transformation activities
Ensure data integrity and consistency across systems during migration
Collaboration & Delivery
Work collaboratively with data migration teams, business stakeholders, and implementation partners
Participate in defect triage meetings and troubleshooting activities
Contribute to a team-oriented environment supporting continuous improvement and adoption of new processes
Governance & Best Practices
Adhere to developer technical standards and guiding principles
Maintain version control and documentation for SSIS packages
Ensure compliance with data governance, privacy, and security requirements
Qualifications
ETL Development & Data Migration
Design, develop, test, and deploy SSIS packages for data migration activities
Perform Extract, Transform, Load (ETL) processes to migrate data from legacy systems to enterprise platforms
Develop and maintain data transformation logic and workflows
Data Analysis & Solution Design
Analyze functional and technical requirements and translate them into data transformation solutions
Work with architects and technical leads to clarify specifications and implement business logic
Develop data views and data structures to support reporting and analytics
ERP Transformation Support
Support enterprise ERP data migration strategy using SSIS as the primary tool
Contribute to data cleansing, validation, and transformation activities
Ensure data integrity and consistency across systems during migration
Collaboration & Delivery
Work collaboratively with data migration teams, business stakeholders, and implementation partners
Participate in defect triage meetings and troubleshooting activities
Contribute to a team-oriented environment supporting continuous improvement and adoption of new processes
Governance & Best Practices
Adhere to developer technical standards and guiding principles
Maintain version control and documentation for SSIS packages
Ensure compliance with data governance, privacy, and security requirements
Summary
The successful candidate will work closely with the data migration team, architects, and technical leads to design, develop, and maintain SSIS packages that support enterprise-wide data transformation and analytics. This is a critical role in ensuring data accuracy, integrity, and availability across HR, finance, and procurement domains.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
