Jobs / Canada / Sunrise Farms Limited

Sunrise Farms Limited

Business Systems Technical Analyst

Surrey, BC Posted 1 month ago

Apply on employer site ↗ Tailor my CV first Source: Company careers site

Optional: we can tailor a CV and cover letter for this job from your real experience first (the first one is free).

Skills this job asks for

SQLWarehouse operationsREST APIsSupply chainAzure

Add your CV (free) to see which of these your CV is missing.

Sponsorship verdict

Sponsorship possible

One solid signal, not two. Worth applying, and worth asking about sponsorship early.

  • Employer is on a government sponsor recordThis employer appears on Canada’s positive-LMIA employer list.
  • The posting doesn’t mention sponsorshipSilence isn’t a refusal — ask the recruiter before investing much time.
  • No salary bar for this routeCanada has no single salary bar: the employer usually needs a positive LMIA.
  • Confirmed live todayWhen a source last listed this job as open.
Details and sources
Employer is on a government sponsor record
This employer appears on Canada’s positive-LMIA employer list. Source: Positive LMIA employer list (Employment and Social Development Canada).
No salary bar for this route
Canada has no single salary bar: the employer usually needs a positive LMIA. Pay at or above the provincial median wage + 20% (e.g. C$36.92/h in Ontario) puts it in the high-wage stream. Source: https://www.canada.ca/en/employment-social-development/services/foreign-workers/median-wage.html, rules effective 2026-07-17.

Canada: Express Entry no longer awards ranking points for job offers (since 25 Mar 2025); a job offer still counts toward Federal Skilled Worker eligibility.

A verdict summarises public evidence. It is not legal advice and never a guarantee: the employer and the immigration authority decide. Sign in to factor in where you can already work.

About the role

The Business Systems Technical Analyst is responsible for supporting, enhancing, and integrating core enterprise applications across the organization, including ERP, WMS, manufacturing, reporting, and integration platforms.  This role serves as the technical bridge between business stakeholders, software vendors, and technology teams to ensure business systems are reliable, scalable, and aligned with operational requirements. The successful candidate will possess strong SQL development skills, experience working with ERP and warehouse management solutions, and a solid understanding of application integrations, APIs, and database technologies. This role is highly hands-on and requires both troubleshooting and solution delivery capabilities. Key Responsibilities: Business Systems Support & Enhancement Provide day-to-day support for ERP, WMS, and related enterprise applications. Investigate and resolve application issues, data discrepancies, and process exceptions. Analyze business requirements and translate them into technical solutions. Work with business users to identify opportunities for process improvement and automation. Coordinate with software vendors and implementation partners on support and enhancement initiatives. Database & SQL Development Develop, optimize, and maintain SQL queries, stored procedures, views, and scripts. Support data extraction, transformation, validation, and reporting requirements. Analyze application data structures and troubleshoot database-related issues. Ensure data quality, integrity, and performance across business systems. Application Integration Support and enhance integrations between ERP, WMS, transportation, manufacturing, and third-party systems. Assist with API design, testing, troubleshooting, and documentation. Monitor integration performance and resolve data synchronization issues. Participate in the design and implementation of new system integrations. Systems Analysis & Solution Design Gather business and technical requirements from stakeholders. Document current and future state processes. Develop functional and technical specifications. Participate in solution architecture discussions and system design reviews. Project Delivery Support business systems projects, upgrades, and implementations. Participate in testing activities including system, integration, UAT, and regression testing. Assist with change management, training, and deployment activities. Provide technical expertise during ERP and application modernization initiatives. Required Qualifications: Bachelor's degree in Information Technology, Computer Science, Information Systems, Engineering, or equivalent experience. Experience 5+ years of experience supporting enterprise business applications. 3+ years of SQL development and database administration experience. Experience working with ERP systems in a business or manufacturing environment. Experience supporting Warehouse Management Systems (WMS). Experience designing, troubleshooting, or supporting system integrations and APIs. Hands-on experience with Microsoft SQL Server environments. Essential Technical Skills Database & Development Advanced SQL development T-SQL Stored Procedures Views and Functions SQL Server Management Studio (SSMS) Database troubleshooting and performance tuning Data analysis and validation Enterprise Applications ERP systems support and configuration WMS solution support Business process analysis Application troubleshooting Integration Technologies REST APIs Web Services JSON/XML Application integrations Data mapping and transformation Integration troubleshooting Reporting & Data SQL-based reporting Data validation Root cause analysis Reporting support Preferred Qualifications ERP migration or transformation project experience. Manufacturing ind

Apply on employer site ↗