Data • new westminster 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 is in need of a Project Controls to join our team in Burnaby, BC in a full-time new hybrid position.Works with company financial systems and processes.Develops proficiency in the use of compa... Show more
This is a freelance, on-site position where you'll support critical infrastructure at world-class data center facilities.Comprehensive benefits package including:.Health, dental, and vision insuran... Show more
Infosys is seeking an Technology Lead - Azure Databricks - Data Engineer.In this role, you will enable digital transformation for our clients in a global delivery model, research on technologies in... Show more
Evaluate outputs from AI models, text, images, video, and documents against detailed criteria.Assess quality, spot errors and inconsistencies, and write clear, well-reasoned justifications for your... Show more
Evaluate outputs from AI models, text, images, video, and documents against detailed criteria.Assess quality, spot errors and inconsistencies, and write clear, well-reasoned justifications for your... Show more
MatchBox is urgently seeking a Functional Analyst / Business Analyst for a 12 month contract role for our New Westminster based public sector client.This is a hybrid role 2 days in office and 3 day... Show more
Employment Status: Full-Time Temporary.Short-term Incentive Eligible: No .Posting End Date: Open until filled.As the province’s largest energy provider with more than 100 years of knowledge and exp... Show more
TrendTex Fabrics and Winbourne Fabrics are leading Wholesale Distributors serving independent retailers in the quilting and home sewing markets across Canada and the UK.Our teams work closely with ... Show more
Data Entry Specialist (Medical Records).Shift: 7:00 AM – 3:30 PM, 5 days a week.Type: Full-time (9-hour days, includes a 30-min lunch + two 15-min breaks).Are you fast on a keyboard, detail-oriente... Show more
Program Data and Quality Support Coordinator.Regular, full time (Union position).This position requires availability for at least two days per week, Monday to Friday, for either morning shifts (8:3... Show more
Metro Vancouver’s business sector as the go-to agency for the recruitment and placement of outstanding employees.BC-owned and operated, we ensure all our candidates — temporary, contract, permanent... Show more
This role requires a strong background in.AI/ML model development, security data analysis, and software engineering.Lead the development and integration of.AI/ML initiatives with business and produ... Show more
LMI is seeking a forward-thinking HRIS Specialist (internal titles of People Operations & Systems Specialist) to join the global HR team.This role provides the critical digital and operational ... Show more
Photonic you will provide tactical support to the Procurement function by managing day-to-day purchasing activities, supplier coordination, procurement data, and process improvements that help the ... Show more
Healthcare, Health Tech, Government, Municipalities, Non-Profits, Legal, Public Accounting, Food and more.We are proactively building a data bank for opportunities in these fields.By applying, you ... Show more
Our client is a leading Canadian digital infrastructure organization with a strong presence in Vancouver and across major Canadian markets.They support businesses andmunities through providing miss... Show more
GENERAL SUMMARY<br><br>Responsible for performing the clerical and administrative functions for any or all hub and station operational areas, including linehaul, records management, qua... Show more
MatchBox Consulting is urgently seeking a Software Development Analyst for a 14 month contract with our New Westminster based public sector client.This is a hybrid role (2 days on site and 3 days r... Show more
As a Co-op Business Systems Analyst, you will support Latecoere’s IT Applications team in ensuring our business applications and data services enable efficient, modern manufacturing.In this role, y... 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.
