Technical Consultant – BI & Analytics

Fastloop; Vancouver; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Technical Consultant specializing in BI & Analytics to join their dynamic team. This role involves leveraging advanced data analysis and visualization tools to drive impactful business insights. You will be responsible for developing dashboards, managing projects, and collaborating closely with clients to ensure successful outcomes. The ideal candidate will possess a strong background in data modeling, SQL, and various BI platforms, along with a passion for transforming data into actionable strategies. If you thrive in a fast-paced environment and enjoy tackling complex challenges, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in data analysis or business intelligence.
• Strong proficiency in SQL and data modeling best practices.
• Experience with data visualization tools like Tableau and Power BI.

Responsibilities

• Develop dashboards and reports using Power BI, Tableau, and Looker.
• Coordinate with project team members and manage deliverables.
• Create technical documentation and training materials.

Skills

Data Analysis

Business Intelligence

SQL

Data Visualization

Python

Data Modeling

ETL Processes

Project Management

Education

Bachelor’s degree in Business

Bachelor’s degree in Information Systems

Bachelor’s degree in Statistics

Bachelor’s degree in Mathematics

Bachelor’s degree in Computer Science

Bachelor’s degree in Economics

Tools

Power BI

Tableau

Looker Studio

Snowflake

BigQuery

Redshift

Databricks

Job description

At Fastloop, we have a deep passion for helping businesses build their future. We use leading technologies and best-in-class business expertise within our three core pillars of service excellence: Data, Analytics and AI (including Generative AI and Machine Learning).

As a boutique consultancy, our client engagements cover a broad spectrum of the modern data stack, leveraging platforms like Google Cloud to quickly and iteratively produce Analytics and AI outcomes for our clients.

Fastloop’s consulting model requires a team who is willing and able to work quickly, across new industries/verticals, with emerging technologies, in a fast, agile fashion. All team members must be extremely proactive, willing to explore the unknown and comfortable adapting to changing technical and functional requirements.

Fastloopers are technology and consulting experts who want to understand how our customers' companies operate from the inside out. We are passionate about adding significant operational value, treating our clients' businesses as our own. We are problem solvers who like to roll up our sleeves and accelerate digital transformation journeys - always leveraging data as our foundation.

About the Opportunity:

The Technical Consultant – BI & Analytics is responsible for identifying the existing relationships across enterprise-wide entities, crossing multiple disparate systems, and identifying the best approach for modeling data in the data warehouse/data lake. The approach should balance performance, flexibility, and complexity in its design, and enable the data to be utilized in a variety of analytics initiatives, including but not limited to baseline reporting in BI platforms to advanced analytics.

The successful candidate will be responsible for the following activities:

BI Development

• Facilitate data and visualization requirements.
• Develop dashboards and reports using tools like Power BI, Tableau and Looker Studio.
• Demonstrate dashboarding best practices.
• Perform data validation and QA duties.
• Lead or participate in technical data discovery sessions, attend client meetings, contribute in driving the overall project outcomes.
• Demonstrate a strong proficiency in data management best practices.
• Demonstrate a strong proficiency in SQL to query and build data models.

Client and Project Management

• Coordinate with other project team members, track deliverables, manage tasks and deliverables.
• Work collaboratively with client stakeholders.

Documentation & Training

• Develop technical documentation, training materials, and support knowledge transfer activities.
• Be able to communicate and collaborate across technical and functional roles and departments for successful outcomes.

What you'll need to succeed:

• 5+ years of experience in data analysis, business intelligence, or a similar analytical role.
• Strong proficiency with Data Modelling from conceptual modeling to logical data model design and implement physical data models.
• Knowledge of data visualization tools and BI platforms.
• Advanced proficiency in SQL for data extraction and manipulation.
• Strong experience with data visualization tools such as Tableau, Power BI, or Looker.
• Solid understanding of various data modelling methodologies (e.g. Kimball, Inmon).
• Proficiency in Python for data analysis.
• Experience working with large datasets and modern data warehouses (e.g., Snowflake, BigQuery, Redshift, Databricks).
• Familiarity with ETL processes, and data pipeline design is a plus.
• Experience in retail marketing or digital marketing is a plus.
• Bachelor’s degree in Business, Information Systems, Statistics, Mathematics, Computer Science, Economics or a related field.

Ready to join the team?

Name Email Address Phone What Technology are you excited about? Upload Your Resume Max file size 10MB.