Case Refatoração
Back to cases
Success Story — Banco Carrefour

Banco Carrefour reduces the cost of a dbt process from R$ 400 to R$ 2 per day after migration

ATRA refactored the process and brought this cost down to R$ 1 to 2 per day, a reduction of over 99%.

Challenges

  • O modelo dbt que carrega os dados de contas processa um volume extremamente alto. Na migração, ele foi levado como estava: entregava os dados ao negócio, mas consumia muito processamento a cada execução.
  • O registro de custos do BigQuery mostrava que a maioria das execuções diárias ficava entre R$ 326 e R$ 468. Ao longo do ano, isso somava cerca de R$ 146 mil de custo recorrente, sem nenhum ganho novo para o negócio.

Solution

The solution: refactoring the existing dbt process

ATRA reviewed the implemented dbt process and refactored it, without changing what it delivers to the business. It was an enhancement of an existing process, not a new development.

Refactoring steps · 6 steps

Each step changed how the process reads, organizes, and reprocesses data, and validation confirmed the drop with the exact same delivered data.

(Placeholder to list the titles/descriptions of the 6 technical steps in the page layout, should you wish to detail them.)

The results: from R$ 400 to R$ 2 per day

The daily cost dropped from around R$ 400 to R$ 1 to 2, a reduction of over 99%. Estimated savings exceed R$ 145 thousand per year.

The process became fast, clean, and with guaranteed re-read capability. It continues to deliver the same account data to the business, now with near-zero processing cost.

Migrating does not end the job. Processes moved as-is carry inefficiencies that become costs every single day, and reviewing them post-migration quickly pays off.

Looking to identify bottlenecks and reduce costs on your data platform?

Talk to the ATRA team and discover how to optimize your pipelines without impacting business deliverables.

Results

Mais de 99% de redução no custo diário do processo de carga de dados de contas

De cerca de R$ 400 para R$ 1 a 2 por dia em processamento no BigQuery

Mais de R$ 145 mil por ano de economia estimada

Mesmos dados entregues ao negócio, sem mudança no resultado do processo

About Banco Carrefour

Large Brazilian financial institution offering credit cards and banking services to millions of customers through its own app, focused on optimizing user experience and reducing transaction friction.

Get in touch

Learn more about who we are and how we can shape the future of your business together.