Senior Data Engineer

Role Overview

We are in search of a highly skilled Senior Data Engineer with deep practical knowledge of Snowflake and dbt to architect, develop, and sustain scalable, dependable, and efficient data solutions. The successful candidate will possess considerable expertise in data engineering, SQL programming, data modeling, and constructing robust data pipelines that support business intelligence, analytics, and reporting needs.

Key Responsibilities

• Create and maintain scalable data pipelines utilizing Snowflake and dbt platforms.
• Develop and refine complex SQL queries, transformations, and data workflow processes.
• Design and support efficient data models with dbt, adhering to modularity, reusability, and maintainability principles.
• Manage data ingestion, transformation, and integration across multiple source systems.
• Conduct data quality assurance, testing, validation, and reconciliation ensuring accurate and consistent data.
• Enhance Snowflake’s performance, optimize warehouse usage, and manage query execution costs effectively.
• Implement dbt testing routines, comprehensive documentation, version control, and deployment procedures.
• Partner with data analysts, BI personnel, architects, and business stakeholders to deliver trustworthy data products.
• Diagnose and resolve any issues affecting data pipeline operations or data quality and performance.
• Participate in upholding data governance, security protocols, monitoring, and engineering standards.

Required Skills and Experience

• Minimum of eight years working in data engineering or a closely related data platform role.
• Extensive hands-on experience with Snowflake, including expertise in data warehousing, performance optimization, and cost management.
• Proficient in dbt for tasks like data transformation, modeling, testing, and documentation.
• Advanced expertise in SQL covering complex queries, analytical functions, and query performance tuning.
• Comprehensive understanding of data warehousing techniques, dimensional modeling, and overall data architecture.
• Experience in designing, developing, and maintaining ETL/ELT data pipelines.
• Proficiency with Git and established version control workflows.
• Familiarity with data quality governance, automated testing frameworks, and CI/CD integration.
• Strong analytical aptitude, problem-solving capabilities, and communication skills.

Desirable Skills

• Experience working with cloud platforms such as AWS, Microsoft Azure, or Google Cloud Platform.
• Knowledge of orchestration tools like Apache Airflow or equivalent.
• Competency in Python for automating data processing tasks.
• Exposure to business intelligence tools such as Power BI.
• Understanding of data governance, metadata management, and data observability practices.

Additional Information

We seek a proactive Senior Data Engineer ready to take ownership of engineering solutions, enhance existing pipelines, and collaborate effectively with both technical teams and business units to build trustworthy, scalable data platforms.

Application prerequisites: Candidates must possess valid work authorization in New Zealand. Please submit a resume emphasizing your experience with Snowflake, dbt, and SQL.