Data Architect

ic and technical leadership to a team of 4–10 data professionals and ensure the successful migration and integration of data from over 20 legacy systems. The position requires deep expertise in ETL design and implementation, automated scripting for data validation, and end-to-end data reconciliation using tools such as SQL (Oracle, MS SQL Server), MS Access, and modern data formats (JSON, CSV, spreadsheets). You’ll work closely with internal stakeholders, delivery teams, and a SaaS implementation partner to develop and execute a comprehensive data migration strategy. Ideal candidates will have at least 8 years of hands-on data migration experience, 4 years in a team leadership capacity, and a proven track record of working on large-scale enterprise transformation projects. Experience with cloud-based SaaS implementations, Master Data Management, and Data Governance is a strong asset. If you're looking to bring your expertise to a high-profile initiative that will modernize critical services for an entire province, we encourage you to apply.

*** 18 month contract to start ***

Advantages
Location Flexibility: Remote work is possible with very limited travel to Fredericton, offering flexibility for candidates.


Responsibilities
•Lead a data team of 4–10 technical professionals.
•Supervise internal and external resources involved in data migration.
•Collaborate with delivery teams, subject matter experts, and the SaaS implementation partner.
•Act as the primary point of contact for all data-related activities across functional teams and stakeholders.
•Develop and validate the data migration strategy and gain approval from stakeholders.
•Create detailed data migration plans, including timelines, resource allocation, and risk mitigation.
•Maintain an inventory of legacy data and file assets.
•Identify and document data migration requirements and business rules.
•Ensure alignment of all data migration activities with project milestones and business goals.
•Design and implement ETL processes for extracting, transforming, cleansing, and loading data from over 20 legacy systems.
•Write and execute automated scripts for large-scale data processing, validation, and reconciliation.
•Ensure the accuracy, completeness, and integrity of all migrated data.
•Establish data governance practices specific to the project lifecycle.
•Define and implement performance indicators and quality metrics.
•Identify data stewards and trustees across involved domains and support their engagement.

Qualifications
•Bachelor’s degree in Computer Science, Information Technology, or a related field.
•8+ years in information management or related field.
•8+ years of hands-on technical experience in ETL (Extract, Transform, Load) processes, including extracting and provisioning data from various legacy systems.
•8+ years of experience using SQL in Oracle, MS SQL Server, and MS Access environments.
•8+ years creating automated scripts for data testing and analysis to validate accuracy and integrity of migrated data.
•4+ years leading technical teams on complex data migration and cleansing projects in large enterprises, including end-to-end delivery.

Scored (Preferred) Qualifications

•Full-cycle data migration analysis (discovery, mapping, extraction, cleansing, loading).
•Problem-solving and critical thinking within large-scale data migration projects.
•Handling a wide range of data formats (e.g., database extracts, Excel, JSON, CSV, etc.).
•Master Data Management (MDM), Data Governance, and Data Protection practices.
•Working in both collaborative and autonomous team environments.
•Participating in or leading at least one cloud SaaS implementation involving significant business transformation and complex data conversion (an asset).


Summary
If you are qualified and interested we encourage you to apply for this exciting opportunity!

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.