Data Warehouse & BI Developer

Altis Technology; Port Coquitlam; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading automotive parts retailer is seeking a Data Warehouse & BI Developer to support their digital transformation. Located in Port Coquitlam, this role involves designing technical solutions, developing ETL processes, and providing insights to enhance customer experiences. Candidates should be eligible to work in Canada and have a strong background in data warehousing and BI technologies.

Qualifications

• 5+ years of experience building and maintaining data warehouses.
• Hands-on expertise with relational databases and ETL tools.
• Proficiency in data visualization using Power BI.

Responsibilities

• Design, develop, and maintain data warehouse solutions.
• Optimize SQL queries for performance improvements.
• Produce interactive reports and dashboards using Power BI.

Skills

Data Warehousing

SQL

Oracle

Redshift

ETL Processes

Power BI

Azure Cloud

Data Integrity

Education

Bachelor's degree in Computer Science

Tools

SSIS

Informatica

Talend

Job description

Join to apply for the Data Warehouse & BI Developer role at Altis Technology

Continue with Google Continue with Google

Join to apply for the Data Warehouse & BI Developer role at Altis Technology

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

Base pay range

CA$90,000.00/yr - CA$120,000.00/yr

Direct message the job poster from Altis Technology

IT Recruitment Expert Supporting the Broader Public Sector

Our client, a leading automotive parts retailer, is seeking a highly skilled and experienced Data Warehouse & BI Developer to join their dynamic team. This role is crucial for their digital transformation journey, focusing on driving value through data and business insights to enhance customer experiences.

This position is based at the client's head office in Port Coquitlam, BC, and requires on-site work 5 days per week. Candidates must be eligible to work in Canada.

Responsibilities:

• Design, develop, and maintain various technical solutions.
• Oversee the completion of data warehouse solutions to support business intelligence and reporting requirements.
• Develop ETL processes from various sources into the data warehouse.
• Optimize and tune SQL queries for improved performance and efficiency.
• Implement data quality and governance processes to ensure data integrity and compliance with regulatory requirements.
• Provide actionable insights for various business partners that will drive retail strategies and contribute to the company’s continued success.
• Produce interactive and visually compelling reports and dashboards using Power BI, creating intelligent insights that convey meaning.
• Work closely with stakeholders to understand data needs and translate them into scalable and efficient data models.
• Play a crucial role in laying a data structure foundation that will enable long-term future success.
• Collaborate with cross-functional teams to ensure the alignment of data architecture and reporting solutions with business goals.
• Stay up to date with emerging trends and best practices in data warehousing, business intelligence, and data visualization technologies.

Qualifications:

• A Bachelor's degree in Computer Science, or a related field.
• 5+ years of experience building and maintaining data warehouses
• Hands-on expertise with relational databases (SQL, Oracle, Redshift, etc.)
• 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.
• Thorough familiarity of the Azure cloud platform and OneLake/DataLake storage architecture.
• Retail experience (large-sized retailers) or similarly complex system environments (e.g., POS, supply chain, high transaction volume)
• Strong understanding of the importance of uptime and data availability
• Proven ability to communicate across departments and build relationships
• Positive, collaborative personality; someone who is team-oriented and easy to work with
• A mindset for long-term growth with the company

Nice-to-Haves:

• Familiarity with POS systems and supply chain processes
• Experience with medallion architecture or similar layered data strategies
• Background in ERP systems

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering, Information Technology, and Consulting

• Industries

  Retail

Referrals increase your chances of interviewing at Altis Technology by 2x

Sign in to set job alerts for “Data Warehouse Engineer” roles.

Continue with Google Continue with Google

Continue with Google Continue with Google

Richmond, British Columbia, Canada 1 day ago

White Rock, British Columbia, Canada 1 week ago

Analytics Engineer - AI & Semantic Modeling

Richmond, British Columbia, Canada 1 day ago

Data Developer (Data Pipeline and Modeling)

Burnaby, British Columbia, Canada 1 month ago

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

Data Developer (Data Pipeline and Modeling)

Burnaby, British Columbia, Canada 4 months ago

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