Data Engineer: Snowflake & DBT Pipeline Expert

Ethereum Technologies; Plano (TX); Presencial; USD 120.000 - 190.000; Jornada completa

Descripción de la vacante

Ethereum Technologies is seeking an experienced Data Engineer to design scalable data models and pipelines aligned with business goals. You will develop complex DBT models, optimize Snowflake configurations, and implement data quality frameworks.

Collaboration with leadership to translate requirements into technical solutions and mentoring juniors are key aspects of this role. Responsibilities include performance tuning, building reusable DBT components, reviewing PRs, and documenting data

Formación

• SQL with advanced features (CTEs, joins, analytic/windowing functions).
• Python experience, preferably intermediate or higher.
• Snowflake real-world experience preferred.
• Data profiling to identify keys, cardinality, precision, scale, and data skew.
• Strong communication within the team and with other groups.
• Understanding of product scope and QA for end-to-end delivery.

Responsabilidades

• Design and implement scalable data models and pipelines that align with business objectives.
• Develop complex DBT models using advanced features (macros, packages, custom materializations).
• Collaborate with business leaders to translate complex requirements into technical solutions; identify and resolve performance bottlenecks in Snowflake queries and DBT models.
• Optimize Snowflake warehouse configurations and query performance.
• Design and implement data quality frameworks and testing strategies.
• Create reusable DBT packages and macros for team-wide use.
• Review and approve pull requests from junior team members.
• Troubleshoot production issues and implement long-term solutions.
• Document architectural decisions and data lineage.

Conocimientos

SQL

CTEs

Complex joins

Analytic functions

Windowing functions

Python

Snowflake

Data profiling

Communication

QA understanding

Descripción del empleo

Ethereum Technologies is seeking an experienced Data Engineer to design scalable data models and pipelines aligned with business goals. You will develop complex DBT models, optimize Snowflake configurations, and implement data quality frameworks.

Collaboration with leadership to translate requirements into technical solutions and mentoring juniors are key aspects of this role. Responsibilities include performance tuning, building reusable DBT components, reviewing PRs, and documenting data