Systems and Solutions Lead - Data Services

Kennedys are seeking a seeking an experienced Systems and Solution Lead with expertise in the Snowflake platform to join our growing technology team. The successful candidate will lead the design, architecture, and implementation of Snowflake-based solutions for our data and analytics ecosystem. They will be responsible for optimising data systems, ensuring smooth integration of Snowflake with other platforms, and driving continuous improvement of our data infrastructure. This role is critical to enabling data-driven decision-making across the organisation.

Team

Kennedys IT team is responsible for delivery of a responsive, effective and timely IT support service to the firm's employees and clients. They devise and implement operational processes and procedures in order to provide reliable and available IT systems to the firm.

Key responsibilities

• Lead the design, implementation, and optimization of Snowflake architecture and solutions
• Ensure best practices for data warehousing, data modelling, and performance tuning within the Snowflake environment
• Work closely with data engineers and data scientists to ensure Snowflake is used to its full potential
• Collaborate with cross-functional teams to design and deliver scalable and efficient Snowflake-based solutions that meet business needs
• Integrate Snowflake with other cloud-based technologies, data lakes, and external data sources (e.g., AWS, Azure, Google Cloud).

Required experience

• 7+ years of experience in systems design, solution architecture, or platform engineering with a strong focus on data platforms and cloud-based solutions
• Minimum of 3 years of hands-on experience with Snowflake platform, including architecture, development, and performance optimisation
• Proven experience leading data integration projects involving Snowflake, AWS, Azure, or Google Cloud
• Strong understanding of data warehousing, ETL/ELT processes, and cloud technologies
• Experience with other cloud platforms (AWS, Azure, GCP) is desirable
• In-depth knowledge of Snowflake architecture, including data modelling, clustering, and performance optimisation
• Expertise in SQL and Snowflake-specific functions (e.g., Snowflake Scripting, Snowpipe, Streams, Tasks)
• Experience with Snowflake integrations and connectors (e.g., ETL tools like Informatica, Talend, dbt)
• Familiarity with data lake architectures, data pipelines, and real-time data processing
• Proficiency with version control tools (Git, etc.) and CI/CD processes for data solutions
• Understanding of data governance, data security, and compliance (GDPR, CCPA, etc.)
• Excellent problem-solving and troubleshooting skills
• Strong leadership and team management capabilities
• Exceptional communication and interpersonal skills
• Ability to work under pressure and manage multiple priorities
• Snowflake Certification (e.g., SnowPro Core Certification) is highly desirable
• Cloud certifications (AWS, Azure, Google Cloud) are a plus
• Experience with modern data orchestration tools (e.g., Apache Airflow, Prefect)
• Familiarity with data science tools and languages (e.g., Python, R) is beneficial
• Experience with machine learning integrations in the Snowflake environment is a plus
• Knowledge of containerization and orchestration tools (e.g., Docker, Kubernetes) is a plus.

Please let us know if you require any additional support or adjustments to be made in order to submit your application to Kennedys.

• where a level of experience is indicated, this is a guideline only and represents the amount of time we would usually expect a candidate to accumulate the requisite level of experience. This does not preclude applications from candidates with more or less experience.