Data Warehouse & BI Developer

Microserve; Port Coquitlam; On-site; CAD 100,000 - 125,000; Full time

Job summary

Microserve is seeking a Data Warehouse & Business Intelligence Developer for their Port Coquitlam office. This permanent role involves designing and maintaining data warehouse infrastructure, optimizing database performance, and creating interactive dashboards using Power BI. The successful candidate will play a key role in the organization's digital transformation initiatives.

Qualifications

• Strong proficiency in SQL and relational databases.
• Experience with ETL tools like SSIS and Informatica.
• Advanced skills in Power BI.

Responsibilities

• Develop and maintain data warehouse solutions.
• Optimize ETL processes for data transformation.
• Create insightful dashboards and reports using Power BI.

Skills

SQL

ETL processes

Data Visualization

Communication

Problem Solving

Education

Bachelor’s degree in Computer Science

Tools

Power BI

SQL Server

SSIS

Job description

Microserve Port Coquitlam, British Columbia, Canada

Data Warehouse & BI Developer

Microserve Port Coquitlam, British Columbia, Canada

Get AI-powered advice on this job and more exclusive features.

This range is provided by Microserve. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$100,000.00/yr - CA$125,000.00/yr

Data Warehouse & BI Developer (Permanent)

Location: This position is onsite at the Port Coquitlam head office

Our client is looking for a skilled and experienced Data Warehouse & Business Intelligence Developer to join our fast-paced, innovation-driven team. In this role, you'll be responsible for designing, developing, and maintaining data warehouse infrastructure, while also creating insightful, interactive dashboards and reports using Power BI. Your expertise in SQL, ETL processes, and modern data technologies will be key to delivering high-quality, reliable data solutions that support strategic decision-making across the organization.

The organization is undergoing a large-scale digital transformation, modernizing critical systems and investing in technologies that drive operational excellence and customer value. They have recently launched a new ERP, implemented a GPS delivery tracking system, and upgraded to a digital telephony system. The warehouse operations now include automated conveyors, handheld WMS devices, and even autonomous vehicles. They are now preparing for our next step: B2C eCommerce. As they continue to build the foundation for a data-driven future, this role will play a vital part in delivering the insights needed to guide their success.

What You’ll Do

• Develop and maintain data warehouse solutions to support business intelligence and reporting.
• Build and optimize ETL processes to move and transform data from various sources.
• Tune SQL queries for performance and efficiency.
• Implement data governance and quality standards to ensure integrity and compliance.
• Deliver interactive, insightful dashboards and reports using Power BI.
• Partner with business stakeholders to understand data needs and build scalable data models.
• Collaborate across departments to align data architecture and solutions with business goals.
• Stay current with the latest trends and best practices in BI, data warehousing, and visualization.

What You Bring

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Proven experience as a Data Warehouse or BI Developer.
• Strong proficiency in SQL and relational database technologies (e.g., SQL Server, MySQL, Oracle).
• Experience with ETL tools (e.g., SSIS, Informatica, Talend).
• Advanced skills in Power BI and data visualization.
• Familiarity with Azure and OneLake/DataLake architecture.
• Experience working in complex, retail IT environments.
• Solid understanding of IT systems, data modeling, and data analysis techniques.
• Excellent communication and collaboration skills.
• Strong attention to detail and problem-solving abilities.
• Ability to manage multiple priorities in a fast-moving environment.
• Knowledge of retail business concepts and operations is an asset.

Note: This role is an opportunity with a Microserve client.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Microserve by 2x

Sign in to set job alerts for “Business Intelligence Developer” roles.

Quantitative Equity Analyst – Data Science

Burnaby, British Columbia, Canada $85,000.00-$100,000.00 1 week ago

Senior Business Intelligence (BI) Developer

Business Intelligence Engineer, P2 Science, Data, and Insights

Business Intelligence Engineer, P2 Science, Data, and Insights

Business Intelligence Engineer, P2 Science, Data, and Insights

Burnaby, British Columbia, Canada 1 day ago

Burnaby, British Columbia, Canada 2 weeks ago

Surrey, British Columbia, Canada 2 weeks ago

Langley, British Columbia, Canada 1 month ago

Burnaby, British Columbia, Canada 2 weeks ago

Surrey, British Columbia, Canada 2 weeks ago

2025 Fall Student - Data Analyst (4 months)

Western Canada Operations Data Modeling Analyst

Data Taxonomy Specialist (Code Methods Analyst)

Burnaby, British Columbia, Canada 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.