Please note that we will never request payment or bank account information at any stage of the recruitment process. As we continue to grow our teams, we urge you to be cautious of fraudulent job postings or recruitment activities that misuse our company name and information. Please protect your personal information during any recruitment process. While Monks may contact potential candidates via LinkedIn, all applications must be submitted through our official website (monks.com/careers).
About the Role
As a Data Engineer, you will handle the end-to-end data migration lifecycle—evaluating source systems, designing transformation rules, building ETL pipelines, and verifying data quality before final load. You will collaborate directly with business data owners and other technical teams to facilitate secure, controlled data transfers and ensure a seamless transition to the new NetSuite environment.
Responsibilities:
Data Analysis and Assessment: Evaluate source data systems to identify data structures, uncover potential quality issues, and determine data cleansing needs.
Data Mapping and Transformation: Create mapping rules to accurately translate fields from source systems to NetSuite, removing duplicates, fixing errors, and applying target system formatting.
Data Migration Planning: Develop comprehensive migration plans—including timelines, testing procedures, and contingency strategies—to ensure a smooth, auditable migration process.
ETL Pipeline Management: Build and maintain CDATA pipelines and other ETL processes to efficiently transfer data between systems.
Validation and Troubleshooting: Perform thorough data validation to ensure data integrity post-migration; troubleshoot and resolve migration issues with innovative, scalable solutions.
Documentation: Maintain detailed records of data mappings, transformation rules, and any encountered issues to facilitate clear communication and future auditability.
Stakeholder Communication: Collaborate with project teams, business owners, and technical staff to gather requirements, address concerns, and provide timely updates. Present complex ideas in accessible language for non-technical stakeholders.
About You
The essentials:
Proficiency with large-volume ETL processes, SQL Server, and CDATA pipelines.
Strong finance and accounting data knowledge, with the ability to cleanse, reconcile, and ensure accuracy.
Demonstrated experience with data migration—including discovery, mapping/translating, validation, and rollback strategies.
Ability to collaborate with business data owners to extract legacy data, validate and transform it, facilitate stakeholder signoff, and correct any data issues when needed.
Not a must, but a plus:
Excellent communication skills, including the ability to work with business SMEs to confirm requirements, highlight data integrity concerns, and minimize back-and-forth Q&A.
Monks has provided a compensation range that represents its good faith estimate of what Monks may pay for the position at the time of posting. Monks may ultimately pay more or less than the posted compensation range. The salary offered to the selected candidate will be determined based on job-related factors, but not based on a candidate’s sex or any other protected status.
Salary Range
$140,000—$180,000 CAD
About Monks
Monks is the global, purely digital, unitary operating brand of S4Capital plc. With a legacy of innovation and specialized expertise, Monks combines an extraordinary range of global marketing and technology services to accelerate business possibilities and redefine how brands and businesses interact with the world. Its integration of systems and workflows delivers unfettered content production, scaled experiences, enterprise-grade technology and data science fueled by AI—managed by the industry’s best and most diverse digital talent—to help the world’s trailblazing companies outmaneuver and outpace their competition.
Monks was named a Contender in The Forrester Wave™: Global Marketing Services. It has remained a constant presence on Adweek’s Fastest Growing lists (2019-23), ranks among Cannes Lions' Top 10 Creative Companies (2022-23) and is the only partner to have been placed in AdExchanger’s Programmatic Power Players list every year (2020-24). In addition to being named Adweek’s first AI Agency of the Year (2023), Monks has been recognized by Business Intelligence in its 2024 Excellence in Artificial Intelligence Awards program in three categories: the Individual category, Organizational Winner in AI Strategic Planning and AI Product for its service Monks.Flow. Monks has also garnered the title of Webby Production Company of the Year (2021-24), won a record number of FWAs and has earned a spot on Newsweek’s Top 100 Global Most Loved Workplaces 2023.
We are an equal-opportunity employer committed to building a respectful and empowering work environment for all people to freely express themselves amongst colleagues who embrace diversity in all respects. Including fresh voices and unique points of view in all aspects of our business not only creates an environment where we can all grow and thrive but also increases our potential to produce work that better represents—and resonates with—the world around us.
