Business Data Analyst - Snowflake

Abcprogrammes; Snowflake (AZ); On-site; USD 109,000 - 148,000; Full time

Job summary

ABC Programme Consultants Ltd is recruiting a Business Data Analyst to shape a Snowflake-based data warehouse as part of a cloud data transformation and Workday implementation. You will translate business needs into high-quality Snowflake models, pipelines, and reports, acting as the bridge between technical teams and stakeholders.

The role emphasizes data governance, reporting optimisation, and ensuring data quality across the environment, with exposure to AWS/Azure/GCP ecosystems.

Qualifications

• Experience translating stakeholder requirements into actionable data specifications.
• Ability to challenge existing processes to avoid a lift-and-shift approach.
• Analytical mindset with focus on delivering business value.

Responsibilities

• Snowflake data analysis and modelling; collaborate with stakeholders to capture and document requirements for Snowflake warehouses, reports, and dashboards.
• Design and maintain optimized Snowflake data models (star schemas) for scalable reporting and analytics.
• Evaluate and close data gaps in Snowflake’s data model and ensure alignment with governance standards.
• Investigate and resolve data integrity or reporting issues within Snowflake; deliver ad hoc datasets and insights.
• Maintain data flow documentation and ensure adherence to internal policies and regulatory standards.

Skills

SQL expertise

Snowflake data modelling

ETL/ELT processes

Workday & Salesforce mappings

Tools

Salesforce

Workday

Job description

About the job Business Data Analyst - Snowflake

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 and a Workday (HR & Finance) implementation. 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 & Source to Target Mapping
  • Understanding of ETL/ELT processes to support data integration into Snowflake
  • Workday & Salesforce Data Mappings and Migrations
• Business & Analytical Skills:
  • Experience capturing and translating stakeholder requirements into actionable data specifications.
  • Able to challenge existing process avoiding "lift and shift" approach
  • 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.

What's on Offer

• Opportunity to shape and support a major Snowflake data transformation and Workday implementation
  
• 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.