Analytics Engineer
It’s an incredibly exciting time to be part of the Canadian Football League as we take to the field for our 2023 season. At the CFL we have deep Canadian roots and a proud legacy spanning more than 100 years. We play to win, we’re driven and resilient. We’re pursuing a bold vision and paradigm shift that will pave the way to success. We’re growing the game of football, forging strategic alliances and reimagining the future powered by data, digital and technology. We support our nine member clubs with a relentless focus on revenue growth and long-term success.
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 initatives 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 critical 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.
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 Accountabilities:
• 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, maintanability 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:
• 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
• Collaborative with proven relationship building 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
• Experience with Meltano ELT is a plus