Integration engineer • surrey bc
Sunrise Farms is seeking a Data Integration Developer (12-Month Hourly Contract) to join the Reset & Restart (R&R) Program on a 12-month hourly contract.R&R is a large-scale digital transformation ... Show more
AECOM Buildings + Places is seeking a motivated.This role will focus on the design and delivery of building systems for a variety of projects, with an emphasis on light industrial facilities, inclu... Show more
Photonic is part of the Spin‑Photon Qubit System Performance team.Leveraging your technical skills in quantum engineering, curiosity, and synthetic thinking, you will make technical decisions quick... Show more
A career in transportation is more than bridges, roads, and rail.As we plan, design, and manage projects that move people and goods from Point A to Point B, we create connections that transform our... Show more
D-Wave is a leader in the development and delivery of quantum computing systems, software, and services.It is the world’s first commercial supplier of quantum computers, and the first and only to o... Show more
Peter Lucas Project Management invests in people, community, and cutting-edge technology to provide gold standard project delivery.We are currently looking for a Project Field Engineer to join our ... Show more
Process Engineer At TWD , we know the secret to success isn’t just technical skill, it’s the people behind it.That’s why we hire for attitude first.If you’re collaborative, ... Show more
LMI is seeking a talented Senior Hardware (FPGA) engineer to join a multi-disciplinary engineering team.The successful candidate will have a proven record in developing complex FPGA code for an emb... Show more
We are seeking an Integration & Applications Specialist to join our IT team.This is a newly established and evolving role that supports both our internal teams and our national franchise network ac... Show more
Are you a Maintenance Engineer with adequate experience in the filed? This 12-months role with chances of extension can be a good fit for you.The E3 – Engineer is a fully qualified and accredited e... Show more
Industrial Controls, PLC/HMI & Microwave Processing Equipment.NuWave Research develops industrial microwave systems used in drying, thermal processing, material treatment, and other advanced in... Show more
The E4 – Engineer is a professional engineer or geoscientist who applies engineering knowledge to provide engineering, estimating, planning, and quality management services for medium complexity pr... Show more
Printing Company that has achieved excellence for over 50 years and is headquartered at our 63,000 square-foot facility in Coquitlam, British Columbia.A privately-owned and operated company, we mak... Show more
At Red Rabbit Robotics, we are on a mission to solve global labor shortage and create a future of abundance.We aim to deploy one million humanoid robots in the next 10 years, eventually producing a... Show more
Adecco is currently hiring a full-time.This is an exciting opportunity for an innovative software engineer with expertise in embedded systems, Linux development, AI technologies, and multimedia fra... Show more
The Engineering Service Business Unit focuses on power system software development, power system and substation consulting studies and compliance testing services for electric utilities and other c... Show more
JRS Engineering (JRS) is an industry-leading engineering firm providing professional consulting services throughout Western Canada.Since 1997, we have remained committed to delivering best-in-class... Show more
Alberta based company specializing in engineering, design, and testing / commissioning of high voltage electrical facilities.Our focus is to incorporate the latest technological advances, such as I... Show more
Reporting to the Manager, Business Applications Development or Manager, Data Analytics and Integration, the BI and Data Integration Developer is responsible for designing and developing data analyt... Show more
While this is a project-based contract, there is a possibility of a permanent hire for the right candidate.Design and develop electrical drawings for electrical systems on marine vessels, including... Show more
Position Summary
Sunrise Farms is seeking a Data Integration Developer (12-Month Hourly Contract) to join the Reset & Restart (R&R) Program on a 12-month hourly contract. R&R is a large-scale digital transformation initiative that implements our new Syspro ERP among other enterprise solutions. This role will support the Data Foundations Project Team by developing, testing, documenting, and supporting the interim data integration solution that loads data from the new Syspro Replica environment into the legacy SQL reporting environment.
The role will work under the direction of the Senior Data Integration Lead and the Data Foundations Project Manager and will help build the ELT/ETL pipelines, SQL logic, mapping tables, validation reports, and documentation required to maintain reporting continuity during the phased rollout of the new Syspro ERP.
Over time, this role will also work with our implementation partner on our future state Snowflake-based Medallion Architecture.
In addition to data engineering responsibilities, the role will support Power BI report development, and other business systems analysis activities related to R&R. This position offers a unique opportunity to contribute to a major enterprise transformation while helping establish Sunrise Farms' future data ecosystem.
High-performing candidates will be considered for a permanent position on our future data management team, which will be established at the end of the project.
Key Responsibilities
1. Data Pipeline Development
Develop data pipelines to extract data from the Syspro Replica SQL Server environment and load it into our legacy SQL Server Data Warehouse.
Build and maintain ETL/ELT processes for incremental and near real-time data synchronization, reflecting the responsibilities listed in the deck.
Develop SQL transformation logic, cross-reference tables, and mapping frameworks.
Support updates to legacy stored procedures, views, and reporting structures to support new Syspro data.
Assist with pipeline testing, troubleshooting, performance tuning, and refresh validation.
2. Data Mapping, Validation & Reconciliation
Support Product, Customer, Supplier, and Company mapping logic between legacy and new Syspro environments.
Build and maintain data validation and reconciliation processes.
Investigate data discrepancies and support issue resolution.
Maintain data integrity and auditing capabilities across environments
Support historical data consolidation requirements.
3. Reporting & Analytics Support
Help ensure compatibility with existing operational, financial, SSRS, Vivid, and Power BI reporting environments.
Update or build Power BI reports and dashboards as required.
Support reporting validation during ERP rollout activities.
Work with stakeholders to understand reporting issues, data gaps, and enhancement requests.
Assist with future-state report/KPI analysis and documentation.
4. Infrastructure & Operational Support
Work with Infrastructure and senior technical resources to support secure connectivity between Azure-hosted Replica environments and on-premises legacy environments.
Help design and maintain monitoring and error-handling mechanisms.
Support optimization of pipeline performance and refresh frequencies to meet business reporting requirements.
Assist with issue tracking, defect resolution, and operational support during plant go-lives.
5. Documentation & Business Systems Analysis
Document data flows, business rules, transformation logic, and mapping structures.
Create or maintain technical documentation, support guides, runbooks, and operational procedures.
Capture business logic currently implemented in the legacy SQL reporting environment to support future Snowflake Bronze, Silver, and Gold layer design.
Assist with requirements gathering, process documentation, testing support, and stakeholder follow-up.
Support UAT, data validation, and reporting cutover activities as required.
Required Qualifications
3–5+ years of SQL Server development, data integration, BI development, or business systems analysis experience.
Strong SQL Server and T-SQL skills.
Experience developing or supporting ETL/ELT processes.
Experience with stored procedures, views, indexing, and query performance tuning.
Experience with data integration and enterprise reporting platforms, which is listed as a required qualification in the deck.
Understanding of data modeling and master data management principles.
Experience troubleshooting data quality and reconciliation issues.
Ability to work with cross-functional business and technical stakeholders.
Strong documentation, analytical, and problem-solving skills.
Preferred Qualifications
Syspro ERP experience.
Experience with ERP migration projects.
Experience in manufacturing, distribution, or food processing operations.
Exposure to Azure data services, Snowflake, Fivetran, and Power BI.
Understanding of Medallion Architecture, including Bronze, Silver, and Gold layers.
Experience supporting operational, financial, or manufacturing reporting.
Experience with data validation, reconciliation reporting, and business stakeholder support.
Key Deliverables
The Data Integration Developer will contribute to:
Production-ready Replica → legacy SQL environment data pipelines.
Master data cross-reference and mapping framework.
Monitoring, logging, and error-handling processes.
Technical and operational documentation.
Data reconciliation and validation reports.
Knowledge transfer and support documentation.
Updated or newly created Power BI reports, where required.
