Senior Data Analyst


Full Time

At Fastloop, we have a deep passion for helping businesses build for the future. 

This comes to life based on our adoption of leading technologies and best-in class business expertise within our three core pillars of excellence: Big Data, Cloud Technology and Advanced Analytics.  

We are not your typical consultants. We are business operators and technology experts who understand how businesses work from the inside.  

Fastloopers are problem solvers and like to roll up their sleeves and get in the trenches with our customers. We genuinely enjoy helping organizations make sense of their data and their infrastructure, so they can realize new competitive advantages and accelerate their digital transformation journeys. 

Fastloop is based in Vancouver, Canada, but provides a flexible and hybrid working environment to candidates across North America.

About the Opportunity

We are looking for a Senior Data Analyst interested in data model design, data exploration, and data visualization. The Data Analyst will work closely with a diverse team of cloud architects, data engineers, and business analysts to help consult mid-market enterprise businesses create new data strategies.

This work will involve the development, implementation, and transition of analytical processes to a cloud-based data warehouse and/or data lake where the data will be made available to other analytics initiatives and BI platforms (Power BI, Looker, Qlik, etc.). The Data Analyst must be comfortable working closely with technical and less-technical business users in client settings, for the purpose of defining data and modelling requirements to enable use cases and client objectives.

The Data Analyst is responsible for identifying the existing relationships across enterprise-wide entities, crossing multiple disparate systems, and identifying the best approach for normalizing and denormalizing data into 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.

  • Design and lead the creation of enterprise-wide data models, identifying and mapping new relationship across systems;
  • Prepare accurate data modeling design and architecture strategies for stakeholders and business functions;
  • Create Entity-Relational Diagrams (ERDs) for systems that will be ingested into a cloud-based data warehouse and/or data lake;
  • Aide in the development and implementation of an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, data warehouse/data lake normalization / denormalization best practices, data governance, and management of data warehouses and data analytics (BI) systems;
  • Determine the normalization and denormalization approaches for data being moved into data warehouse and/or data lake environments;
  • Recommend solutions to improve new and existing data warehouse and data lake systems;
  • Design models that reduce data redundancy, streamline data movements, and improve information management;
  • Identifying data sources, both internal and external, and creating a plan for data management that is aligned with organizational data strategy;
  • Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise-wide data warehousing/data lake initiative;
  • Defining and managing the flow of data and dissemination of information within the organization; and,
  • Conducting a continuous audit of analytics system performance, refining whenever required, and work to resolve these issues.
  • Aiding in the creation of an end-to-end data architecture, from selecting the platform, designing the technical architecture, and testing and implementing the proposed analytics solution;
  • Integrating data governance best practices including data accessibility, integrity, quality, and security;
  • Acting as a data consultant, working directly with the client for requirements gathering, presentations, training and iterative feedback.
  • Working closely with businesses to enable them to take more control over their analytics needs
  • Prepare report wireframe/proof-of-concepts based on initial project requirements and branding guides
  • Build operational dashboards as self-service tools to analyze and present data associated with customer experience, business operations, and strategic decision making. 
  • Research and stay up to date on relevant industry standards and trends seen across tools in BA/BI

What You’ll Need to Succeed


  • 5+ years of experience in using analytics to solve problems, understand user behavior and drive business decisions
  • 5+ years working directly on data modeling design and company-wide Business Intelligence (BI) initiatives;
  • Completed Undergraduate degree, including mathematics, statistics, computer science or related field;
  • Excellent knowledge and hands-on experience with SQL-based projects;
  • Extensive experience in designing and implementation of data modeling solutions using relational, dimensional, and NoSQL databases;
  • Data modeling / database design experience, ideally with Looker, Power BI, or Tableau experience;
  • Experience working with private and sensitive personal information (PII data);
  • Experience developing best practices for data coding to ensure consistency within systems;
  • Experience evaluating implemented data systems for variances, discrepancies, and efficiency;
  • Experience Troubleshooting and optimizing data systems;
  • Experience with data governance and metadata management;
  • Confidence in decision making and the ability to explain processes or choices as needed; and,
  • Excellent Interpersonal and communication client-facing skills
  • Strong conceptual and analytical skills - demonstrating out of the box problem solving skills 
  • Experience working with and creating entity relationship diagrams and data models for analytical purposes
  • Ability to develop high quality dashboards
  • Strong written and verbal communication
  • Excellent time management 
  • Team-player with experience collaborating across teams and job roles
  • Ability to work in highly flexible, consulting environment; and,  
  • Passion for technology, business, customer experience, innovation, and digital solutions.  

Nice to have: 

  • Programming in R and Python 
  • Machine Learning modelling experience 
  • Experience with Google Cloud, Azure, Snowflake, or Amazon Web Service
  • Experience with cloud-based data warehousing and data lake environments; and,
  • Experience with ETL/ELT processes in Google Cloud, Amazon Web Services, and/or Azure.
  • Experience with Looker and/or Looker Studio

Thank you for your interest in Fastloop. Due to a high number of candidates, we will only contact those who will be shortlisted for interviews.

Ready to join the team?

Max file size 10MB.
Upload failed. Max size for files is 10 MB.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.