Sql jobs in Canada

We are a bunch of people who really care about agriculture, food and the challenges facing farming. We want to help farmers with data driven decision making to help nature feed a growing population. Join our team of expert engineers, agronomists, entomologists, crop researchers, and data scientists who are continually conducting research to help drive innovation in agriculture.

Semios is a market leader in leveraging the internet-of-things (IoT) and big data to improve the sustainability and profitability of specialty crops. With 500 million data points being reported by our sensors every day, we leverage our big data analytics, such as in-depth pest and disease modeling, to empower tree fruit and tree nut growers with decision-making tools to minimize resources and risks.

One of our partners produced this short video which shows what we do and our positive environmental impact.

We know our journey is only achievable by having a great team who shares ideas, tries new things and learns as we go.

Motivated by meaningful work, you are looking for more than just a job; you want to work for a dynamic, growing company that finds solutions to real-life problems, such as helping the world reduce the use of pesticides and helping nature feed a growing population. Your ideal work environment includes a collaborative team spirit with the opportunity to learn and grow as you take the initiative to try new things.

You are an experienced Enterprise Applications Analyst with deep expertise in CRM and enterprise business systems. You excel at improving sales, service, and operational efficiency by configuring CRM platforms, designing workflows, and optimizing data flows across connected applications.

You thrive in a collaborative and mission-driven environment—one that solves real-world challenges such as reducing pesticide use and supporting sustainable global food production. You enjoy working across teams, solving technical problems, and shaping scalable system solutions within a growing organization.

In this role, you will play a key part in building and sustaining a CRM application ecosystem. You’ll work closely with stakeholders across sales, service, and operations to ensure high-quality data, consistent workflows, and seamless integrations between CRM and related systems. Your work will span both strategic initiatives (such as implementations, data migrations, and process optimization), and ongoing sustenance and operational support.

This role is ideal for someone who enjoys optimizing CRM workflows, building automation, managing integrations, and driving scalable and user centric improvements.

• Partner with business stakeholders to analyse workflows, gather requirements, and translate them into functional and technical specifications for CRM and integrated systems.
• Maintain accurate documentation including data models, data field mappings, process flow and system architecture , and across CRM and connected platforms.
• Identify process inefficiencies and opportunities for optimization, including opportunities to leverage platform capabilities, and AI-driven enhancements

• Configure and enhance CRM, CPQ, Field Services or relevant modules, supporting end-to-end workflows across sales and service teams.
• Design, implement, and maintain integrations between CRM, and external applications using APIs, middleware, and automation platforms to ensure reliable, timely data synchronization.
• Build scalable automation using workflows, low-code tools, and targeted customizations for complex logic that cannot be handled through configuration alone.
• Administer security and access controls—including roles, profiles, permission sets, sharing rules, and login/security policies—to maintain appropriate access and strong data governance.
• Manage platform components such as validation rules, approval processes, metadata changes, and page layouts to ensure accurate, consistent, and user-friendly system behavior.

• Support data management activities including data migration, cleansing, validation, and reconciliation across CRM and integrated systems.
• Build and maintain reports and dashboards, ensuring visibility into KPIs for sales, service, and operations.
• Write and run SQL (or equivalent) queries to validate data, troubleshoot issues, and support integration troubleshooting.
• Collaborate with analytics teams to align on data governance, reporting standards, and dashboards used across the organization.

• Lead and coordinate user acceptance testing (UAT), regression testing, and release validation for CRM changes and cross-system updates.
• Provide day-to-day CRM and application support, diagnosing root causes, resolving issues, and coordinating with vendors or internal technical teams as needed.
• Contribute to change management with release notes, documentation, training materials, and communication plans.

• Build strong relationships across sales, operations, customer success, and technical teams.
• Clearly translate technical concepts into actionable recommendations for non-technical stakeholders.
• Ensure alignment with enterprise CRM standards, data governance requirements, and best practices.

• 5–7 years of hands-on CRM and enterprise applications implementation experience, including configuration, reporting, workflow management, and ongoing system support.
• Experience with integrations, including designing or supporting APIs, middleware, multi-system data flows, workflow automation, and troubleshooting synchronization issues.
• Familiarity with security and access management (roles, profiles, permission sets, sharing rules, login/security policies).
• Ability to make customizations, or scripting logic to support automation or troubleshoot integrations.
• Proficiency in Reports/Dashboards and SQL or equivalent querying tools.
• Strong experience with data management, data validation, and data reconciliation across CRM and connected systems.
• Experience designing business workflows, mapping processes, and documenting functional/technical requirements.
• Excellent troubleshooting, problem-solving, and stakeholder engagement skills.
• Ability to work independently in a fast-paced, evolving environment with strong attention to detail.
• Technically curious, analytical, and adaptable, with a drive to continuously improve systems and processes.

• CRM and CPQ certifications.
• Experience with Quote-to-Cash, lead-to-order, service workflows, or subscription-based business models.
• Exposure to cloud platforms and data warehouses (Azure, GCP, AWS).
• Experience applying automation and AI within enterprise systems.
• Agile project management methodology experience.
• Experience scaling enterprise systems within high-growth, mid-sized organizations.

Salary range: $110,000 to $130,000 per year

We publish a salary range to provide transparency and represent the full growth potential of the role; as a result, initial offers are made based on demonstrated mastery and experience and generally fall near the midpoint.

This role is open to candidates based in Vancouver, BC (hybrid work model), or remote within Canada. Remote employees are expected to work primarily within Pacific Time (PST) business hours, with occasional flexibility for later hours to coordinate with the Perth, Australia region.

• Purposeful Work: Sleep better knowing you're making the world a better place through more sustainable food production. You'll have the opportunity to contribute and make an impact by working on meaningful projects.
• Our People: Work with a team that values fun, laughter, and each other in a collaborative and casual work environment.
• Recharge and Refresh: Benefit from a generous vacation policy and an annual year-end winter break to relax and rejuvenate.
• Give Back: Take advantage of dedicated volunteer days to support causes you care about.
• Work Flexibly: Enjoy hybrid working options for employees near our offices, emphasizing work-life balance.
• Prioritize Your Well-Being: Access comprehensive health plans designed to support your physical and mental health.
• Save for tomorrow: Take advantage of our Group RRSP program with company matching.
• Stay Energized: Enjoy well-stocked snack options in our offices and regular team outings to build connections and have fun.

At Semios, we recognize that people come with a wealth of experience and talent beyond just the technical requirements of a job. We know that our differences often can bring about innovation, excellence and meaningful work—therefore, people from all backgrounds are encouraged to apply to our positions. We believe that different perspectives and backgrounds are what make a company flourish and we welcome everyone.