





FANTASY FOOTBALL EDITION
dbt™ Data Modeling Challenge
The Data Modeling Challenge has ended – stay tuned for the next one!



FANTASY FOOTBALL EDITION
dbt™ Data Modeling Challenge
The Data Modeling Challenge has ended – stay tuned for the next one!















Why Join This Challenge?
- Showcase your SQL, dbt™, and analytics expertise
- Work with cutting-edge data tools
- Analyze real-world fantasy football data
- Win Amazon gift cards worth up to $1,500
- Build your portfolio and career prospects
- Network with like-minded industry professionals
Challenge Overview
Welcome to the dbt™ Data Modeling Challenge—Fantasy Football Edition! This global competition invites data practitioners to transform raw fantasy football data into powerful insights. Use Paradime, Snowflake, and Lightdash to craft SQL queries, develop dbt™ models, and create compelling visualizations. Uncover trends and tell data-driven stories that will wow the judges for a chance to win $1,500.
Key dates:
Start: January 2, 2025
Submission Deadline: February 4, 2025, 11:59 PM PT
Winners Announced: February 6, 2025 (Right before the Superbowl!)
Welcome to the dbt™ Data Modeling Challenge - Fantasy Football Edition! This global competition invites data practitioners to transform raw fantasy football data into powerful insights. Use Paradime, Snowflake, and Lightdash to craft SQL queries, develop dbt™ models, and create compelling visualizations. Uncover trends and tell data-driven stories that will wow the judges for a chance to win $1,500.
Key dates:
Start: January 2, 2025
September 9, 2024, at 11:59 PM PT
Winners Announced: September 12, 2024
Welcome to the dbt™ Data Modeling Challenge - Fantasy Football Edition! This global competition invites data practitioners to transform raw fantasy football data into powerful insights. Use Paradime, Snowflake, and Lightdash to craft SQL queries, develop dbt™ models, and create compelling visualizations. Uncover trends and tell data-driven stories that will wow the judges for a chance to win $1,500.
Key dates:
Start: January 2, 2025
September 9, 2024, at 11:59 PM PT
Winners Announced: September 12, 2024






Prizes
Show off your data skills and win big!
#1
$1,500 USD
#2
$1,000 USD
#3
$500 USD
Ready, Set, Analyze
January 2, 2025
Submission Deadline
February 4, 2025, 11:59 PM PT
Winners Announcement
February 6, 2025

How It Works
Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.
Use Snowflake for data warehousing and compute.
Use Paradime to develop dbt™ models.
Use Lightdash to analyze the datasets and create visualizations.
Submit your GitHub repository with code and insights in README.md.
Our expert judges independently score each submission.
Winners announced!
Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.

How It Works
Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.
Use Snowflake for data warehousing and compute.
Use Paradime to develop dbt™ models.
Use Lightdash to analyze the datasets and create visualizations.
Submit your GitHub repository with code and insights in README.md.
Our expert judges independently score each submission.
Winners announced!
Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.

How It Works
Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.
Use Snowflake for data warehousing and compute.
Use Paradime to develop dbt™ models.
Use Lightdash to analyze the datasets and create visualizations.
Submit your GitHub repository with code and insights in README.md.
Our expert judges independently score each submission.
Winners announced!
Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.

Who Should Participate?
Data Analysts
Analytics Engineers
Data Engineers
Data Scientists
Anyone passionate about data and fantasy football!
This is a solo challenge to showcase your individual talents. Participants should have hands-on experience with SQL, dbt™, and Git.

Who Should Participate?
Data Analysts
Analytics Engineers
Data Engineers
Data Scientists
Anyone passionate about data and fantasy football!
This is a solo challenge to showcase your individual talents. Participants should have hands-on experience with SQL, dbt™, and Git.

Who Should Participate?
Data Analysts
Analytics Engineers
Data Engineers
Data Scientists
Anyone passionate about data and fantasy football!
This is a solo challenge to showcase your individual talents. Participants should have hands-on experience with SQL, dbt™, and Git.

Tools You'll Use
While these tools are required in this competition, we encourage you to use additional tools and technologies to enhance your project.
Paradime: The AI-powered, one-stop-shop analytics engineering platform for dbt™.
Snowflake: Industry-leading cloud data platform for secure and scalable data warehousing.
Lighthouse: The open-source business intelligence tool that brings your dbt™ metrics to life with powerful visualizations and collaborative features.
GitHub: Version control and project submission

Tools You'll Use
While these tools are required in this competition, we encourage you to use additional tools and technologies to enhance your project.
Paradime: The AI-powered, one-stop-shop analytics engineering platform for dbt™.
Snowflake: Industry-leading cloud data platform for secure and scalable data warehousing.
Lighthouse: The open-source business intelligence tool that brings your dbt™ metrics to life with powerful visualizations and collaborative features.
GitHub: Version control and project submission

