ETL Test Engineer

This is a fully remote position, open to applicants in United Kingdom.

📋 Description

• The Data Quality Analyst is responsible for designing and executing the Data Quality framework operationally.

• Key duties include developing and maintaining quality assurance testing deliverables, as well as supporting delivery activities.

• Assessing Business requirements for thoroughness and precision is essential.

• Evaluating Business requirements against technical specifications (data modeling) is a critical task.

• Formulating high-level test scenarios is part of the role.

• Crafting manual test cases is required.

• Creating validation scripts for automated execution, along with generating actionable data quality reports that track trends over time, is necessary.

• Developing YAML code for the creation and maintenance of DevOps pipelines is expected.

• Analyzing test outputs and identifying defects is a key responsibility.

• Collaborating closely with Business Analysts, Data Analysts/Scientists, Development teams, and Product Owners to ensure the accuracy and validity of data across multiple source systems is essential.

• Involvement in defect triage and sprint ceremonies is required.

• The candidate will engage in both automated and manual ETL testing across various scrum teams, with a focus on automated testing.

• Participation in the architectural design of data quality practices with the technical team, including data quality design, specifications, data modeling, and documentation of logical processing flows, is expected.

• Agile testing practices will be utilized.

• Developing documentation and implementing data quality standards is part of the role.

• Regularly reviewing and analyzing QA results and findings with limited guidance from senior leadership is necessary.

⛳️ Requirements

• A minimum of 5+ years of relevant experience or an equivalent combination of education and consulting experience is required.

• At least 5 years of experience in large-scale system implementation projects following a standard software development lifecycle methodology (scrum preferred) is necessary.

• Experience with ETL testing is essential.

• Proficiency in automating ETL tests using PySpark/Python is required.

• Ability to create manual test cases based on business requirements and technical specifications is necessary.

• Capability to develop DataBricks notebooks for the automation of manual tests is expected.

• Skills in creating and executing test pipelines and interpreting results are essential.

• The ability to test complex reports and formulate queries to verify each metric is required.

• Strong verbal and written communication skills are essential.

🏝️ Benefits

• Inclusion is the foundation that allows everyone to express their authentic selves.

• We honor and celebrate our differences, as diversity fuels innovation and strengthens our organization.

• Employee Resource Groups include Diversity and Inclusion, Telefónica Tech Pride, Neurodiversity, ELEVATE (African and Caribbean heritage network), and Sustainability.

• We do not view hiring as a mere checkbox exercise, so if you believe you may not meet the job description 100% but would still be an excellent fit for the role, please reach out.