Data Engineer (Snowflake & DBT)

Description

Job Summary: We are seeking a Data Engineer specialized in dbt and Snowflake to design, develop, and optimize data models and pipelines, collaborating on modern analytical architectures. Key Highlights: 1. Specialization in dbt and Snowflake 2. Working with cutting-edge technology and continuous training 3. Professional growth and career development Hello, Data Lover! Would you like to specialize in **dbt and Snowflake** and take your Data Engineering career to the next level? At SDG Group, we are global leaders in Big Data, Business Intelligence, and Analytics. Since 1994, we have supported major companies in their digital transformation, turning data into high-impact solutions through our strategic partnerships with Microsoft, Google, and AWS. ️ **What will your day-to-day look like?** You will design and develop models in **dbt**, applying best practices for modularization, documentation, testing, and metadata-driven transformation. You will build and optimize pipelines in **Snowflake**, handling large volumes of data while ensuring performance, scalability, and cost control. You will participate in designing modern analytical architectures (ELT approach), implementing dimensional models (Kimball) and structures optimized for reporting and advanced analytics. You will implement automated testing, quality control, and code versioning, applying engineering principles (Git, CI/CD, dev/prod environments). You will collaborate with business, BI, and Analytics professionals to translate requirements into robust, well-structured analytical models. You will contribute to continuous improvement of the data framework: modeling standards, conventions, query optimization, and best practices for Snowflake and dbt. ️ **What will make you succeed in this role?** Between **3 and 6 years of experience as a Data Engineer** working in cloud environments. Solid hands-on experience with **dbt** (models, macros, tests, sources, documentation, refactoring). Practical experience with **Snowflake** (modeling, performance tuning, clustering, logical partitioning, role and warehouse management). Knowledge of dimensional modeling (Kimball) and design of analytical data marts. Experience working with the modern **ELT approach**. Strong proficiency in advanced SQL (optimization, CTEs, window functions, query tuning). Experience with version control (Git) and collaborative environments. **Sufficient English proficiency to work on international projects.** ️ We also value: Experience with orchestrators such as Airflow or similar tools. Knowledge of Data Quality practices and automated testing. Previous experience in consulting or working with multiple clients. Certifications in Snowflake or dbt. **What makes us different?** **Technology and data are our essence.** We don’t just work with the latest market tools—we train you to master the most innovative ones. We have an Innovation Unit where we explore new alliances with technology giants and **R\+D centers.** **You set the pace.** Forget rigid structures. Every semester, you’ll meet with your manager to discuss your achievements, new challenges, and… **performance-based salary adjustments!** **You’ll learn from industry leaders.** You’ll join teams with deep expertise both technically and commercially, who will share knowledge and celebrate your growth. **We are a purpose-driven company.** We believe diversity and inclusion fuel creativity, enabling us to overcome any challenge. **And, just to top it off…** Permanent contract (we want you to stay for a long time!) **Location: Madrid.** Hybrid / flexible work model. Intensive working hours in July and August, plus Fridays. Salary based on your education and experience, with performance-based reviews. Financial support for remote work. Access to training, official certifications, conferences, and courses. If you’re looking for a place to grow, innovate, and feel part of something big… this is it!