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
You might also like:
- Backend Developer - Ruby
- System Administrator in Network and Security at Tutus
- DevOps Engineer
- Data Engineer working in Delivery - Data & AI
- French-speaking Project Manager
- Security Guard Summer Job - Oskarshamn
- Java Developer with AWS experience
- Business Analyst ServiceNow at Sopra Steria Sweden AB
- Senior PHP Laravel Developer
- Software Developer / C++ / Python