Immigrant Services Society of BC (ISSofBC) Logo

Immigrant Services Society of BC (ISSofBC)

Data and Business Systems Analyst

Posted 3 Days Ago
Be an Early Applicant
Hybrid
Delta, BC, CAN
Junior
Hybrid
Delta, BC, CAN
Junior
Manages product, customer, pricing, and sales data across PIM, ERP, and CRM systems. Ensures data quality, standardization, governance, and accurate pricing implementation. Uses Excel, Power Query, SQL, and reporting tools to analyze trends, identify discrepancies, and support business decisions. Develops automated workflows, improves processes, supports system enhancements and projects, and provides documentation, training, and user support to cross-functional teams.
The summary above was generated by AI

Our Employer Partner is seeking a Data and Systems Business Analyst to join the team in our Delta, BC location.

PURPOSE OF THE JOB:

The Data and Systems Business Analyst is responsible for gathering, developing, entering, maintaining and analyzing product and customer data, including product attributes, customer information and pricing. This role supports the Sales, Customer Service and Marketing departments by ensuring data is accurate, complete, standardized, and readily available for reporting and decision-making. The Data and Systems Business Analyst will analyze customer sales and pricing data to identify trends, opportunities, and data quality issues that support business strategy and the development of customized strategies for current and prospective customers.  This role requires strong knowledge of data management, business processes, sales and marketing workflows, data analysis, and business systems. The Data and Systems Business Analyst will also contribute to process improvement, automation, system optimization, and cross-functional projects designed to improve the quality, efficiency, and accessibility of company data.

 BENEFITS:

  • Salary – $75,000 to $90,000 per year based on experience
  • Extended Benefits Plan (Vision/Dental/Prescription/etc.) as of your first day
  • Performance, Education & Referral Programs
  • Quarterly town halls and summer BBQ’s
  • Annual Golf Tournament and Winter Holiday Party
  • And much more!

RESPONSIBILITIES:

Pricing & Product Data

  • Ensures customer pricing information and contracts are accurate, complete, and implemented on time across all applicable systems.
  • Prepares, compiles, and organizes documentation and information required for customer price sheets.
  • Enters and maintains pricing information accurately within applicable databases and systems while adhering to formatting and standardization requirements.
  • Obtains and validates missing or incomplete information required to establish customer pricing.
  • Reviews and scrubs pricing data for errors in formatting, spelling, calculations, and standardization.
  • Prepares price books in Excel and uploads pricing information into the ERP system.
  • Works with Sales, Customer Service, Finance, and other departments to investigate and resolve pricing discrepancies and database issues.

Data Management & Governance

  • Maintains standards for how data elements are defined, structured, utilized and shared throughout the organization, including related SOPs.
  • Manages product, customer, pricing, and sales data within the Product Information Management (PIMCore), Enterprise Resource Planning (Visual), and Customer Relationship Management (Zoho) systems.
  • Ensures data is accurate, complete, consistent, standardized, and maintained according to established business rules.
  • Monitors data quality across Accounts, Contacts, Opportunities, products, pricing, and other key data elements.
  • Identifies and communicates data errors or inconsistencies to appropriate users and departments and supports timely resolution.
  • Utilizes internal tools and third-party services to maintain the integrity, usability, and availability of product, customer, and sales data.
  • Ensures data management practices comply with established company policies, procedures, and standards.

Data Analysis, Reporting & Process Improvement

  • Uses Excel, Power Query, SQL, and other analytical tools to extract, transform, validate, and analyze business data.
  • Develops and maintains reports, datasets, and analytical tools to support Sales, Customer Service, Marketing, and management decision-making.
  • Analyzes customer, product, sales, and pricing trends and identifies opportunities, anomalies, and data quality issues.
  • Continually identifies opportunities to improve processes, eliminate inefficiencies, reduce manual work, and automate recurring tasks.
  • Develops and maintains automated data processes and workflows where appropriate.
  • Recommends improvements to data structures, processes, systems, and reporting based on identified business needs.

Systems & Project Support

  • Supports system enhancements, testing, implementations, upgrades, and data-related projects.
  • Provides training, documentation, and ongoing support to users as required.
  • Supports and/or coordinates strategic projects designed to improve business performance, data quality, operational efficiency, and system capabilities.
  • Works collaboratively with internal stakeholders and system vendors to resolve issues and improve system functionality

Safety:  

  • Promotes safe work practices as outlined in the Worksafe B.C. regulations.

Quality:  

  • Ensures the Company’s quality policies and procedures are followed.   

Team building:  

  • Participates in 1X1 meetings with the Controller, Financial Systems and Cost Accounting

REQUIREMENTS:  

  • Minimum of 2 years of experience in data administration 
  • 2 + years of experience in data management & governance
  • 2 + years of experience in pricing & product data
  • 2 + years of experience in data analysis, reporting & process improvement
  • 2 + years of experience in systems & project support/ coordination, training, documentation & user-support skills 
  • 2 + years of experience in SQL, including the ability to query, filter, join, and analyze data from relational databases
  • 2 + years of experience in ERP and CRM software; Infor Visual (ERP), PIMCore and/or Zoho CRM is an asset
  • Advanced Microsoft Excel skills, including experience with Power Query, lookups, formulas, pivot tables, and data validation and strong computer skills, especially Microsoft Office (Word, Excel, PowerPoint)
  • Post-secondary education in Business, Information Technology, Data Analytics, or a related field
  • Experience establishing data standards, definitions, validation rules, documentation, and data governance practices is an asset            
  • Strong understanding of sales, customer service, and marketing processes and workflows
  • Comfortable in developing strong relationships and working with senior level executives  

HOURS:

  • Monday to Friday, 8:00am – 4:30pm
  • Hybrid (3 days in the office and 2 days of working from home) – there will be a training period of 6 months in the office before transitioning to hybrid

Please note: All job postings from this employer is aimed at filling existing vacancies within their organization. They may utilize artificial intelligence (AI) tools as part of the applicant screening process. However, our Talent Acquisition Specialist will also review applications to ensure a fair and comprehensive assessment.

Similar Jobs

23 Minutes Ago
Easy Apply
Remote or Hybrid
CA
Easy Apply
Mid level
Mid level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Manage end-to-end deployment and adoption of Samsara’s IoT solutions for mid-market customers. Create launch plans, track implementation progress and account health, deliver training and product demonstrations, define business outcomes and KPIs, and resolve challenges while coordinating with Sales, Support, Sales Engineering, Product, executives, and end users.
Top Skills: Ai ToolsAutomationCloud SoftwareControl SystemsIotNetworkingPythonRestful ApisTelematics
25 Minutes Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Owns US engagement and growth strategy for Afterpay, Cash App commerce, and lending products. Leads lifecycle marketing, cross-sell, incentives, experimentation, product launches, and AI-enabled automation. Partners cross-functionally with Product, Analytics, Martech, Creative, Brand, and business leadership; sizes opportunities, builds impact models, sets multi-quarter roadmaps, and optimizes for active customers and gross profit.
Top Skills: BrazeClaude CodeGooseHightouchIterableSalesforce Marketing CloudSQL
26 Minutes Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Owns release quality for Square hardware products, including factory, OS, firmware, and application releases. Defines validation strategies across manual and automated testing, evaluates product risk, and makes go/no-go recommendations. Leads contract test engineers and vendor partners, drives issue resolution, partners with hardware, product, manufacturing, and program teams, and expands automated device testing using CI and hardware-in-the-loop test racks.
Top Skills: Android/AospCiFirmwareHardware-In-The-LoopOsTest Automation

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.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account