Company Description
Socium - Teams Done Differently is a technology and transformation delivery engine based in Manila. We support customers through change and technology-enabled transformation by building program teams to plan, execute, and deliver major programs of work globally. We offer two models, Teams as a Service for enterprise-sized companies and Socium for Scale for high-growth tech start-ups, to generate clear business growth for our clients.
Job Description
As a QA Automation Engineer in our Enterprise Data department, you will be responsible for creating and managing automated tests to identify issues with the ETL process to ensure the quality of data in the Enterprise Data Warehouse.
The role involves working together with the onshore Enterprise Data team to decide on the required tests on the process, automate them through creating stored procedures, custom dbt tests and scheduling these as part of the ETL process which loads data from source into the EDW.
- 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
Qualifications
- 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.
Additional Information
- Required knowledge & skills would typically be acquired through a bachelor's degree in computer science or related field.
- Experienced developers with at least 6+ years in software development
What's In It For You
- Competitive Compensation: Enjoy a competitive salary and a comprehensive benefits package, including excellent HMO coverage for employees and two eligible dependents.
- Engaging Work Culture: Participate in fun employee activities and company-wide events that promote camaraderie and connection.
- Career Growth: Thrive in a values-driven environment where you can build a fulfilling career doing what you love.
- Recognition and Development: Receive rewards and recognition for your performance, along with access to continuous learning and professional development opportunities.
- Flexible Work Setup: Benefit from smart working arrangements, allowing you to work remotely and only report onsite when necessary.
Note: Applicants must be based anywhere in the Philippines.
Apply now or drop me an email at [Confidential Information] - let's have a quick chat!