Tools You'll Use
While these tools are required in this competition, we encourage you to use additional tools and technologies to enhance your project.
Paradime: The AI-powered, one-stop-shop analytics engineering platform for dbt™.
Snowflake: Industry-leading cloud data platform for secure and scalable data warehousing.
Lighthouse: The open-source business intelligence tool that brings your dbt™ metrics to life with powerful visualizations and collaborative features.
GitHub: Version control and project submission

Judges Panel and Judging Criteria
Our challenge will be evaluated by an esteemed panel of industry experts:

Parker Rogers
Data, Paradime

Oliver Laslett
Co-Founder & CTO, Lightdash

Joshua Lee
Head of Analytics at The Undroppables

Marta Paes
Senior Product Manager, Materialize
Value of insights (1-10):
Are the insights interesting and relevant? Get creative! Uncover something fun and accurate that you'd find compelling in fantasy football analysis.
Complexity of insights (1-10):
Are you creating relationships between datasets and providing in-depth analytical conclusions? While complexity doesn't equal value, using multiple datasets can enhance insights.
Quality of materials (1-10):
Is your code of professional quality? Are your data visualizations well-designed? Are your insights clear to the reader?
Integration of new data (1-10):
How effectively have you integrated new, relevant data to enhance your project? Adding additional datasets can positively influence other scoring criteria.
For a detailed breakdown, refer to the full challenge details below.

Judges Panel and Judging Criteria
Our challenge will be evaluated by an esteemed panel of industry experts:

Parker Rogers
Data, Paradime

Oliver Laslett
Co-Founder & CTO, Lightdash

Joshua Lee
Head of Analytics at The Undroppables

Marta Paes
Senior Product Manager, Materialize
Judging Criteria:
Value of insights (1-10): Are the insights interesting and relevant? Get creative! Uncover something fun and accurate that you'd find compelling in fantasy football analysis.
Complexity of insights (1-10): Are you creating relationships between datasets and providing in-depth analytical conclusions? While complexity doesn't equal value, using multiple datasets can enhance insights.
Quality of materials (1-10): Is your code of professional quality? Are your data visualizations well-designed? Are your insights clear to the reader?
Integration of new data (1-10): How effectively have you integrated new, relevant data to enhance your project? Adding additional datasets can positively influence other scoring criteria.
For a detailed breakdown of each criterion, please refer to the full challenge details below. Our judges are looking for creative, insightful, and well-executed projects that demonstrate your data modeling and analysis skills. Good luck!
Judging Criteria:
Value of insights (1-10): Are the insights interesting and relevant? Get creative! Uncover something fun and accurate that you'd find compelling in fantasy football analysis.
Complexity of insights (1-10): Are you creating relationships between datasets and providing in-depth analytical conclusions? While complexity doesn't equal value, using multiple datasets can enhance insights.
Quality of materials (1-10): Is your code of professional quality? Are your data visualizations well-designed? Are your insights clear to the reader?
Integration of new data (1-10): How effectively have you integrated new, relevant data to enhance your project? Adding additional datasets can positively influence other scoring criteria.
For a detailed breakdown of each criterion, please refer to the full challenge details below. Our judges are looking for creative, insightful, and well-executed projects that demonstrate your data modeling and analysis skills. Good luck!

Judges Panel and Judging Criteria
Our challenge will be evaluated by an esteemed panel of industry experts:

Parker Rogers
Data, Paradime

Oliver Laslett
Co-Founder & CTO, Lightdash

Joshua Lee
Head of Analytics at The Undroppables

Marta Paes
Senior Product Manager, Materialize
Judging Criteria:
Value of insights (1-10): Are the insights interesting and relevant? Get creative! Uncover something fun and accurate that you'd find compelling in fantasy football analysis.
Complexity of insights (1-10): Are you creating relationships between datasets and providing in-depth analytical conclusions? While complexity doesn't equal value, using multiple datasets can enhance insights.
Quality of materials (1-10): Is your code of professional quality? Are your data visualizations well-designed? Are your insights clear to the reader?
Integration of new data (1-10): How effectively have you integrated new, relevant data to enhance your project? Adding additional datasets can positively influence other scoring criteria.
For a detailed breakdown of each criterion, please refer to the full challenge details below. Our judges are looking for creative, insightful, and well-executed projects that demonstrate your data modeling and analysis skills. Good luck!
Judging Criteria:
Value of insights (1-10): Are the insights interesting and relevant? Get creative! Uncover something fun and accurate that you'd find compelling in fantasy football analysis.
Complexity of insights (1-10): Are you creating relationships between datasets and providing in-depth analytical conclusions? While complexity doesn't equal value, using multiple datasets can enhance insights.
Quality of materials (1-10): Is your code of professional quality? Are your data visualizations well-designed? Are your insights clear to the reader?
Integration of new data (1-10): How effectively have you integrated new, relevant data to enhance your project? Adding additional datasets can positively influence other scoring criteria.
For a detailed breakdown of each criterion, please refer to the full challenge details below. Our judges are looking for creative, insightful, and well-executed projects that demonstrate your data modeling and analysis skills. Good luck!

