7-10 years of experience in Data Engineering, Analytics Engineering, ETL, or ELT development.
3-4 years of hands-on experience with dbt and Apache Airflow in production.
Expert-level skills in designing and developing dbt projects.
Advanced knowledge of Snowflake performance optimization and workload management.
Proficiency in Python scripting and automation tools.
Responsibilities
Design and develop scalable dbt projects, including staging and mart layers.
Lead migration of Denodo transformations to dbt and establish best practices.
Optimize SQL queries for performance and cost efficiency.
Develop and maintain Apache Airflow DAGs for workflow orchestration.
Integrate dbt workflows with Airflow for automated data pipelines.
Benefits
Opportunity to lead innovative data transformation initiatives.
Mentorship and support for professional growth within the engineering team.
Collaboration with cross-functional teams to deliver impactful data solutions.
Access to advanced tools and technologies in data engineering.
Full Job Description
Job Summary
We are seeking an experienced Senior Data Engineer with strong expertise in dbt, Snowflake, Apache Airflow, SQL, and Python. This role will be responsible for leading the transition of existing Denodo-based data transformations to dbt, designing scalable data models, building and managing workflow orchestration solutions, optimizing data platforms, and establishing data engineering best practices. The ideal candidate will possess strong technical leadership skills, extensive experience with large-scale data transformation initiatives, and the ability to mentor engineering teams while driving high-quality technical solutions.
Key Responsibilities
Design, develop, and architect scalable dbt projects, including staging, intermediate, and mart layers.
Develop complex dbt models using advanced SQL and implement incremental models, snapshots, Jinja macros, custom tests, seeds, and reusable packages.
Configure and maintain dbt materializations, model dependencies, documentation, and data lineage.
Lead the migration of existing Denodo-based transformations to dbt and establish development standards and best practices.
Develop, deploy, and optimize dbt models on Snowflake.
Implement and maintain Snowflake configurations, including clustering keys, transient tables, warehouse sizing, access controls, roles, and grants.
Optimize SQL queries to improve performance, scalability, and cost efficiency.
Troubleshoot and resolve Snowflake performance and data processing issues.
Design, develop, and maintain Apache Airflow DAGs and workflow orchestration solutions.
Integrate dbt workflows with Airflow to support automated data pipeline execution.