Open to opportunities

Lohan Lucas

@lohanlucas

Message

I build reliable Snowflake and dbt data models for business analytics.

Brazil

Message

What I'm looking for

I'm looking to build reliable data platforms and analytical models using Snowflake, dbt, SQL, and cloud tools, while collaborating with multidisciplinary teams and continuing to grow in data engineering, governance, and BI.

At M. Dias Branco, I build and maintain Snowflake and dbt data pipelines that turn SAP QM and MII source data into reliable analytical models for business teams and BI tools.

I've implemented dimensional models with surrogate keys and SCDs, data-quality testing in dbt, and complex SQL logic for commercial-budget allocation models. I also design RBAC and Row Access Policies, helping strengthen data governance and secure access.

I work across ELT pipelines, lineage documentation, incremental-model debugging, and validation of CSV and Parquet data from corporate systems. My approach combines data modeling, performance and cost considerations, and collaborative version control through Git and Azure DevOps.

Previously, as a Data Intern at M. Dias Branco, I supported layered dbt models, SAP and MII integrations, Snowflake Parquet loads, schema validation, and technical field-lineage documentation. I bring hands-on experience with Snowflake, dbt, SQL, Python, AWS, Azure, and Power BI.

Experience

Work history, roles, and key accomplishments

Current

Engenheiro Analítico

Current

M. Dias Branco

May 2026 - Present (3 months)

Developed and maintained data pipelines for quality inspection in Snowflake/dbt, integrating SAP QM and MII sources with dimensional modeling and data lineage documentation. Implemented data quality tests, complex SQL logic, RBAC, and materialization strategies to optimize performance and governance.