Entry Requirements
Participants must be current or former data professionals (Data Analysts, Analytics Engineers, Data Engineers, Data Scientists, etc.).
Solo participation only (no teams).
Must have hands-on experience with SQL, dbt™, and Git.
Participants must use, but are not limited to, the following tools:
Paradime for SQL & dbt™ development.
Snowflake for data storage and compute.
Lightdash for data analysis and visualizations.
GitHub repository for version control.
Must be able to explain their code and insights. You can use ChatGPT, but you better understand it! 🤣

Entry Requirements
Participants must be current or former data professionals (Data Analysts, Analytics Engineers, Data Engineers, Data Scientists, etc.).
Solo participation only (no teams).
Must have hands-on experience with SQL, dbt™, and Git.
Participants must use, but are not limited to, the following tools:
Paradime for SQL & dbt™ development.
Snowflake for data storage and compute.
Lightdash for data analysis and visualizations.
GitHub repository for version control.
Must be able to explain their code and insights. You can use ChatGPT, but you better understand it! 🤣

Entry Requirements
Participants must be current or former data professionals (Data Analysts, Analytics Engineers, Data Engineers, Data Scientists, etc.).
Solo participation only (no teams).
Must have hands-on experience with SQL, dbt™, and Git.
Participants must use, but are not limited to, the following tools:
Paradime for SQL & dbt™ development.
Snowflake for data storage and compute.
Lightdash for data analysis and visualizations.
GitHub repository for version control.
Must be able to explain their code and insights. You can use ChatGPT, but you better understand it! 🤣

Challenge Deliverables
Participants are expected to submit:
A GitHub Repository containing:
Code: our dbt™ models and any other applicable scripts (Example).
README.md: A narrative of your submission—how you built it, what you built, and the insights you discovered (with visualizations).

Challenge Deliverables
Participants are expected to submit:
A GitHub Repository containing:
Code: our dbt™ models and any other applicable scripts (Example).
README.md: A narrative of your submission—how you built it, what you built, and the insights you discovered (with visualizations).

Challenge Deliverables
Participants are expected to submit:
A GitHub Repository containing:
Code: our dbt™ models and any other applicable scripts (Example).
README.md: A narrative of your submission—how you built it, what you built, and the insights you discovered (with visualizations).
FAQs
For technical support, visit Paradime's #fantasy-football-challenge Slack channel or the Lightdash Community. Participants can use additional tools and data sources to enhance their projects. However, all submissions must be individual work.
How can I obtain technical support?
Is seeking external assistance permitted?
Am I allowed to incorporate additional data?
Do participants begin from scratch?
Am I allowed to incorporate additional data sources?
Is this event a hackathon?
If I win, how will I receive a gift card?
What are some key strategies for developing insights from fantasy football data sets?
How can I obtain technical support?
Is seeking external assistance permitted?
Am I allowed to incorporate additional data?
Do participants begin from scratch?
Am I allowed to incorporate additional data sources?
Is this event a hackathon?
If I win, how will I receive a gift card?
What are some key strategies for developing insights from fantasy football data sets?
How can I migrate from e.g. dbt™ Cloud to Paradime?
Do you have SLA guarantees? What support will I get?
Do I need to host dbt™ Core?
How can I obtain technical support?
Is seeking external assistance permitted?
Am I allowed to incorporate additional data?
Do participants begin from scratch?
Am I allowed to incorporate additional data sources?
Is this event a hackathon?
If I win, how will I receive a gift card?
What are some key strategies for developing insights from fantasy football data sets?
Test Drive Paradime Today
Start our free 14-day trial and experience the power of AI in analytics
Test Drive Paradime Today
Start our free 14-day trial and experience the power of AI in analytics
Test Drive Paradime Today
Start our free 14-day trial and experience the power of AI in analytics
Resources
Industries
Copyright © 2025 Paradime Labs, Inc.
Made with ❤️ in San Francisco ・ London
*dbt® and dbt Core® are federally registered trademarks of dbt Labs, Inc. in the United States and various jurisdictions around the world. Paradime is not a partner of dbt Labs. All rights therein are reserved to dbt Labs. Paradime is not a product or service of or endorsed by dbt Labs, Inc.
Resources
Industries


Copyright © 2025 Paradime Labs, Inc.
Made with ❤️ in San Francisco ・ London
*dbt® and dbt Core® are federally registered trademarks of dbt Labs, Inc. in the United States and various jurisdictions around the world. Paradime is not a partner of dbt Labs. All rights therein are reserved to dbt Labs. Paradime is not a product or service of or endorsed by dbt Labs, Inc.
Resources
Industries


Copyright © 2025 Paradime Labs, Inc.
Made with ❤️ in San Francisco ・ London
*dbt® and dbt Core® are federally registered trademarks of dbt Labs, Inc. in the United States and various jurisdictions around the world. Paradime is not a partner of dbt Labs. All rights therein are reserved to dbt Labs. Paradime is not a product or service of or endorsed by dbt Labs, Inc.