Business Intelligence Operations Intelligence Analyst Jobs in Vancouver, British Columbia

Capture and analyze business requirements to design data models and build data pipelines for data extraction, transformation, and loading (ETL)

Build and manage data dashboards, reports, and visualizations that provide insight into key business metrics

Strong analytical and problem-solving skills, with the ability to translate complex data into useful insights for technical and non-technical partners

Experience with Snowflake or any other relational database

Experience with the design and development of ETL processes

Experience with data visualization tools such as Superset or MicroStrategy

Using your problem-solving skills to help decrease our bounce rate, increase our conversion rate, and enhance customer engagement

Creating actionable reports – we’re a data-driven organization, so we’ll appreciate you being a stickler for accuracy.

Working with data visualization tools like Google Data Studio, Tableau, and Spreadsheets.

AlgaeCal Healthcare Plan (Premiums Covered 100%!), which you're eligible to sign up for after three months of employment.

Flexible Stat Holidays with the option to bank days for later use.

This Job Will Give You ALL The Feels

SQL and database management (e.g., work with DB objects, creating tables, views, stored procedures, functions, optimization).

Flexible health benefits and wellness program.

Collaborate with cross-functional teams on the development and maintenance of analytics products and solutions.

Create and maintain ETL (Extract, Transform, Load) process to ensure data accuracy and consistency.

Perform data wrangling, data profiling, cleansing and validation to ensure data quality.

Develop, monitor, and troubleshoot data integration and data product processes ensuring quality, performance, and accuracy.

Knowledge of database management principles and experience working with SQL/MySQL databases

Develop strategies for data modeling, design, transport, and implementation to meet requirements for metadata management, operational data stores and ELT/ETL environments

Research modern technologies, data modeling methods and information management systems and recommend changes to company data architectures

Design relational databases to support business enterprise applications and physical data modeling according to business requirements

Understand ad-hoc data requirements and convert it into reporting deliverables

Contribute to a team environment where all team members consistently experience a sense of belonging and inclusion

Hands on experience with query engine internals, transactional storage engines and indexing techniques.

Excellent programming skills in C, C++ or Rust is a must. Familiarity with other languages is an asset.

Experience with data integration from various sources in data lakes.

Work with a small team of highly motivated engineers and researchers.

Participate the design and implementation of analytical database engines.

Validate, evaluate and troubleshoot system designs issues.

At least 1 year of experience leading a team.

Advanced understanding of MySQL databases and extensive experience designing SQL queries

Experience developing a data warehouse

Advanced experience developing data models and dashboards in Power BI

Hands on experience with query engine internals, transactional storage engines and indexing techniques.

Excellent programming skills in C, C++ or Rust is a must. Familiarity with other languages is an asset.

Experience with data integration from various sources in data lakes.

Work with a small team of highly motivated engineers and researchers.

Participate the design and implementation of analytical database engines.

Validate, evaluate and troubleshoot system designs issues.

Bachelor in Economics, Science, Finance, Accounting or business-related field

Years experience in business and/or competitive intelligence roles

Experience in base industrial manufacturing at corporate level is a plus

Strong data manipulation, analysis, and presentation skills (Excel, PowerPoint)

Practical knowledge of data collection, analysis tools such as Tableau, Python, R, and SQL

Forward thinking analytical mind with strong problem-solving skills

- Developing service management framework requirements for Terminal Operations.

- Proven experience gathering, documenting and clarifying requirements from multiple stakeholders using best practice methods and tools;

- Bachelor degree in Business, Computer Science, Business Technology Management, or another relevant program is preferred.

- Experience in operationally-focused transformational projects with complex internal and external stakeholders.

- Experience with Cloud/SaaS and migration strategies;

Occasional meetings in Vancouver must be residing in BC.

Familiar with data warehouse design, database management and distributed systems

Manage the team workflow and ad hoc data requests with a view of streamlining the process and managing stakeholder expectations

At least 3 years of supervisory experience, mentoring and developing teams' careers

Proven experience managing multiple projects and meeting deadlines

You excel at working with non-technical stakeholders to help translate, manage and drive business needs into actionable insights

