BI Developer - ETL/sq

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.

You'll do:

• 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.

You'll have:

• 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.

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

Your Workplace Location:

Nestled amidst captivating natural beauty, Vancouver is a city that promises an enchanting experience to its visitors. Its balmy climate, coupled with the warm hospitality of its people, has earned it a reputation as one of the most sought-after tourist destinations in the world. However, Vancouver's appeal doesn't just end there. The city boasts a vibrant cultural scene, with a rich diversity of languages and ethnicities, adding to its unique charm. As one of Canada's most ethnically and linguistically diverse cities, Vancouver is a melting pot of cultures, traditions, and lifestyles, making it an unparalleled place to live.

About Us:

We make renewable, wood-based building products for the world, contributing to a more sustainable future. Today, West Fraser is one of the world's largest producers of sustainable wood-based building products, with more than 60 facilities in Canada, the United States, the United Kingdom, and Europe. From responsibly sourced and sustainably managed forest resources, West Fraser produces lumber, engineered wood products (oriented strand board, laminated veneer lumber, medium-density fibreboard, plywood, and particleboard), pulp, newsprint, wood chips, other residuals, and renewable energy. West Fraser's products are used in home construction, repair and remodelling, industrial applications, papers, tissue, and boxes.

What makes us stand out is our people-first approach. We value internal growth and continuous learning. Join us, and you'll enjoy competitive pay, great benefits, and an excellent pension plan, all in a supportive environment where your voice matters.

Diversity:

At West Fraser, we strongly believe promoting diversity and inclusion is essential to our success. Our commitment to creating inclusive workplaces is reflected in our core values, and we constantly strive to foster a culture that values and respects every individual's unique background and perspective. By joining us, you will have the opportunity to be a part of a team dedicated to shaping a brighter future by embracing diversity and promoting inclusivity. Join our team at West Fraser and help us build a more diverse and inclusive community.

Sustainability:

West Fraser is fully committed to sustainable forest management as defined in our environmental policy, which is reflected in every aspect of our work. We adopt new technologies and innovations to create exceptional building materials. Wood products are a natural, renewable, recyclable, and environmentally sustainable choice for consumers who prioritize sustainability.

Sustainability Report | West Fraser

Learn more about us!

Discover West Fraser in Western Canada (youtube.com)

What's it like to work in Forestry at West Fraser? Shayna's story (youtube.com)