Data Integration & BI Analyst

Oxygen8; Burnaby; On-site; CAD 65,000 - 75,000; Full time

Job summary

An innovative company is seeking a Data Integration & BI Analyst who excels at merging systems and data for enhanced decision-making. This role involves building data pipelines, connecting systems via APIs, and creating insightful dashboards in Power BI. You'll play a crucial part in supporting operations within a fast-paced manufacturing environment, particularly in HVAC and supply chain sectors. Join a collaborative team dedicated to fostering growth and inclusivity, while contributing to impactful projects that improve health and wellness in buildings.

Benefits

Company Team Building Events

Employee Stock Option Plan

Health and Dental Benefit Coverage from day 1

3 Weeks Paid Vacation

Paid Volunteer Day

Personal Development and Training Opportunities

Qualifications

• 3+ years of experience in data analysis or BI with integration responsibilities.
• Strong working knowledge of SQL, Power BI, and REST APIs.

Responsibilities

• Design and maintain API-based integrations between ERP and CRM systems.
• Create dynamic Power BI dashboards to visualize trends and KPIs.

Skills

SQL

Power BI

REST APIs

Power Automate

PowerShell

Tools

Epicor

Job description

About Oxygen8

At Oxygen8, we help create healthy spaces for people to live, work, and play in an energy-efficient way. Since 2019, Oxygen8 has developed and manufactured high-efficiency commercial and multi-family residential ventilation systems that help improve the health and wellness of buildings and their occupants. Oxygen8’s 100% electric dedicated outside air systems with high-efficiency energy recovery address current human health and changing climate challenges while significantly improving health and environmental impact. Through innovation, collaboration, and intelligent design, our solutions integrate seamlessly into building systems and are paired with smart monitoring and control systems. At Oxygen8, we make #freshairthatfits.

About The Role

We are looking for a Data Integration & BI Analyst who thrives at the intersection of systems, data, and process improvement. In this role, you’ll be responsible for building robust data pipelines, connecting systems through APIs, and developing powerful, user-friendly dashboards in Power BI. Your efforts will support decision-making across departments in a fast-paced manufacturing environment, focusing on HVAC and supply chain operations.

Key Responsibilities

System Integration & API Development

• Design, implement, and maintain API-based integrations between ERP (e.g., Epicor), CRM, and other business platforms.
• Troubleshoot and enhance existing data pipelines and integration logic.
  
  

Business Intelligence & Reporting

• Create dynamic Power BI dashboards and reports to visualize trends, KPIs, and operational performance.
• Collaborate with stakeholders to translate business needs into actionable data insights.
  
  

Data Management & Querying

• Write and optimize SQL queries to extract, transform, and analyze data from multiple sources.
• Support data cleansing and validation to ensure accuracy and consistency across systems.
  
  

Automation & Scripting

• Use Power Automate and PowerShell to automate routine data tasks and streamline business workflows.
  
  

Experience And Skills

• 3+ years of experience in a data analyst or BI role with integration responsibilities.
• Strong working knowledge of SQL, Power BI, and REST APIs.
• Familiarity with Power Automate and PowerShell for workflow automation.
• Experience with ERP systems (Epicor preferred) and understanding of manufacturing/Supply Chain processes.
• Bonus: Exposure to HVAC industry terminology, production planning, or parts management.
  
  

Working with Oxygen8

Benefits

At Oxygen8, we strongly believe in building a team that works well together, and we are committed to creating an environment that is inclusive and provides the space for individuals to learn and grow. We are proud to offer the following benefits to our team members:

• Company Team Building Events
• Employee Stock Option Plan
• Health and Dental Benefit Coverage from day 1
• 3 Weeks Paid Vacation
• Paid Volunteer Day
• Personal Development and Training Opportunities
  
  

Annual Salary

• $65,000 to $75,000 based on experience.
  
  

Location and Schedule:

• On site 40 hours per week at our South Burnaby office and occasionally at our East Vancouver office
• Monday to Friday 8am to 4:30pm (TBD)