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:
- Software Design Engineer
- Security Guard at SRS Group
- Lead Developer with responsibility for Backend
- Team Lead Network Development
- Software Developer
- Platform Architect - Integration
- Junior Software Developer at Saab Aeronautics
- Software Engineer C#/.NET in Publishing House
- System Administrator with strong Linux expertise
- QA Engineer