Skip to main content
Community Award Recipient
Alison Stanton

Alison Stanton

she/her
AVP, Analytics Engineering Lead
Location: Chicago, IL, USA
Organizations: Advocates for SOGIE Data Collection

About

I started programming 20+ years ago. I moved from web applications into transforming data and business intelligence reporting because it's both hard and useful. The majority of my career has been in engineering for SaaS companies. For my last few positions I've been brought in to transition larger, older companies to a modern data platform and ways of thinking. I am dbt Certified. I attend Coalesce and other dbt events virtually. I speak up in dbt Slack and on the dbt-core, dbt-redshift, and dbt-sqlserver repositories. dbt Slack is my happy place, especially #advice-for-dbt-power-users. I care a lot about the dbt documentation and dbt doc.

When did you join the dbt community and in what way has it impacted your career?

I joined the dbt community when I joined an employer in mid-2020. To summarize the important things that dbt has given me: it allowed me to focus on the next set of data challenges instead of staying in toil. Data folks joke that we're plumbers, but we're digital plumbers and that distinction should enable us to be DRY. That means not only writing DRY code like dbt allows, but also having tooling automation to DRY up repetitive tasks like dbt provides.

dbt's existence flipped the experience of data testing on its head for me. I went from a)years of instigating tech discussions on how to systematize data quality checks and b) building my own SQL tests and design patterns, to having built-in mechanisms for data testing.

dbt and the dbt community materials are assets I can use in order to provide validation for things I have, do, and will say about data. Having outside voices to point to when requesting investment in data up-front - to avoid problems later - is an under-appreciated tool for data leader's toolboxes.

dbt's community has given me access to both a) high-quality, seasoned SMEs in my field to learn from and b) newer folks I can help. Both are gifts that I cherish.

What dbt community leader do you identify with? How are you looking to grow your leadership in the dbt community?

I want to be when I grow up:

  • MJ, who was the first person to ever say "data build tool" to me. If I'd listened to her then I could have been part of the dbt community years sooner.

  • Christine Dixon who presented "Could You Defend Your Data in Court?" at Coalesce 2023. In your entire data career, that is the most important piece of education you'll get.

  • The dbt community team in general. Hands-down the most important work they do is the dbt Slack community, which gives me and others the accessibility we need to participate. Gwen Windflower (Winnie) for her extraordinary ability to bridge technical nuance with business needs on-the-fly. Dave Connors for being the first voice for "a node is a node is a node". Joel Labes for creating the ability to emoji-react with ✨ to post to the #best-of-slack channel. And so on. The decision to foster a space for data instead of just for their product because that enhances their product. The extremely impressive ability to maintain a problem-solving-is-cool, participate-as-you-can, chorus-of-voices, international, not-only-cis-men, and we're-all-in-this-together community.

  • Other (all?) dbt labs employees who engage with the community, instead of having a false separation with it like most software companies. Welcoming feedback, listening to it, and actioning or filtering it out (ex. Mirna Wong, account reps). Thinking holistically about the eco-system, not just one feature at a time (ex. Anders). Responsiveness and ability to translate diverse items into technical clarity and focused actions (ex. Doug Beatty, the dbt support team). I've been in software and open source and online communities for a long time - these are rare things we should not take for granted.

  • Josh Devlin for prolificness that demonstrates expertise and dedication to helping.

  • The maintainers of dbt packages like dbt-utils, dbt-expectations, dbt-date, etc.

  • Everyone who gets over their fear to ask a question, propose an answer that may not work, or otherwise take a risk by sharing their voice.

I hope I can support my employer my professional development and my dbt community through the following:

  • Elevate dbt understanding of and support for Enterprise-size company use cases through dialogue, requests, and examples.
  • Emphasize rigor with defensive coding and comprehensive testing practices.
  • Improve the onboarding and up-skilling of dbt engineers through feedback and edits on docs.getdbt.com.
  • Contribute to the maintenance of a collaborative and helpful dbt community as the number of dbt practitioners reaches various growth stages and tipping points.
  • Engage in dialogue. Providing feedback. Champion developer experience as a priority. Be a good open-source citizen on GitHub.

What have you learned from community members? What do you hope others can learn from you?

I have learned:

  • Details on DAG sequencing.
  • How to make an engineering proposal a community conversation.
  • The dbt semantic layer

So many things that are now so engrained in me that I can't remember not knowing them.

I can teach and share about:

  • Naming new concepts and how to choose those names.
  • Reproducibility, reconciliation, and audits.
  • Data ethics.
  • Demographic questions for sexual orientation and/or gender identity on a form. I'm happy to be your shortcut to the most complicated data and most engrained tech debt in history.

I also geek out talking about:

  • reusing functionality in creative ways,
  • balancing trade-offs in data schema modeling,
  • dealing with all of an organization's data holistically,
  • tracking instrumentation, and
  • the philosophy on prioritization.

The next things on my agenda to learn about:

  • Successes and failures in data literacy work. The best I've found so far is 1:1 interactions and that doesn't scale.
  • How to reduce the amount of time running dbt test takes while maintaining coverage. Data ethics. The things you think are most important by giving them a ✨ emoji reaction in Slack.

Anything else interesting you want to tell us?

My gratitude to each community member for this community.

0