Supports, enhances, and integrates ERP, WMS, manufacturing, reporting, and enterprise applications. Develops and optimizes SQL queries, stored procedures, and reports; troubleshoots databases, integrations, APIs, and data issues; translates business requirements into technical solutions; coordinates with vendors; and supports system implementations, upgrades, testing, documentation, training, and process improvement initiatives.
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 industry experience.
- Experience with SYSPRO ERP.
- Experience with TransLution WMS/Supply Chain solutions.
- Experience with middleware or integration platforms (Boomi, MuleSoft, Azure Integration Services, etc.).
- Experience supporting transportation, logistics, or supply chain systems.
- Familiarity with Power BI and SSRS reporting environments.
- Experience working within Agile project delivery frameworks.
Competencies
- Strong analytical and problem-solving skills.
- Ability to troubleshoot complex technical issues.
- Excellent stakeholder management and communication skills.
- Ability to translate business requirements into technical solutions.
- Strong documentation and process analysis capabilities.
- Self-starter with the ability to manage multiple priorities.
- Collaborative team player with customer-focused mindset.
Sunrise Farms Surrey, British Columbia, CAN Office
Surrey, British Columbia, Canada
Similar Jobs
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Own end-to-end analytics engineering for AI and developer experience data. Instrument telemetry, build governed production pipelines, define trusted metrics, and create executive-facing dashboards and analyses. Partner with data engineering, AI, and data science teams to improve data quality and connect raw signals to decision-making. Present clear recommendations on AI investment, developer productivity, and ROI while using AI coding agents to build and maintain pipelines, dashboards, and analyses.
Top Skills:
Ai Coding AgentsCi/CdGitLlm-Based Classification ToolingMetrics StorePythonReactSnowflakeSQLTypescript
Productivity • Software • App development • Automation
Architects and manages global sales enablement programs spanning onboarding, methodology training, continuous learning, content, playbooks, and launch readiness. Uses Salesforce, conversation intelligence, sales engagement, and enablement platforms to diagnose performance gaps, measure program impact, and improve ramp time, pipeline execution, and win rates. Partners with sales leadership, Revenue Operations, Product Marketing, sellers, executives, and external vendors while managing enablement workstreams and performance dashboards.
Top Skills:
Ai-Assisted Coaching ToolsChorusConversation Intelligence PlatformsGongHighspotMindtickleOutreachSalesforceSalesloftSeismic
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Own end-to-end analytics pipelines for AI usage, developer experience, engineering productivity, and spend. Instrument telemetry, build governed ETL workflows, define trusted metrics, and create executive dashboards and visual narratives. Analyze results, recommend improvements to AI ROI and developer experience, and communicate methodology to senior stakeholders. Collaborate across data engineering, applied AI, and data science while using AI coding agents to build, test, and maintain production data systems.
Top Skills:
Ai Coding AgentsCi/Cd PipelinesDbt Semantic LayerGitGoverned Metrics StoreLlm-Based Classification ToolingLookmlPythonReactSnowflakeSQLTypescript
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
