Data Warehouse & BI Developer

TEEMA; Port Coquitlam; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in the retail sector is looking for a skilled Data Warehouse & BI Developer to enhance their data infrastructure. The role involves designing data solutions, optimizing queries, and creating insightful reports using Power BI. The ideal candidate will have a strong background in SQL and ETL processes, along with excellent communication skills to collaborate with stakeholders. This position offers a competitive salary and the opportunity to work in a dynamic environment focused on data-driven decision-making.

Qualifications

• Proven experience as a Data Warehouse Developer or BI Developer.
• Hands-on experience with ETL tools and processes.
• Strong analytical and problem-solving skills.

Responsibilities

• Design, develop, and maintain data warehouse solutions.
• Optimize SQL queries and implement data quality processes.
• Create reports and dashboards using Power BI.

Skills

SQL

Data Analysis

Problem Solving

Communication

Education

Bachelor’s degree in Computer Science

Tools

Power BI

ETL

SQL Server

Oracle

MySQL

SSIS

Informatica

Talend

Azure

Job description

Job Title: Data Warehouse & BI Developer
Job ID:79725
Location: PortCoquitlam, British Columbia

*** Only applicantslocated in the greater Vancouver or Fraser Valley areas willbe considered***

Overview:
We are seeking a talented and experienced Data Warehouse & BI Developer to help design, develop, and maintain our data warehouse infrastructure and create insightful reports and dashboards using Power BI. This role requires strong proficiency in SQL, ETL processes, and other relevant technologies to ensure the availability, accuracy, and usability of our data assets.

What you will be doing:

• Design, develop, and maintain technical solutions including:

• Data warehouse solutions supporting business intelligence and reporting needs.

• ETL processes for data integration.

• Optimizing and tuning SQL queries for better performance.

• Implementing data quality and governance processes to ensure integrity and regulatory compliance.

• Provide actionable insights to support retail strategies by:

  • Creating interactive and visually appealing reports and dashboards using Power BI.

  • Collaborating with stakeholders to understand data needs and translate them into scalable, efficient data models.

  • Contribute to the foundation of future data structures by:

  • Collaborating with cross-functional teams to align data architecture and reporting solutions with business goals.

  • Keeping up to date with trends and best practices in data warehousing, business intelligence, and data visualization technologies.

What you must have:

• Bachelor’s degree in Computer Science or a related field.

• Proven experience as a Data Warehouse Developer, BI Developer, or similar role.

• Strong proficiency in SQL programming and database management (SQL Server, Oracle, MySQL).

• Expertise in designing and optimizing data warehouse architectures and data models.

• Hands-on experience with ETL tools and processes (e.g., SSIS, Informatica, Talend).

• Proficiency in data visualization using Power BI.

• Familiarity with the Azure cloud platform and OneLake/DataLake storage architecture.

• Experience in large-scale retail IT environments.

• Extensive knowledge of IT systems, relational databases, and data analysis.

• Strong analytical and problem-solving skills, with attention to detail.

• Excellent communication and interpersonal skills for effective collaboration.

• Ability to work independently and manage multiple priorities in a fast-paced environment.

• Comprehensive understanding of the retail industry.

Salary/Rate Range: $70,000 – $90,000

For more information about TEEMA and to consider other career opportunities, please visit our website atwww.teemagroup.com