Business Systems Technical Analyst
Supports, enhances, and integrates core enterprise systems (ERP, WMS, manufacturing, reporting) at Sunrise Farms, acting as the technical bridge between business users, vendors, and IT. The work is hands-on: advanced SQL development on Microsoft SQL Server, troubleshooting application and data issues, and building/maintaining API integrations.
- Compensation
- CA$110K–CA$120K / yr
- Location
- Surrey, BC
- Work setup
- Hybrid
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Software engineering
- Posted
Skills
Must have
- Bachelor's degree in IT, Computer Science, Information Systems, Engineering, or equivalent 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
- Advanced SQL development: T-SQL, stored procedures, views and functions
- SQL Server Management Studio (SSMS)
- Database troubleshooting and performance tuning
- Data analysis and validation
- ERP systems support and configuration
- WMS solution support
- Business process analysis
- REST APIs and web services
- JSON/XML
- Data mapping and transformation
- SQL-based reporting and reporting support
- Root cause analysis
- Strong analytical and problem-solving skills
- Excellent stakeholder management and communication skills
- Ability to translate business requirements into technical solutions
- Strong documentation and process analysis capabilities
Nice to have
- ERP migration or transformation project experience
- Manufacturing industry experience
- Experience with SYSPRO ERP
- Experience with TransLution WMS/Supply Chain solutions
- Experience with middleware or integration platforms (Boomi, MuleSoft, Azure Integration Services)
- Experience supporting transportation, logistics, or supply chain systems
- Familiarity with Power BI and SSRS reporting environments
Full description
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