Senior Data Engineer (Snowflake)

• Design build and maintain scalable ETL/ELT pipelines to ingest data from multiple source systems into Snowflake.
• Develop and optimize Snowflake data warehouse structures including databases schemas tables views and materialized views.
• Implement data transformation logic using SQL dbt Python or similar tools within Snowflake-centric architectures.
• Manage and optimize Snowflake virtual warehouses for performance concurrency and cost efficiency.
• Use Snowflake features such as stages tasks streams time travel zero-copy cloning and secure data sharing where appropriate.
• Load and process structured and semi-structured data including JSON Avro and Parquet.
• Monitor query performance troubleshoot failures and tune Snowflake workloads for reliability and scalability.
• Implement data quality checks validation frameworks and monitoring for production pipelines.
• Work closely with analysts BI developers architects and business stakeholders to translate data requirements into technical solutions.
• Apply best practices for data governance security role-based access control and compliance within Snowflake.
• Support CI/CD automation and deployment processes for data engineering workflows.
• Maintain technical documentation for pipelines models Snowflake objects and operational proc

Qualifications :

• 5 years of experience in data engineering analytics engineering or a similar role.
• Hands-on experience with Snowflake in production environments.
• Advanced SQL skills including complex query development and query optimization.
• Experience with Snowflake architecture and core objects such as virtual warehouses databases schemas tables (including Iceberg tables) stages tasks streams and views.
• Experience designing and building ETL/ELT pipelines for cloud data platforms.
• Proficiency in Python Scala or Java for data processing and automation.
• Experience with data transformation and orchestration tools such as dbt Airflow Matillion Fivetran or Informatica.
• Knowledge of cloud platforms such as AWS Azure or GCP and interoperability capabilities.
• Experience with data modeling data warehousing concepts and dimensional modeling.
• Understanding of Snowflake security access control and governance best practices.

Additional Information :

• Experience with dbt or similar tols and modern ELT patterns in Snowflake.
• Knowledge of Snowflake performance tuning workload management and cost optimization strategies.
• Experience integrating Snowflake with cloud storage services such as Amazon S3 Azure Data Lake or Google Cloud Storage.
• Familiarity with real-time or near-real-time data ingestion patterns.
• Experience with data lineage metadata management and governance tools.
• Snowflake certification.

At Endava were committed to creating an open inclusive and respectful environment where everyone feels safe valued and empowered to be their best. We welcome applications from people of all backgrounds experiences and perspectivesbecause we know that inclusive teams help us deliver smarter more innovative solutions for our customers. Hiring decisions are based on merit skills qualifications and potential. If you need adjustments or support during the recruitment process please let us know.

Remote Work :

No

Employment Type :

Full-time