Snowflake Data Engineer: End-to-End Pipelines & dbt Expert
Posted Updated
Description
NCS is seeking an experienced Snowflake Data Engineer to design, build, and maintain scalable data pipelines and transformation frameworks. You will own end-to-end data flow from ingestion to Gold layer outputs, ensuring quality, performance, and alignment with business requirements.
You will design reusable ingestion frameworks for batch, incremental, and streaming loads, develop dbt models across Silver and Gold layers, and implement automated data quality tests to safeguard outputs.
Design, build, and maintain scalable data pipelines and transformation frameworks in Snowflake. Develop and maintain dbt transformations across Silver and Gold layers. Implement automated testing frameworks for data quality and integrity. Own defect triage, root-cause analysis, and remediation within SLAs. Produce and maintain interface documentation for data contracts and schedules. Apply CI/CD and version control to pipelines and dbt code. Monitor, optimize, and cost-control pipelines through observability tools. Collaborate with Data Modellers, analysts, and stakeholders to ensure fit-for-purpose pipelines. Advanced proficiency in Snowflake SQL and performance tuning. Expert-level dbt experience: building, testing, documenting projects; model dependencies and macro development Strong foundation in ETL/ELT design, data warehousing concepts, and dimensional modelling Expert SQL writing, query optimisation, and complex transformation logic Scripting capability in Python or similar languages for orchestration, data validation, and custom transformations Experience with orchestration tools (Airflow, Prefect, or equivalent) Proficiency with Git workflows, branching strategies, and CI/CD pipeline integration Proven experience designing and implementing data quality frameworks Familiarity with automated testing tools and methodologies Understanding of data validation, reconciliation, and audit patterns Hands-on experience with cloud data platforms (AWS, Azure, or GCP) Familiarity with infrastructure-as-code, containerisation, or deployment automation Understanding of logging, monitoring, and alerting tools Strong problem-solving and analytical mindset Clear communication and documentation abilities Collaborative approach to cross-functional teamwork Proactive issue identification and resolution Meticulous attention to detail and commitment to data accuracy Demonstrated track record of delivering production data pipelines at scaleSkills
Sign in to read and join the discussion.