QA Engineer (BI & DWH) - Bristol

QA Engineer (BI & DWH)

Bristol - Hybrid - 3days pw on site

£60,000 to £65,000

We are looking for an experienced and driven Datawarehouse QA Engineer to work for a UK leading customer centric business. The role will work closely with other QA Engineers in a multi-disciplinary team and work across multiple BI Projects. The role will be required to understand complex data movements alongside business and technical requirements to elicit ETL/ELT reconciliation scenarios.

The Data & BI team is responsible for the building of all data reporting solutions and the QA team is responsible for ensuring quality is built in from the start of all MI related projects and to ensure accurate reporting based on highly reconciled data. The team operates with a mixture of product teams and project-based teams working on various MI based reporting requirements to support business decision making for a variety of strategic business units.

You will ensure that quality engineering principles are highlighted, discussed, and implemented from early design stages through to final production release. This will include reviewing acceptance criteria to determine relevant test scenarios; executing tests and collaborating with business users to ensure sign-off. You will also be responsible for the creation and maintenance of SQL based regression packs.

What you will bring

• Expert level testing experience with Oracle and Postgres databases and Datawarehouse's.
• Experience of ETL / MI data testing
• Advanced / Expert level SQL skills to reconcile source/target data and to validate business rules / requirements.
• Proficient with using tools such as SQL Developer, Snowflake, PostgreSQL/DBeaver.
• Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports.
• Hands on and technical understanding of complex Data Warehousing, including Data Warehouse design; Star schema and dimensional modelling
• Proficient with using OAS (or similar reporting tools) and validating subject areas and reports.
• Experience of working with and using ETL tools such as ODI
• Understanding of data replication tools such as GoldenGate and DMS
• Python scripting knowledge would be desirable.
• Experience of implementing CI/CD process would be an advantage.
• Experience of adding automation to Datawarehouse testing projects.
• Experience of using ALFA and Oracle E-business suite would be an advantage.
• You'll be highly organised with the ability to own and manage testing activities and deliverables within allocated projects.
• You'll be a team player.
• Have excellent communication and interpersonal skills, with the ability to build relationships with all levels across the business.

This is fantastic opportunity to join a customer first business who invest in their people. On top of the salary, you will receive a number of fantastic benefits which include: 28 days holiday, PMI, a non-contributory pension scheme, training and development and a discretionary performance related bonus.

Candidates must hold a British, EU Passport or Indefinite Leave to Remain. Unfortunately sponsorship cannot be offered for this role.

Please apply now for more information