Senior Data Integration Lead (12-Month Contract)

Sunrise Farms•Surrey, BC

7d•CA$75 - CA$90

About The Position

Sunrise Farms is seeking a Senior Data Integration Lead for a 12-month hourly contract position as part of the Reset & Restart (R&R) Program. The R&R program is a large-scale digital transformation initiative implementing a new Syspro ERP and other enterprise solutions. This role will be on the Data Foundations Project Team and will lead the design, development, and delivery of an interim data integration solution. This solution is crucial for supporting the phased rollout of the new Syspro ERP by ensuring existing operational, financial, SSRS, Vivid, Excel, and Power BI reports continue to function. The primary focus is designing and overseeing the development of data pipelines to move data from the new Syspro Replica environment into the existing legacy reporting environment. The role will also involve technical leadership, coordination with internal resources and external partners, and ensuring the solution is reliable, scalable, well-documented, and aligned with Sunrise Farms’ needs. Over time, this role will collaborate on a future state Snowflake-based Medallion Architecture. High-performing contractors may be considered for future full-time opportunities as Sunrise Farms builds its internal Data Management team.

Requirements

7+ years of experience in SQL Server development, data integration, data engineering, business intelligence, or related technical roles.
Experience leading or overseeing technical resources, developers, consultants, or implementation partners.
Strong hands-on experience with SQL Server, T-SQL, stored procedures, views, indexing, and performance tuning.
Strong ETL/ELT design and development experience.
Experience designing enterprise data integration solutions.
Experience with reporting environments and business-critical reporting continuity.
Strong understanding of data modeling and master data management concepts.
Experience troubleshooting data quality, reconciliation, and reporting issues.
Ability to work effectively with cross-functional business and technical stakeholders.
Strong communication, documentation, and problem-solving skills.

Nice To Haves

Syspro ERP experience.
Experience with ERP migration or ERP rollout projects.
Experience in manufacturing, distribution, food processing, or related operational environments.
Experience with Azure data services, Snowflake, Fivetran, and Power BI exposure.
Understanding of Medallion Architecture, including Bronze, Silver, and Gold layers.
Experience designing data quality, reconciliation, and operational monitoring frameworks.
Experience supporting future-state data platform or analytics modernization initiatives.

Responsibilities

Lead the design of data pipelines to extract data from the Syspro Replica SQL Server environment and load it into the legacy SQL reporting environment.
Define the technical approach for extracting data from the Syspro Replica environment and loading it into the legacy SQL reporting environment.
Establish development standards for ELT/ETL pipelines, SQL logic, reconciliation, monitoring, error handling, and documentation.
Review and approve design decisions, technical specifications, and development outputs from junior resources, internal team members, and external implementation partners.
Ensure that the interim solution supports reporting continuity while avoiding unnecessary rework or misalignment with the future Snowflake architecture.
Design and oversee development of pipelines that extract data from the Syspro Replica environment and load it into the legacy SQL reporting environment.
Lead development of ETL/ELT processes for incremental and near real-time data synchronization.
Guide the development of data transformation logic, cross-reference tables, and mapping frameworks.
Oversee extension of existing legacy SQL stored procedures, views, and reporting structures to support new Syspro data.
Ensure pipeline performance and refresh frequencies meet business reporting requirements.
Ensure compatibility with existing operational, financial, SSRS, Vivid, and Power BI reporting environments.
Lead the design of validation and reconciliation processes to ensure data completeness and accuracy.
Oversee Product, Customer, Supplier, and Company mapping logic between legacy and new Syspro environments.
Ensure master data cross-reference and mapping frameworks are properly designed, documented, tested, and supportable.
Support historical data consolidation requirements and maintain data integrity and auditing capabilities across environments.
Collaborate with IT Infrastructure to establish secure connectivity between Azure-hosted Replica environments and on-premises legacy SQL reporting environment.
Define monitoring, logging, alerting, and error-handling requirements.
Ensure the solution is production-ready, supportable, and capable of sustaining business reporting during ERP rollout.
Identify technical risks, dependencies, design gaps, and support requirements.
Coordinate issue resolution across Business Systems, Infrastructure, Data Foundations, ERP stakeholders, and implementation partners.
Provide day-to-day technical direction to Data Integration Developers and Data Analysts.
Oversee work performed by internal Sunrise Farms resources and external implementation partners.
Review partner deliverables and ensure they align with Sunrise Farms’ interim and future-state data architecture.
Support knowledge transfer from external partners to internal resources.
Contribute to onboarding, coaching, and future internal data team capability-building.
Ensure complete documentation of data flows, business rules, transformation logic, mapping structures, and technical design.
Oversee creation of technical design documents, support guides, runbooks, and operational documentation.
Ensure business logic currently implemented in the legacy SQL reporting environment is documented to support future Snowflake Bronze, Silver, and Gold layer design.
Support future Medallion Architecture planning by ensuring that interim work captures the business rules and mapping logic needed for Snowflake migration.
Help define support readiness criteria for the eventual transition to Sunrise Farms’ internal Data Management team.