Business Intelligence (BI) Specialist

Tolko Industries Ltd.; Vernon; On-site; CAD 65,000 - 87,000; Full time

Benefits offered by this job

Relocation support

Excellent benefits

Bonus program

Tuition reimbursement

Job summary

The role is on-site at Tolko’s Vernon head office. You will design, implement, and document BI systems, and work with stakeholders to deliver data-driven insights while adhering to security and governance practices.

Qualifications

• 4-year undergraduate degree or equivalent BI experience.
• Understanding of data warehouse analysis, design, and modeling.
• Experience with SQL and data warehousing techniques.
• Knowledgeable on data model security (e.g., RLS).
• Engineering new data pipelines and supporting existing models and delivery methods.
• Broad data & analytics tools and strong business skills.

Responsibilities

• Implement and use new BI tools and systems.
• Code, test, and document BI data/analytics systems and programs.
• Develop semantic layer, metadata, and report definitions.
• Design data pipelines and warehouses to integrate with BI solutions.
• Follow ETL design guidelines for a scalable BI infra.
• Support and analyze existing analytics applications and ETL processes.
• Collaborate with stakeholders to deliver data-driven solutions.
• Maintain BI documentation, standards, and best practices.

Skills

BI tools

SQL

Data warehousing

Data pipelines

Power BI

SSAS/SSIS/SSRS

Azure Databricks

Data modeling

RLS

ETL design

Communication

Education

Bachelor’s degree in BI/CS

Tools

SSIS

SSAS

SSRS

Power BI

Databricks

OneLake

Microsoft Fabric

SQL Server

Job description

Our Business Intelligence (BI) Specialistis a disciple of data analytics. With a keen eye for detail and a passion for finding insights, they are a vital part of our software systems and BI applications team. If you are looking for a challenging and rewarding role that combines technical skills and business acumen, read on to learn more!

We’re looking for a Business Intelligence (BI) Specialistto join our head office located in Vernon, British Columbia. Our head office houses Tolko’s corporate services groups including Sales, Marketing & Logistics, Finance, Accounting & Credit, IT, Procurement and Human Resources. This is an on-site position and remote work is not available at this time.

Our ideal candidate has the following qualifications:

• 4-year undergraduate Degree or appropriate experienceworking in a BI role.
• Understanding of data warehouse analysis and design, with a full knowledge of data warehouse methodologies and data modeling.
• Experience with SQL coding, and Data warehousingtechniques.
• Knowledgeable on data model security and the implications and impact or various techniques such as RLS.
• Responsibilities will include engineering new data pipelinesas well as supporting existing modelsand data delivery methods.
• Understanding of data structures, theories, principles, and practices.
• Broad based business skills and a strong background in both data & analytics tools.
• Knowledge of SSAS, SSIS, SSRS, andPower BI or other applicable data warehousing tools.
• Experience with Azure data platformsuch as Databricks, OneLake, Microsoft Fabric or SQL Server.

We value diversity at Tolko and know that experience and knowledge comes in many forms. Even if you don't have all the qualifications above, we would love to hear your story and have you grow with us.

In this role, you will:

• Participatein the implementation and use of new BI software tools and systems.
• Code, test, and documentall new or modified data & analytics systems, applications, and programs.
• Develop the semantic layer, metadata, and report definitions.
• Assist in the design of data pipelines and data warehouses to ensure interoperability with BI solutions.
• Follow ETL design guidelinesto ensure a manageable ETL infrastructure for the BI system.
• Support and analyze existing software systems, data & analytics applications, operational reporting, and ETL processes that feed the data warehouses.
• Code and deploy data & analytics solutions to end users.
• Collaborate with business stakeholders and IT teams todeliver data-driven solutionsthat meet business needs and objectives.
• Maintain documentation, standards, and best practices for BI processes and solutions.
• Supports a process-focused culture that enables moving data and analytics maturity level.
• Build and support partnerships with the business by addressing their requirements with data driven solutions.

So, what’s in it for you?

• You’ll take on an exciting new challengewith supportive team members.
• You’ll earn a competitive salary based on your skills and experience.The expected base salary range for this position is $65,250 to $87,000 per year.
• You’ll be eligible forexcellent benefits, so you don’t have to choose between your bottom line and your wellbeing or your future.
• You will be eligible to participate in Tolko’sbonus program.
• You may also be eligible forrelocation support including community connections so you can live (and play) where you work.
• You’ll be supported incontinued developmentthrough on-the-job and classroom training and reimbursement of tuition and membership fees.
• You’ll be part of a positive, innovative, and inclusive work environment.

If you want to work in a sustainable, future focused industry,there is no better place than Tolko. Our family has been producing innovative forest products for over 65 years. Our focus remains on sustainably managing our forests and our business for upcoming generations.

We want YOU to join our family. Come Grow Here!

Want to know what it’s like to work for Tolko? Hear what our employees have to say!

About the North Okanagan Valley

The North Okanagan Valley includes the communities of Vernon, Armstrong, Lavington, Lumby and Lake Country, British Columbia. Surrounded by lakes, these communities provide family-friendly living with lots of amenities, and beautiful weather. Visit one of our local wineries or fine dining restaurants, go boating, hiking, biking, skiing, catch a round of golf, or visit a local market to pick up fresh fruit and produce… whatever your pleasure, you’ll find it here. Watch this video to learn about the region and find out why life is better here.