Data Test Analyst

Oliver James; Greater London; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading London Market Insurance firm is seeking a Data Test Analyst for a contract role focused on ensuring data integrity across various platforms. You will validate data flows and test BI dashboards, requiring strong SQL and familiarity with Snowflake. This hybrid position offers flexibility with 3 days on-site and 2 days work from home. The role is projected for 6 months with a potential extension, offering a daily rate of £600 outside of IR35.

Qualifications

• Strong SQL skills with complex joins and data profiling.
• Experience with Snowflake database.
• Ability to test and validate BI dashboards.

Responsibilities

• Validate data flows through Snowflake.
• Review and test data contracts and transformations.
• Run SQL checks and troubleshoot data issues.
• Test BI dashboards for accurate reporting.
• Collaborate with Data Engineers and BI teams.

Skills

Strong SQL skills

Experience with Snowflake

Testing BI dashboards

Understanding of data pipelines

Tools

Tableau

Power BI

DBT

Jira

Confluence

Job description

Job Title: Data Test Analyst - Contract - Outside IR35 - London

Location: London (Hybrid: 3 days onsite / 2 days WFH)

Contract Rate: C* £600 p/day

Outside IR35

Duration: 6 months with view to extend

About the Role

We are seeking a highly technical Data Test Analyst to join a leading London Market Insurance client on a major data modernisation programme. You will play a key role in ensuring data integrity across Snowflake, DBT transformations, and BI dashboards. This is a hands‑on role for someone with strong SQL expertise, a good understanding of data pipelines, and a focus on automation.

Key Responsibilities

• Validate data flows through Snowflake (Raw → Curated → Confirmed).
• Review and test Data Contracts and DBT transformation logic.
• Run SQL-based data checks and troubleshoot issues end-to-end.
• Test BI dashboards (Tableau/Power BI) to ensure accurate reporting.
• Collaborate closely with Data Engineers, BI teams, and Product Owners.

Experience Required

• Strong SQL skills, including complex joins, window functions, and data profiling.
• Solid experience working with Snowflake.
• Understanding of data pipelines, transformations, and data warehousing concepts.
• Experience testing BI dashboards and reports.

Desirable Skills

• Exposure to automation in testing (e.g., Python, Great Expectations).
• Experience working with DBT.
• Familiarity with Agile delivery tools like Jira and Confluence.
• Experience within the Insurance sector.

How to Apply

If you are interested, please send your CV to [e-mail] with the subject: "Data Test Analyst - Apply".

#DataTesting #Snowflake #DBT #SQL #ContractJobs #OutsideIR35