QA Engineer - Data Warehouse
Workplace: Umeå, Sweden
Expires: July 31, 2025
Responsible for ensuring the quality, accuracy, and reliability of data in a data warehouse system. Tasks include testing ETL processes, data integration, and analytics/reporting systems to meet business and technical requirements. Involves defining QA processes and working within agile teams throughout all phases of the SDLC.
Main requirements:
  • Validate data transformations, mappings, and business logic during ETL and streaming data integration processes
  • Perform data reconciliation between source and target systems
  • Conduct comprehensive data quality checks ensuring accuracy, consistency, and completeness
  • Identify and resolve data loading issues and discrepancies
  • Validate job scheduling, triggers, and error handling in ETL and streaming workflows
  • Execute functional testing of data warehouse solutions against business requirements
  • Ensure system compliance with data governance and regulatory standards
  • Develop automated testing frameworks and scripts for data validation
  • Use tools or custom scripts for repetitive testing tasks
  • Support PO's to break down epic stories into manageable tasks for testing
  • Collaborate closely with data engineers, analysts, and business stakeholders for requirement understanding and issue resolution
  • Provide clear documentation of test cases, results, and defect tracking
  • Coordinate test activities during different project phases
  • Assist in planning and maintaining healthy test environments
  • Communicate test status and highlight issues to stakeholders
Responsibilities:
  • Ensuring quality, accuracy, and reliability of data warehouse systems
  • Testing ETL, data integration, and analytics/reporting systems
  • Defining and implementing QA processes within the team
  • Working within agile teams throughout SDLC phases
  • Develop automated testing scripts and use testing tools
  • Collaborate with cross-functional teams and stakeholders
  • Document testing outcomes and manage defect tracking
  • Coordinate and plan testing activities and environments
Required hard skills:
  • Manual testing (UI, Usability, Functional, Integration, BI)
  • Data analysis and reconciliation between source and target systems
  • Test strategy creation focused on quality standards and validation
  • Experience with JIRA or similar test management tools
  • Experience working in Agile methodologies like SCRUM or KANBAN
  • Working experience with relational databases; SQL preferred
  • Excellent command of written and spoken English
Recommended hard skills:
  • Proficiency in SQL for querying and validating data
  • Familiarity with ETL tools
  • Knowledge of cloud-based data warehouses (e.g. BigQuery)
  • REST-API testing using Postman, SoapUI, REST-ASSURED or similar frameworks
  • Hands-on experience with test management and defect tracking tools like Jira and TestRail
  • Understanding of Cypress and Selenium test automation frameworks
  • Experience with complex systems with multiple external integrations, languages, and currencies
Soft skills:
  • Proactive
  • Open-minded
  • Desire to learn and develop
  • Strong problem-solving and data analysis abilities
  • Detail-oriented with focus on data accuracy and consistency
  • Strong organizational skills and multitasking capability
Coding languages:
  • SQL
Frameworks:
  • Cypress
  • Selenium
Natural languages:
  • English (Proficient)
Cultural skills:
  • Working in internationally diverse teams
  • Agile working mindset
  • Collaboration and communication skills