Senior application developer etl Jobs

Senior Data Integration Lead (12-Month Contract)
Sunrise Farms —Surrey, BC
- $75–$90 an hour
- Contract
- Microsoft Excel
- Azure
- ERP systems
Quick apply
10h
Data Integration Developer (12-Month Hourly Contract)
Sunrise Farms —Surrey, BC
- $60–$70 an hour
- Contract
- Azure
- ERP systems
- SQL
Quick apply
10h
25-199 - Data Engineer - Azure Databricks - 11 month contract - Oshawa - Hybrid remote
CorGTA —Oshawa, ON
- $72–$90 an hour
- Contract
- Hybrid work
- Computer science
- Azure
- Computer Science
Data, Analytics & AI Lead
Forthright Properties —Winnipeg, MB
- Full-time
- Azure
- Computer Science
- Engineering
7d
Data Architect
AtkinsRéalis —Toronto, ON
- $93,800–$129,000 a year
- Full-time
- Hybrid work
- Azure
- Computer Science
- DevOps
Senior Software Engineer
Fleetworthy —Edmonton, AB
- Remote
- Azure
- DevOps
- SQL
Quick apply
1d
Programmer Analyst I
UBC Faculty of Forestry —Vancouver, BC
- $6,949.92–$9,992.50 a month
- Full-time
- Azure
- AWS
- Bachelor's
1d
Staff Software Engineer
RB Global —Vancouver, BC
- $106,090–$132,615 a year
- Full-time
- Computer Science
- Java
- SQL
- Dental care
- Paid time off
Quick apply
13d
Specialist – IT Apps Dev
Parkland —Calgary, AB
- Full-time
- Computer Science
- SQL
- Bachelor's
Quick apply
4d
Senior Data Engineer
Lime —Canada
- $136,000–$187,000 a year
- Full-time
- Remote
- Computer Science
- Engineering
- Master's degree
Quick apply
5d
Senior Full-Stack Developer
AOT Technologies —Victoria, BC
- $100,000–$115,000 a year
- Remote
- Azure
- Computer Science
- CAD
- Profit sharing
- Dental care
Quick apply
16h
Senior Data Engineer
OMERS —Toronto, ON
- $86,000–$130,000 a year
- Full-time
- Hybrid work
- Azure
- Computer Science
- Engineering
16h

More jobs to discover

Find similar jobs that you might be interested in.

Data Integration Developer (12-Month Hourly Contract)
Sunrise Farms —Surrey, BC
3–5+ years of SQL Server development, data integration, BI development, or business systems analysis experience. Data Mapping, Validation & Reconciliation.
$60–$70 an hour
Quick apply
10h
Senior Data Integration Lead (12-Month Contract)
Sunrise Farms —Surrey, BC
Review and approve design decisions, technical specifications, and development outputs from junior resources, internal team members, and external implementation…
$75–$90 an hour
Quick apply
10h

Show more similar jobs

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

25-199 - Data Engineer - Azure Databricks - 11 month contract - Oshawa - Hybrid remote
CorGTA —Oshawa, ON
Will employ best practice in development, security, and accessibility and design to achieve the highest quality of service for our customers.
$72–$90 an hour

I want to receive the latest job alerts for senior application developer etl

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

senior application developer etl jobs near

Programmer Analyst jobs in Vancouver, BC

IT Technician jobs in Calgary, AB

Senior Software Engineer jobs in Edmonton, AB

Data Architect jobs in Toronto, ON

Full Stack Developer jobs in Victoria, BC

Shift Leader jobs in Winnipeg, MB

Data Engineer jobs in Toronto, ON

Staff Software Engineer jobs in Vancouver, BC

Programmer Analyst jobs in Montréal, QC

It Analyst jobs in Toronto, ON

Business Analyst jobs in Mississauga, ON

Programmer Analyst jobs in Halifax, NS

Analyst jobs in Halifax, NS

Programmer Analyst jobs in York University (keele Campus), ON

Entry Level Business Analyst jobs in Vancouver, BC

Programmer Analyst jobs in New Brunswick

Payroll Specialist jobs in Vancouver, BC

Data Integration Specialist jobs in Montréal, QC

Customer Support Specialist jobs in Toronto, ON

Data Management jobs in Vancouver, BC

Senior Data Integration Lead (12-Month Contract)

Sunrise Farms -
Surrey, BC

Quick apply

Job details

Contract
$75–$90 an hour
10 hours ago

Qualifications

Power BI
Data modeling
Microsoft Excel
Azure
Business intelligence
Food processing
ERP systems
Microsoft SQL Server
SSRS
SQL
Data management
Manufacturing
Communication skills
Data warehouse
T-SQL

Full job description

Position Summary:

Sunrise Farms is seeking a Senior Data Integration Lead (12-mont 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 be part of the Data Foundations Project Team and will lead the design, development, and delivery of the interim data integration solution required to support the phased rollout of the new Syspro ERP.

The primary focus of this role is to design and oversee the development of data pipelines that move data from the new Syspro Replica environment into the existing legacy reporting environment. This interim solution is required so that existing operational, financial, SSRS, Vivid, Excel, and Power BI reports continue to function during the plant-by-plant ERP transition.

This role will provide technical leadership and oversee the work of other data specialists, coordinate with internal resources and external implementation partners, and ensure the solution is reliable, scalable, well-documented, and aligned with Sunrise Farms’ needs.

Over time, this role will work with our implementation partner on our future state Snowflake-based Medallion Architecture.

High-performing contractors will be considered for future full-time opportunities as Sunrise Farms establishes its internal Data Management team.

Key Responsibilities:

1. Solution Design & Technical Leadership

Lead the design of data pipelines to extract data from the Syspro Replica SQL Server environment and load it into our 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.

2. Data Pipeline Development & Oversight

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, which is specifically identified as a key responsibility in the deck.

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, as identified under infrastructure and connectivity responsibilities.

3. Reporting Continuity & Data Quality

Ensure compatibility with existing operational, financial, SSRS, Vivid, and Power BI reporting environments, as outlined in the deck.

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, which is called out directly in the deck’s data management responsibilities.

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.

4. Infrastructure, Connectivity & Production Readiness

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.

5. Partner, Team & Resource Oversight

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.

6. Documentation, Governance & Future-State Readiness

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, all of which are specifically referenced in the deck.

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.

Required Qualifications

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.

Preferred Qualifications

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.

Key Deliverables

The Senior Data Integration Lead will be accountable for ensuring delivery of:

Replica legacy SQL environment integration architecture.

Production-ready 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.

Technical oversight of junior, internal, and external delivery resources.

#LI-SP1

#INDHP

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Quick apply

Refine Your Search

Senior Data Integration Lead (12-Month Contract)

Data Integration Developer (12-Month Hourly Contract)

25-199 - Data Engineer - Azure Databricks - 11 month contract - Oshawa - Hybrid remote

Data, Analytics & AI Lead

Data Architect

Senior Software Engineer

Programmer Analyst I

Staff Software Engineer

Specialist – IT Apps Dev

Senior Data Engineer

Senior Full-Stack Developer

Senior Data Engineer

More jobs to discover

Explore jobs in cities nearby

I want to receive the latest job alerts for senior application developer etl

Related Searches

Explore jobs in more locations

Job seeker tools

Employer Tools

Browse

Stay Connected