BI Developer - ETL/SQ

West Fraser; Vancouver; On-site; CAD 85,000 - 108,000; Full time

Job summary

An established industry player is seeking a skilled BI Developer specializing in ETL and SQL to join their dynamic Information Technology team in Vancouver. This exciting opportunity involves optimizing and expanding data ETL architectures while enhancing data flows to support innovative products and initiatives. The ideal candidate will have extensive experience in handling large datasets and a strong command of SQL and data warehousing principles. Join a collaborative environment where your expertise will make a significant impact on data-driven decision-making and business success. If you are passionate about data and eager to drive improvements, this role is perfect for you.

Benefits

Annual bonus opportunity

Medical benefits

Dental benefits

Pension plan

Life insurance

Disability insurance

Accident insurance

Vacation

Holidays

Qualifications

• 10+ years of experience in BI ETL SQL Development or Data Architecture.
• Strong project management and organizational skills.

Responsibilities

• Design and maintain efficient ETL architectures and data models.
• Collaborate with teams to support their data infrastructure needs.

Skills

SQL

ETL Development

Data Warehousing

Data Governance

Azure Cloud Services

Project Management

Unstructured Data Handling

Education

Degree in Computer Science

Degree in Statistics

Tools

Data Factory

Azure DevOps

Azure Synapse

Databricks

Job description

Our Information Technology group has an opportunity based in Vancouver for a BI Developer - ETL/SQL with 10+ years of experience in handling large financial and manufacturing datasets.

This is an exciting role you will be involved in optimizing and expanding data ETL architectures, enhancing data flows, and supporting cross-functional teams.

The ideal candidate is skilled in building and optimizing data systems from the ground up and will help refine our data infrastructure to support next-gen products and initiatives.

Responsibilities:

• Design and maintain efficient ETL architectures and data models.
• Handle large, complex datasets to meet business requirements.
• Improve internal processes by automating tasks and optimizing data delivery.
• Build the infrastructure for ETL using SQL and Azure big data technologies.
• Develop analytics tools that leverage ETL flows to provide insights into key business metrics.
• Collaborate with Executive, Product, Data, and Design teams to support their data infrastructure needs.
• Create tools for analytics teams to enhance product optimization.
• Work with data and analytics experts to improve system functionality.

Qualifications:

• Expertise in SQL and relational databases (e.g., Oracle, MS SQL Server).
• Proven experience in building and optimizing ETL flows, architectures, and datasets.
• Strong knowledge of Data Warehousing, Enterprise Data Models, and Data Governance.
• Experience with root cause analysis of data and process issues.
• Skilled in working with unstructured datasets and data transformation processes.
• Strong project management and organizational skills.
• Ability to support cross-functional teams in a fast-paced environment.

Additional Qualifications:

• 10+ years of experience in BI ETL SQL Development or Data Architecture.
• Degree in Computer Science, Statistics, or a related field.
• Experience with SQL databases and data ETL tools (e.g., Data Factory, Azure DevOps).
• Familiarity with Azure cloud services (e.g., Synapse, Databricks, Delta Lake).
• Experience with stream-processing systems (e.g., Azure Event Hub) is a plus.

Compensation Package:

• The salary range for this position may vary depending on experience, education, and location. The annual salary range is between $85,000 - $108,000
• Annual bonus opportunity
• Outstanding benefits package including medical, dental, pension, life insurance, disability, accident insurance, vacation, and holidays

Work Conditions:

• Office-based
• May require occasional travel