The previous SSIS/Python ETL was viewed as antiquated, disjointed and problematic for maintenance and reliability. A modern embedded data solution centered around a user defined data mart which would act as the catalyst for driving informed decision making and supporting prioritized initiatives from executive leaders was seen as the solution. There were two sets of goals, create a self-service data layer for ad hoc questions, a recurring reporting solution and support KPI metric dashboards. The team sought a democratized solution, rapid cycle improvement, scalability, and ability to move from on-prem to cloud when the time came. The solution that stood out was dbt, chosen for its data transformation capabilities. We have successfully created more than a dozen gold-level tables in our production environment with an increase in efficiency and reliability since implementing the open-source solution. The result has improved collaboration, change tracking and version control via Git.