Data QA Test Lead - Victoria, Canada - Total Systems Solutions Consulting Inc.

Total Systems Solutions Consulting Inc.
Total Systems Solutions Consulting Inc.
Verified Company
Victoria, Canada

2 weeks ago

Sophia Lee

Posted by:

Sophia Lee

beBee Recruiter
Description

Data QA Test Lead

THE OPPORTUNITY

Project Context
The Ministry develops data products for use by Ministry staff in the form of datasets, reports and analytics. Currently, this is accomplished with a variety of manual and semi-automated processes using a wide variety of technologies.


In 2022, the Ministry began the development of an 'Finance Data Strategy' to understand its current state, leverage learnings from other jurisdictions to set a direction, and articulate its vision for effectively managing data moving forward (the "Strategy").

The Strategy included recommendations and a high-level, multi-year, strategic reference roadmap. In 2023, the Ministry received endorsement of a four year, detailed implementation plan for the Strategy.


The Strategy and the implementation plan are part of a comprehensive four-year initiative to modernize the Ministry information technology, which started in 2022/2023.

Several projects detailed in the implementation plan have been started, and the Ministry is preparing to undertake another phase of the implementation plan by beginning component development detailed in the implementation plan in


Specifically, this phase will consist of several overlapping components each with their own phases and expected deliverables, each either building upon an existing Ministry asset or creating a new ministry asset to fulfil on the Ministry's overall data strategy.

Each component is envisaged and structured as a business-driven design process, followed by an iterative and end-to-end development process that delivers value in the form of a Ministry asset early in the project lifespan and then iteratively throughout the life of the component.

The components fall into two main groups. The first group of components is the development of the Ministry data operations platform.

The data operations platform is a collection of components forming a set of services that will be available to Ministry staff to enable them to create high quality data products primarily for internal use, in the form of datasets, reports and analytics in a structured, maintainable and supportable way.

The second group of projects is to populate the data operations platform with data by creating data pipelines and, in some cases, by manually gathering metadata from unstructured sources, to assist the Ministry data teams to make their data products more discoverable, accessible and usable.


Scope of Project


As a Data Management, Integration, Transformation, Power BI Tester, you will play a critical role in ensuring the quality and reliability of our data management, integration, and transformation processes, as well as the effectiveness of our Power BI reports and dashboards.

You will collaborate closely with data engineers, data analysts, and business stakeholders to understand requirements, develop test cases, execute testing procedures, and provide feedback to improve the overall data ecosystem.


T_est Planning and Preparation:
_

Collaborate with stakeholders to understand data management, integration, and transformation requirements.

  • Develop comprehensive test plans and test cases for data processes and Power BI reports.
  • Identify and prioritize test scenarios based on business requirements and data workflows.
  • Data Validation and Verification: _
  • Execute test cases to validate data quality, integrity, and accuracy across various data sources and transformations.
  • Conduct endtoend testing of data integration pipelines, ensuring smooth data flow and mínimal latency.
  • Verify the correctness of calculations, aggregations, and transformations applied to the data.
  • Performance Testing: _
  • Conduct performance testing to evaluate the efficiency and scalability of data processing and integration workflows.
  • Identify bottlenecks and performance issues in data pipelines and recommend optimizations.
  • Regression Testing: _
  • Perform regression testing to ensure that changes or enhancements to data processes do not adversely affect existing functionality.
  • Maintain regression test suites and automate repetitive testing tasks where possible.
  • Power BI Testing: _
  • Validate the accuracy and functionality of Power BI reports, dashboards, and data visualizations.
  • Ensure that Power BI reports meet business requirements and provide actionable insights to users.
  • Defect Management: _
  • Document defects, issues, and anomalies found during testing and track them through resolution.
  • Collaborate with development teams to troubleshoot and resolve datarelated issues.
  • Documentation and Reporting: _
  • Create and maintain documentation for test plans, test cases, and testing procedures.
  • Generate test reports summarizing test results, findings, and recommendations for stakeholders.

Consultant Qualifications

  • 3+ years in software development, integration and/or solution architecture.
  • Postsecondary education in Computer Science or related field or equivalent combinatio
More jobs from Total Systems Solutions Consulting Inc.
See all jobs of Total Systems Solutions Consulting Inc.