Business Data Analyst - Snowflake Specialist
Posted 3 days ago by ABC Programme Consultants Ltd
£95,000 Per year
Fixed-Term
Hybrid
London (City), UK
Summary: A leading insurance services organization is looking for a Business Data Analyst to join their data team during a cloud data transformation program. The role involves developing Snowflake-based data models and ensuring effective communication between technical teams and business stakeholders. The analyst will be responsible for optimizing data structures and delivering insights that drive business value. This position offers an opportunity to contribute significantly to a major data transformation initiative within the company.
Key Responsibilities:
- Collaborate with stakeholders to capture, refine and document business and technical requirements for Snowflake-based data warehouses, reports, and dashboards.
- Design and maintain optimised Snowflake data models (including star schemas) to ensure scalable, reliable reporting and analytics.
- Evaluate existing reports and conduct technical analyses to identify and close data gaps within Snowflake's data model.
- Ensure alignment of data models with evolving business requirements and governance standards.
- Investigate and resolve data integrity or reporting issues within Snowflake.
- Deliver ad hoc datasets and insights, leveraging Snowflake's advanced capabilities while promoting best practices and high data quality.
- Ensure all work adheres to internal policies, data governance frameworks, and regulatory standards.
- Maintain clear documentation of data flows, mappings, and processes.
Key Skills:
- Strong SQL expertise for querying, analysis, and troubleshooting within Snowflake.
- Hands-on experience with Snowflake environments.
- Understanding of ETL/ELT processes to support data integration into Snowflake.
- Experience capturing and translating stakeholder requirements into actionable data specifications.
- Analytical mindset with attention to detail and a focus on business value delivery.
- Familiarity with insurance or financial services data (claims, policies, premiums).
- Exposure to cloud ecosystems (AWS, Azure, or GCP) supporting Snowflake deployments.
- Business Analysis certification or LM1 qualification.
Salary (Rate): £95,000 yearly
City: London
Country: UK
Working Arrangements: hybrid
IR35 Status: fixed-term
Seniority Level: undetermined
Industry: IT
About the Role
A leading insurance services organisation is seeking a Business Data Analyst to join their expanding data team during an exciting cloud data transformation programme. The business is building a new Snowflake-based data warehouse, and this role will play a pivotal part in shaping how data is structured, accessed, and used across the organisation.
You will act as the key interface between technical teams and business stakeholders, ensuring requirements are translated into high-quality Snowflake data models, pipelines, and reports that deliver measurable business value.
Key Responsibilities
-
Snowflake Data Analysis & Modelling
-
Collaborate with stakeholders to capture, refine and document business and technical requirements for Snowflake-based data warehouses, reports, and dashboards.
-
Design and maintain optimised Snowflake data models (including star schemas) to ensure scalable, reliable reporting and analytics.
-
-
Support Strategic Data Initiatives & Reporting Optimisation
-
Evaluate existing reports and conduct technical analyses to identify and close data gaps within Snowflake's data model.
-
Ensure alignment of data models with evolving business requirements and governance standards.
-
-
Development, Testing & Operational Support
-
Investigate and resolve data integrity or reporting issues within Snowflake.
-
Deliver ad hoc datasets and insights, leveraging Snowflake's advanced capabilities while promoting best practices and high data quality.
-
-
Compliance & Standards
-
Ensure all work adheres to internal policies, data governance frameworks, and regulatory standards.
-
Maintain clear documentation of data flows, mappings, and processes.
-
What You'll Bring
-
Technical Skills:
-
Strong SQL expertise for querying, analysis, and troubleshooting within Snowflake.
-
Hands-on experience with Snowflake environments
-
Understanding of ETL/ELT processes to support data integration into Snowflake.
-
-
Business & Analytical Skills:
-
Experience capturing and translating stakeholder requirements into actionable data specifications.
-
Analytical mindset with attention to detail and a focus on business value delivery.
-
-
Desirable Knowledge:
-
Familiarity with insurance or financial services data (claims, policies, premiums).
-
Exposure to cloud ecosystems (AWS, Azure, or GCP) supporting Snowflake deployments.
-
Business Analysis certification or LM1 qualification.
-
What's on Offer
-
Opportunity to shape and support a major Snowflake data transformation.
-
Hybrid working
-
FTC circa £95,000, initial 1 year contract
This vacancy is being advertised by ABC Programme Consultants Ltd, an employment business/agency acting on behalf of our client.
We are an equal opportunities recruiter and welcome applications from all suitably qualified individuals regardless of age, disability, gender identity, marital status, pregnancy or maternity, race, religion or belief, sex, or sexual orientation.
All applications will be treated in the strictest confidence. Candidate data will be processed in line with GDPR and our privacy policy. By applying, you consent to your details being shared with our client for recruitment purposes only.
Please note: we do not accept unsolicited CVs from other agencies. Submission of any candidate details without prior written agreement will be considered a direct application, and no fees will be payable.