FANTASY FOOTBALL EDITION

dbt™ Data Modeling Challenge

Data enthusiasts, it's time to showcase your skills! Join Paradime and Lightdash for an exciting dbt™ data modeling challenge. Derive insights from real fantasy football data and compete win up to $1,500!

FANTASY FOOTBALL EDITION

dbt™ Data Modeling Challenge

Data enthusiasts, it's time to showcase your skills! Join Paradime and Lightdash for an exciting dbt™ data modeling challenge. Derive insights from real fantasy football data and compete win up to $1,500!

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

  1. Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.

  2. Use Snowflake for data warehousing and compute.

  3. Use Paradime to develop dbt™ models.

  4. Use Lightdash to analyze the datasets and create visualizations.

  5. Submit your GitHub repository with code and insights in README.md.

  6. Our expert judges independently score each submission.

  7. Winners announced!


Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.

How It Works

  1. Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.

  2. Use Snowflake for data warehousing and compute.

  3. Use Paradime to develop dbt™ models.

  4. Use Lightdash to analyze the datasets and create visualizations.

  5. Submit your GitHub repository with code and insights in README.md.

  6. Our expert judges independently score each submission.

  7. Winners announced!


Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.

How It Works

  1. Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.

  2. Use Snowflake for data warehousing and compute.

  3. Use Paradime to develop dbt™ models.

  4. Use Lightdash to analyze the datasets and create visualizations.

  5. Submit your GitHub repository with code and insights in README.md.

  6. Our expert judges independently score each submission.

  7. 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:

  • 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:

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:

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:

  • 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).

Time is Running Out! Join the Challenge Now

Time is Running Out! Join the Challenge Now

Time is Running Out! Join the Challenge Now

📣 Please review the entry requirements to ensure you qualify

📣 Please review the entry requirements to ensure you qualify

📣 Please review the entry requirements to ensure you qualify

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?

Get Your Data Workspace Running in Seconds

With easy onboarding and a simple migration process

Get Your Data Workspace Running in Seconds

With easy onboarding and a simple migration process

Get Your Data Workspace Running in Seconds

With easy onboarding and a simple migration process

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.

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.

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.