QA Automation Engineer

Arch; Quezon City; On-site; PHP 600,000 - 1,100,000; Full time

Job summary

Arch is seeking a QA Automation Engineer for its Enterprise Reporting department. You will create and manage automated tests for ETL/processes feeding the Data consumption layer, and automate validation of reporting models and visualizations to ensure data quality in the reporting layer.

You will collaborate with onshore teams to define an automated testing framework for Power BI reports/datasets and build processes to integrate testing into Reporting functions, including Snowflake data models

Qualifications

• Experience leveraging Power BI REST API to programmatically interact with reports, datasets, and dashboards.
• Strong SQL (or SnowSQL) and data transformation skills.
• Experience in programming or scripting languages such as Python, C#, Java, JavaScript/TypeScript.
• Understanding of Power BI testing process fundamentals.
• Experience designing and maintaining robust test automation frameworks (Playwright, Selenium or Cypress).
• Experience testing data with Power BI, DBT, Snowflake, and Sigma is a plus.
• Experience with GitHub Actions or similar for automating test workflows.
• Proactive in shifting left to detect defects early in the SDLC.
• Passionate about test automation and improving testing processes.
• Experience collaborating with teams to improve data quality in reporting estates.

Responsibilities

• Translate project requirements into effective test cases.
• Define testing objectives aligned with project goals.
• Establish testing scope prioritizing critical features.
• Document deliverables such as test plans, scripts, and reports.
• Develop automated frameworks for report testing combining Selenium, Power BI REST API, Python and other tools.
• Write automated test scripts with assertions to verify outcomes.
• Execute automated tests regularly, ideally in CI/CD pipelines.
• Automate testing of data models hosted in Snowflake before exposure in reporting tools like Sigma/Power BI.
• Automate common manual QA testing by creating dbt macros.
• Build and monitor automated system health checks.
• Collaborate with Enterprise Reporting Engineers to investigate root causes and propose resolutions.
• Support the team in releases and promote shift-left testing strategies.
• Take ownership of application quality from requirements through development and testing.

Skills

Power BI REST API

SQL / SnowSQL

Python

C#

Java

JavaScript

Power BI Testing

CI/CD

Shift left

Test automation

Tools

Playwright

Selenium

Cypress

GitHub Actions

DBT

Snowflake

Sigma

Job description

Overview

As a QA Automation Engineer in our Enterprise Reporting department, you will be responsible for creating and managing automated tests to identify issues with the ETL/processes feeding into Data consumption layer, automate the checking of validity of reporting models and report visualization with an aim to ensure the quality of data in the reporting layer.

The role involves working together with the onshore Enterprise Reporting team to decide on the required tests, define an automated testing framework for Power BI reports and datasets followed by building the process to automate testing within Reporting function .

Responsibilities

• • Translate project requirements into effective and comprehensive test cases.
  • Define clear testing objectives that align with overall project goals.
  • Establish the testing scope, prioritizing critical features and functionalities.
  • Document expected deliverables, such as detailed test plans, scripts, and reports.
  • Develop custom automated frameworks tailored to report testing needs – this may involve combining elements from Selenium, Power BI REST API, Python and other automated tools with an aim to automate Power BI dataset and report visualization testing.
  • Work with EA & Engineering excellence team to define and agree on a testing framework for Reporting.
  • Write automated test scripts using the chosen framework and tools, incorporating appropriate assertions to verify expected outcomes.
  • Execute the automated tests regularly, preferably as part of a continuous integration/continuous delivery (CI/CD) pipeline.
  • Automate testing of data models hosted in snowflake before they are exposed in Reporting tools like Sigma / Power BI .
  • Automate the common manual testing done by the QA through creating macros in dbt.
  • Build and monitor automated system health checks.
  • Collaborate with Enterprise Reporting Engineers to investigate root cause of issues and suggest resolutions.
  • Be able to support the team in doing releases.
  • Collaborate effectively with developers to implement testing strategies at lower levels, facilitating a "shift left" approach and promoting early defect detection.
  • Take ownership of application quality from requirements gathering through development and testing, ensuring a high standard of product excellence

Required Skills/Experience

• Experience to leverage Power BI REST API to programmatically interact with Power BI reports, datasets, and dashboards.
• Strong SQL( or SnowSQL) and data transformation skills.
• Experience in programming or scripting languages such as Python, C#, Java JavaScript/TypeScript.
• Understanding of Power BI Testing process fundamentals.
• Experience in designing, developing, and maintaining robust and scalable test automation frameworks such as Playwright, Selenium or Cypress
• Experience in testing of data with tools such as PowerBI, DBT and Snowflake & Sigma (nice to have).
• Experience with GitHub Actions or similar platforms for automating and managing test workflows.
• You are a proactive advocate for "shifting left", aiming to identify and address defects earlier in the development lifecycle.
• You are passionate about test automation and committed to continuously improving testing processes.
• You enjoy collaborating with your team members to build solutions which improves the data quality within the reporting estate.
• You have a drive to automate processes that mainly focuses on ensuring data quality and process rigidity.
• You have experience working with Power BI reports and investigating root cause of issues.
• You have experience working within data & analytics engineering.