Software Engineer / Sr. Software Engineer – Snowflake Developer
Posted Updated
Description
Job Description: Software Engineer / Sr. Software Engineer – Snowflake Developer
Job Summary
We are looking for an experienced Snowflake Developer with strong expertise in Snowflake Data Modelling, dbt, SQL, and data transformation pipelines. The ideal candidate will be responsible for designing scalable data models, developing modular dbt transformations, optimizing Snowflake workloads, and ensuring high-quality, reliable data for downstream analytics and BI platforms.
The candidate will work closely with Data Architects, Analytics Engineers, BI Developers, and business stakeholders to translate business requirements into well-structured and maintainable data solutions.
Key Responsibilities
Snowflake Data Modelling
- Design and implement scalable and performant data models in Snowflake.
- Apply dimensional modelling best practices, including Star Schema, Snowflake Schema, and Data Vault.
- Create and manage Snowflake objects including:
- Databases
- Schemas
- Tables
- Views
- Streams
- Tasks
- Materialized Views
- Clustering Keys
- Optimize Snowflake query performance using appropriate clustering, partitioning strategies, result caching, and materialized views.
- Analyze and resolve data quality, consistency, duplication, and integrity issues across source and target layers.
- Collaborate with Data Architects to follow established modelling, governance, and security standards.
dbt Development & Data Transformation
- Develop and maintain modular and reusable dbt models across staging, intermediate, and mart layers.
- Write optimized and maintainable SQL using dbt, Jinja, macros,
ref(), andsource()dependencies. - Develop reusable dbt macros and transformation logic.
- Implement dbt testing frameworks, including schema tests and custom data quality tests.
- Maintain model documentation and data lineage using dbt Docs.
- Manage dbt project structures and deployment across Dev, QA/Staging, and Production environments.
- Troubleshoot dbt pipeline failures, dependency issues, lineage breaks, and model performance problems.
- Participate in CI/CD implementation and automation for dbt deployments.
Data Quality & Performance
- Identify and resolve data discrepancies between source, transformation, and target layers.
- Implement data validation and quality checks within dbt and Snowflake.
- Monitor transformation jobs and proactively identify performance bottlenecks.
- Optimize SQL queries, dbt models, warehouse utilization, and Snowflake workloads.
- Ensure data pipelines and models are reliable, scalable, and production-ready.
Collaboration & Delivery
- Work closely with Analytics Engineers, BI Developers, Data Engineers, Data Architects, and business stakeholders.
- Gather business requirements and translate them into effective data models and transformation logic.
- Build data structures that accurately represent business rules and reporting requirements.
- Support downstream BI and analytics platforms such as Tableau, Looker, and Power BI.
- Participate in Agile ceremonies, sprint planning, technical discussions, and code reviews.
- Create and maintain technical documentation for data models, transformations, and processes.
Required Skills
- 4+ years of experience in Data Engineering, Data Warehousing, or Snowflake development.
- Strong hands-on experience with Snowflake.
- Strong expertise in SQL and complex query development.
- Hands-on experience with dbt (Data Build Tool).
- Strong understanding of data modelling and dimensional modelling.
- Experience with Star Schema, Snowflake Schema, and/or Data Vault.
- Experience with Snowflake Streams, Tasks, Views, Tables, Clustering Keys, and Materialized Views.
- Strong knowledge of dbt models, macros, Jinja, ref/source dependencies, and dbt tests.
- Experience with data quality, validation, and troubleshooting.
- Understanding of ETL/ELT pipelines and modern cloud data warehouse architecture.
- Experience with Git and CI/CD processes.
- Strong analytical and problem-solving skills.
Good to Have
- Experience with Tableau, Power BI, or Looker.
- Knowledge of Snowflake performance tuning and warehouse optimization.
- Experience with Data Vault modelling.
- Knowledge of cloud platforms such as AWS, Azure, or GCP.
- Experience with orchestration tools such as Airflow.
- Familiarity with DevOps and automated dbt deployment practices.
- Understanding of data governance, security, and access-control concepts.
Soft Skills
- Strong communication and collaboration skills.
- Ability to work effectively with technical and non-technical stakeholders.
- Strong ownership and accountability for assigned deliverables.
- Good problem-solving and troubleshooting abilities.
- Ability to work independently in a remote environment after the initial onsite period.
- Strong attention to data accuracy and quality.
Skills
Sign in to read and join the discussion.