- Company Name
- Cathcart Technology
- Job Title
- Principal Snowflake Engineer
- Job Description
-
**Job Title:** Principal Snowflake Engineer
**Role Summary:**
Technical leader responsible for owning and advancing the organization’s Snowflake data platform. Guides a team of software and data engineers, defines architecture, best‑practice standards, and migration strategy from a third‑party implementation to an in‑house solution while remaining hands‑on in design, development, and cloud infrastructure.
**Expectations:**
- Lead the Snowflake strategy and roadmap across the data platform.
- Mentor and up‑skill engineers in Snowflake, data modeling, and cloud best practices.
- Deliver scalable, maintainable, and secure data solutions in a hybrid AWS environment.
- Balance strategic planning with day‑to‑day coding, infrastructure provisioning, and pipeline enhancements.
**Key Responsibilities:**
- Design, build, and optimize Snowflake data warehouses, schemas, and data pipelines.
- Establish and enforce Snowflake governance, performance tuning, and cost‑management guidelines.
- Integrate Snowflake with existing data ingestion, ETL/ELT processes, and APIs.
- Deploy and manage supporting infrastructure on AWS (e.g., IAM, networking, storage).
- Collaborate with cross‑functional teams to translate business requirements into technical solutions.
- Conduct code reviews, define CI/CD practices, and ensure robust testing and monitoring.
- Provide technical mentorship, training sessions, and documentation for the team.
**Required Skills:**
- Deep expertise with Snowflake architecture, SnowSQL, Snowpark, and data modeling.
- Strong programming proficiency in Python; familiarity with other languages acceptable.
- Hands‑on experience with AWS services (EC2, S3, IAM, VPC, CloudFormation/Terraform).
- Proven ability to design and implement scalable data pipelines (ETL/ELT).
- Solid understanding of software engineering principles, CI/CD, and infrastructure as code.
- Leadership experience guiding engineering teams and driving technical standards.
- Excellent communication, problem‑solving, and stakeholder‑management skills.
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field (or equivalent practical experience).
- Snowflake certifications (e.g., SnowPro Core, SnowPro Advanced) preferred.
- AWS certifications (e.g., Solutions Architect, DevOps Engineer) advantageous.
Edinburgh, United kingdom
On site
Senior
11-11-2025