BUSINESS INTELLIGENCE ANALYST
Summary
Position Title: Business Intelligence Analyst
Department: Data, IT and Services
Status: Full-time/ Permanent
Reports to: Software Development Manager
Location: Toronto, ON (Hybrid)
Company Descripton
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
In this role, the incumbent will play a crucial part in transforming raw data into actionable insights that drive strategic business decisions. You will leverage your expertise in SQL, DBT, Tableau, and data transformation techniques to build and maintain robust data pipelines and insightful dashboards. The position reports to the Software Development Manager.
Responsbilities
Data Transformation and Modeling:
- Design, develop, and maintain data transformations using DBT (Data Build Tool) to ensure data quality and consistency.
- Build and optimize complex SQL queries for data extraction, manipulation, and analysis.
- Develop and maintain data models that support business reporting and analytical needs.
- Implement data validation and quality checks to ensure accuracy and reliability.
Business Intelligence And Reporting
- Develop interactive and insightful dashboards and reports using Tableau to visualize key performance indicators (KPIs) and trends.
- Collaborate with stakeholders to understand their reporting requirements and translate them into effective BI solutions.
- Conduct ad-hoc data analysis to answer business questions and provide actionable insights.
- Monitor and optimize the performance of BI dashboards and reports.
Data Pipeline Development And Maintenance
- Design and implement efficient and scalable data pipelines to ingest, transform, and load data from various sources.
- Troubleshoot and resolve data pipeline issues, ensuring data availability and reliability.
- Participate in the development and maintenance of data warehousing solutions.
- Work with cloud-based data warehouses.
Collaboration And Communication
- Collaborate with data engineers, analysts, and business stakeholders to understand data needs and deliver effective solutions.
- Communicate complex data concepts and findings clearly and concisely to both technical and non-technical audiences.
- Document data processes, transformations, and reporting methodologies.
Qualifications & Skills
- Bachelor’s degree in Computer Science, Information Systems, Statistics, or a related field.
- Demonstrable experience transforming raw data into usable business information.
- Strong proficiency in SQL for data extraction, manipulation, and analysis.
- Expertise in creating interactive dashboards and reports using Tableau or similar applications.
- Solid understanding of data warehousing concepts and data modeling principles.
- Experience with data transformation techniques and best practices.
- Experience with S3 (as a data lake), Snowflake, DBT will be beneficial.
- Experience with Python or other scripting languages for data processing.
- Familiarity with cloud-based data platforms (e.g., AWS, Azure, GCP).
Other Considerations
- Hybrid Model: The incumbent will be required to attend the office at least two (2) days per week. In addition, you are required to attend meetings an other business events at the office or other venues as business needs dictate.
- Work Schedule: Due to the nature of the business, the incumbent must be available and willing to work evenings, weekends and holidays as required
- Travel: The incumbent may be required to travel to CFL pillar events, including but not limited to CFL Combine, Grey Cup Playoffs and Grey Cup.
Contact
To be considered for this opportunity, please submit a cover letter and resume. We thank all applicants for their interest, however, only those selected for an interview will be contacted.
The Canadian Football League is an equal opportunity employer, and we are working to create a more diverse and inclusive work environment. We welcome applications from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people living with disabilities and people identifying as LGBTQ2S+.
For additional information on the Canadian Football League, please visit our website at www.cfl.ca.
