Data & Analytics Test Engineer

Stott and May; City Of London; Hybrid; GBP 80,000 - 100,000; Part time

Job summary

A leading technology firm in the UK is seeking a Data & Analytics Test Engineer for a 6-month contract with a focus on test automation and ETL/ELT processes. This role includes defining test requirements, designing automated tests, and collaborating with stakeholders for successful project deliveries. Ideal candidates will have extensive experience in various testing methodologies and a solid background in SQL and automation tools. The position offers remote work one day a week.

Qualifications

• Strong background in functional, system, acceptance, and automated testing.
• Experience with agile delivery, test automation, and CI/CD.
• Knowledge of ETL/ELT, data warehousing, BI, and big data.
• Advanced SQL skills; APS knowledge desirable.
• Ability to write complex queries and use scripting languages.

Responsibilities

• Define test requirements from project documentation.
• Design, automate, and execute tests for ETL/ELT solutions.
• Work with stakeholders to secure sign-off based on test results.
• Troubleshoot issues, raise and track defects.
• Maintain and evolve the long-term Data & Analytics Test Strategy.
• Contribute to agile ceremonies, produce test documentation.
• Lead development of automated regression suites.
• Ensure compliance with data protection and governance standards.

Skills

Functional testing

System testing

Acceptance testing

Automated testing

Agile delivery

Test automation

CI/CD

ETL

Data warehousing

SQL (T-SQL or PL/SQL)

Automation tools

Scripting languages (C#, PowerShell, JavaScript)

Problem-solving

Communication skills

Tools

Microsoft Test

NUnit

SpecFlow

Selenium

Coded UI

DBFit

Visual Studio ALM/TFS

HP ALM

Job description

Data & Analytics Test Engineer

Start: ASAP (December)
Duration: 6 months+
Location: Central London (1-day per week)
Rate: £350 per day (OUTSIDE IR35)

Responsibilities

• Define test requirements from project documentation and business needs.
• Design, automate, and execute tests, leading a test-first development approach for ETL/ELT, data warehouse solutions, and BI/visualisation outputs.
• Work with Business Analysts and stakeholders to secure sign-off based on comprehensive test results.
• Troubleshoot issues, raise and track defects, retest fixes, and escalate risks when needed.
• Maintain and evolve the long-term Data & Analytics Test Strategy.
• Contribute to agile ceremonies, produce test documentation, and support planning/estimations.
• Lead development of automated regression suites integrated into CI processes.
• Ensure all solutions comply with data protection, privacy and data governance standards.

Skills & Experience

• Strong background in functional, system, acceptance and automated testing.
• Experience with agile delivery, test automation and CI/CD.
• Knowledge of ETL/ELT, data warehousing, BI, big data, cloud and testing methodologies (V-Model, Waterfall, Agile).
• Advanced SQL (T-SQL or PL/SQL); APS knowledge desirable.
• Proficient with automation tools (Microsoft Test, NUnit, SpecFlow, Selenium, Coded UI, DBFit).
• Skilled in Visual Studio ALM/TFS or HP ALM.
• Ability to write complex queries and use scripting languages (C#, PowerShell, JavaScript).
• Strong problem-solving and communication skills.