What are the responsibilities and job description for the Senior Snowflake DBT Engineer- Fulltime - Onsite to Phoenix, AZ position at Mastek?
Job Title: Senior Snowflake DBT Engineer
Location: Phoenix, AZ
Job Type: Full-time
Job Summary:
We are seeking a highly skilled and experienced Senior Snowflake DBT Engineer to join our data engineering team. The ideal candidate will have a strong background in cloud data warehousing, data modeling, and ELT processes, with specific expertise in Snowflake and DBT (Data Build Tool). You will play a crucial role in designing, building, and optimizing scalable data solutions to support business intelligence and analytics.
Key Responsibilities:
Design and develop robust data models in Snowflake to support business reporting and analytics.
Implement data transformation pipelines using DBT, ensuring modularity, reusability, and scalability.
Optimize Snowflake queries and data models for performance and cost efficiency.
Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and translate them into effective solutions.
Manage and version-control data models and transformations using Git.
Ensure data quality and integrity through effective testing and validation practices.
Monitor and troubleshoot data pipelines, resolving issues proactively.
Document data models, processes, and workflows to maintain transparency and knowledge sharing within the team.
Mentor junior data engineers, fostering a culture of continuous learning and improvement.
Required Skills and Qualifications:
Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.
8 years of experience in data engineering, with at least 2 years focused on Snowflake and DBT.
Strong proficiency in SQL and data modeling concepts.
Hands-on experience with cloud platforms, particularly AWS.
Solid understanding of ELT/ETL workflows and data pipeline orchestration.
Proficiency with version control systems, particularly Git.
Familiarity with CI/CD practices for data engineering.
Strong problem-solving skills and the ability to work independently or as part of a team.
Excellent communication and collaboration skills.
Preferred Skills:
Experience with orchestration tools like Airflow.
Exposure to modern data architectures, including the medallion architecture.
Scripting experience in Python for data manipulation and automation.
