Dreamix

Data QA Engineer

Dreamix

full-time

Posted on:

Location Type: Remote

Location: Bulgaria

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

Amazon RedshiftAWSAzureETLPythonSDLCSQL

About the role

  • Validate end-to-end data pipelines from source systems to data marts.
  • Test batch data loads.
  • Validate transformations, aggregations, and derived metrics.
  • Ensure data completeness, accuracy, and consistency across layers.
  • Understanding of data governance, privacy, and PII handling
  • Write complex SQL queries to validate fact and dimension tables in Redshift.
  • Validate data models (fact/dimension, keys, relationships)
  • Perform reconciliation between raw, curated, and reporting layers.
  • Validate business KPIs and metrics against source systems and definitions.
  • Validate data ingestion in S3 (file counts, schema, partitions, formats)
  • Review Glue job and Lambda execution logs to troubleshoot data issues.
  • Monitor pipeline health, failures, and data refresh SLAs.

Requirements

  • Strong SQL skills (joins, aggregations)
  • Hands-on experience testing data pipelines, ETL, or data warehouses
  • Experience with AWS services: S3, Glue, Lambda, Step Functions, Redshift, Athena, CloudWatch
  • Experience validating structured and semi-structured data (Parquet, JSON, CSV)
  • Solid understanding of data warehousing concepts and dimensional modelling
  • 5+ years’ experience in software quality assurance with a strong focus on manual testing
  • Proven experience testing complex web and/or mobile applications
  • Familiarity with browser developer tools for debugging network, console, and UI issues
  • Strong understanding of QA methodologies, SDLC, and Agile/Scrum
  • Excellent test design, defect management, and reporting skills
  • Experience with Jira, TestRail, or similar tools
  • Nice to have: Automation skills to write automated tests for pipelines using a language like Python.
  • Experience integrating automated tests into CI/CD pipelines (e.g. Azure DevOps)
Benefits
  • A warm and supportive work environment where you can reach your full potential
  • Flexible working hours that allow you to balance your work and personal life
  • Unlimited home office to help you stay productive and focused
  • Opportunities for professional development, including certifications and training
  • Additional benefits for academic teaching and speaking engagements
  • Knowledge-sharing sessions where you can learn from our Dreamix team
  • Team and company-wide events that bring us together
  • Amazing week long summer office and winter office initiatives
  • Additional health insurance and dental allowance to ensure your well-being
  • Multisport card to encourage a healthy and active lifestyle
  • Office massages to help you relax and unwind
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLETLdata warehousingdimensional modellingdata validationdata governancedata completenessdata accuracydata consistencyautomation testing
Soft Skills
test designdefect managementreportingcommunicationproblem-solvingattention to detailcollaborationanalytical thinkingtime managementadaptability