Position Title: Analytics Engineer
Department: Business Intelligence
Direct Manager: Senior Director, Business Intelligence

COMPANY PROFILE:
The Canadian Football League is Canada’s home for professional football. With over a century of rich history and nine member teams across the nation, the CFL provides world-class entertainment and excitement to a passionate and dedicated fan base. A season-long journey of unforgettable moments and must-see-TV broadcasts culminates in Canada’s largest single-day sporting event – the Grey Cup, where the newly crowned champions earn the right to hoist the iconic emblem of Canadian football.

The CFL leads a global movement to grow and modernize the game. The league is committed to a global vision as it connects with fans around the world. It is transforming into a digital-first sports league through an innovative, first-of-its-kind partnership with Genius Sports to maximize fan engagement through data analytics, technological advances, and sports betting.

Just as important as its industry-leading operations, the CFL proudly champions the values on which Canada was built – unity, diversity, inclusion, strength, and service to the community. The league is supportive of all peoples, cultures, and backgrounds, offering a respectful and inclusive working and playing environment, centered on acceptance and understanding. The CFL’s successes are measured not only on the field and within its ranks, but also in its unparalleled impact in affecting positive change and bettering Canadian communities and lives.

POSITION SUMMARY:
The Analytics Engineer will play a leading role in expanding the usage of data across the CFL. This role will sit between a traditional Data Engineering and Data Science role where you will be tasked with working hands on across multiple components of our data stack. There will be a key focus on data modelling, audience creation to support Customer Data Platform initiatives and reporting. You will work with key stakeholders across marketing to leverage data to promote more informed marketing decisions.

The Analytics Engineer will play a leading role in making data accessible to end users for reporting and operational analytics (segmentation/marketing automation). The incumbent will work with internal stakeholders, member clubs and external consultants in planning and building the reporting/audience layer of our data warehouse. Our league wide data warehouse is built to support both league and team data/business needs.

Here’s a bit about our data setup:

  • We are an AWS client: S3 data lake
  • Our data warehouse is in Snowflake
  • Stitch/Fivetran currently used for ELT
  • We’ve recently introduced dbt for transformation
  • We use GitHub
  • Trialfire is implemented for identity management and web/digital tracking (www.trialfire.com)
  • Tableau is being used for Reporting
  • We’ve recently introduced Rudderstack as a CDP

KEY RESPONSIBILITIES:

  • Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models
  • Develop custom dbt data models to define key metrics and dimensions
  • Maintain internal standards for style, maintainability and best practices while writing SQL code
  • Build key reports in Tableau for internal/external stakeholders
  • Collaborate with marketing on insights from campaigns/segmentation strategy
  • Prepare data sets for analysis
  • Leverage our ELT tools for data ingestion

QUALIFICATIONS (KNOWLEDGE, SKILLS, ABILITIES, EXPERIENCE):

  • 3 years of previous Analytics Engineering or Data Analyst experience (sports or ecommerce is a plus)
  • Experience with Snowflake or other Cloud Data Warehouses
  • Advanced SQL knowledge (window functions, date functions etc.)
  • Knowledge of ELT/ETL
  • Experience using Tableau or other Data Visualization Software
  • Experience working with non-technical stakeholders; good communication skills
  • Willingness to learn and adapt to new technologies
  • Experience with dbt core and/or dbt cloud is a plus
  • Experience with python is a plus

LOCATION:
This role is based in Ontario, at the CFL League Office in Toronto (50 Wellington St. East). The successful candidate must be located in Ontario and able to attend the office at least two days per week. In addition, all employees will be required to attend meetings or other business events at the league office or other venues as business needs dictate.

CONTACT:
To be considered for this opportunity, please submit a cover letter and resume to careers@cfl.ca. We thank all applicants for their interest, however, only those selected for an interview will be contacted

We are working to create a more diverse and inclusive work environment and welcome applications from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people living with disabilities and people identifying as LGBTQ2S+.