Extensive experience with BI Tools (Tableau, Power BI, Mixpanel, Excel, Google Sheets)

Analyzing complex statistical reports and/or financial information for management decision-making (using SAS, R, SPSS)

Conducting detailed data analysis to inform management decision-making using Business Intelligence/Analytics Tools such as Power BI and Tableau

Bachelor's Degree with a background in statistics, mathematics, computer science or an acceptable equivalent combination of education and experience.

Advanced knowledge and experience using SQL.

Experience working with student data in higher education environment.

Experience developing data visualizations using Tableau dashboards for higher education.

Collect, blend, and transform data using ETL tools, database management system tools, and code development, such as SQL, Python, and/or C

Incorporate security requirements into design

Minimum three years’ experience data analysis and preparation, including considerable experience with very large data sets of unstructured data

Experience with Azure Data Factory, Databricks, and Data Warehouse

Experience with Reporting and Business Intelligence and visualization tools such as Power BI, QlikSense, SSRS, SSIS and Excel

Experience in data modeling for Analytics

[-] You have hands-on experience with PowerBI or equivalent tool

[-] You are comfortable speaking with various external clients to gather and clarify their requirements

In this role, you’ll work primarily on-site in the Delta, BC office.

[ HOW TO APPLY / INTERVIEW PROCESS ]

Here are some of the items that you'll bring to the table for this role:

[-] You have the ability to document your solutions and create technical documentation

· Provisioning and resource management of Premium Capacity

· Knowledge or experience of machine learning and data science is a plus

· Polished written and verbal communication and presentation skills targeted at all levels of the organization

· Building professional growth by actively acquiring predictive modelling and programming skills

· Facilitating workshops with stakeholders to gather requirements and develop low/high fidelity wireframes

· Experience and proficiency in SQL scripting and Azure is a must

Education, Experience and Technical skills

Design and develop business critical reports and procedures by leveraging deep ETL skills and database knowledge

5+ years of related experience in data analysis, reporting/metrics and decision-making support

Required Soft Skills and Competencies

Excellent verbal and written communication skills

Hands-on experience on .NET C#

mentoring activities including but not limited to Objective Setting and Evaluation, Performance Management, and Skills development planning.

Strong project management skills, with a track record of delivering BI projects on time and within budget.

a structured, technology-enabled work management system to efficiently manage the workload of the team.

Extensive experience in D365, SQL, Power Apps

Relevant certifications in Microsoft Power BI, D365, and Power Apps are highly desirable.

Ability to manage ambiguity, risk, and changing direction of projects and strategies.

Conduct comprehensive data analysis, identify trends, and provide valuable insights to management

Collaborate with cross-functional teams to understand data requirements

Manage and maintain large data sets using SQL and other relevant data tools

Bachelor's degree in Finance, Accounting, Business Administration, Statistics, Mathematics, Computer Science or a related field

Minimum of 3 year of experience in financial analysis, data science or a similar role

Proficiency in SQL and experience working with large data sets

Deep knowledge of the competition and strong experience in market analysis

Skills at creating impactful data visualizations, slides, and documents for a variety of audiences

At least 5 years experience in Edtech, and 2 years experience in competitive intelligence

Boundaryless collaboration and influence skills both within team, peer group and broader organization. Effective communicator with a proven track record of.

Tuition reimbursement of up to $4,000 CAD for continuing education through our Catch the Wave Program

Don't meet every single requirement?

Bachelor's Degree or acceptable combination of equivalent experience.

Excellent development skills and ability to retrieve data from different relational databases

Strong knowledge of MS Excel and data integration programming

Experience with testing user-facing applications

Knowledge of AMS systems: FIS, HRIS or similar SAP-based data administration systems

Working knowledge of API layer, HTML, HTTP REST API, and web development and integration

Strong oral and written communication skills

Excellent analytical and problem-solving skills

Experience with BI tools i.e. (Tableau, Domo, Looker, PowerBI, etc.)

Intermediate to Advanced knowledge of Microsoft Excel

Data visualization and object orientated programming (R, Python, etc.) experience is welcomed but not required

Experience working with online site / clickstream analytics - Google Analytics strongly preferred