Data Test Engineer (Python & SQL)

We are looking for a Data Test Engineer (Python & SQL) to join our Client’s team under a remote work model.

At Hexa Consulting, we are more than an IT consulting company — we are a place where technological talent grows. Based in Portugal, we value transparency and a people-first approach, helping professionals take the next big step in their IT careers. Our mission is to build strong relationships and support the development of every team member.

With projects in Nearshore, Time & Material, Service Management, and Tech Academies, you will find opportunities to learn, innovate, and grow in your career.

This role is highly technical and sits at the intersection of software engineering, data engineering, and quality engineering. The main focus is ensuring the correctness, reliability, and performance of data-driven systems, where complex SQL analytics power user-facing features.

You will work extensively with large aggregated datasets presented directly in the frontend, requiring a high level of confidence in validating business logic implemented in SQL.

Key Responsibilities:

• Design, implement, and evolve automated testing frameworks using Python, Robot Framework, and Selenium
• Build reliable end-to-end and integration tests validating frontend behaviour, backend services, and SQL-based analytical results
• Develop reusable test utilities and libraries, treating test code as a first-class engineering artefact
• Ensure test suites are deterministic, performant, and CI/CD compatible
• Validate complex SQL queries, including multi-table joins, window functions, aggregations, rollups, and derived metrics
• Design tests that verify the correctness of analytical results displayed in the UI
• Ensure consistency between raw data, transformed datasets, and user-facing results
• Investigate discrepancies between expected and actual results across different data layers
• Write clean, maintainable code aligned with engineering principles such as Clean Code, DRY, KISS, and SOLID
• Participate in code reviews for both production and test code
• Advocate for testability in data models, SQL design, APIs, and UI contracts
• Collaborate closely with Software Engineers, Data Engineers, and Product teams to validate business logic implemented in data transformations
• Identify risks in analytical calculations and challenge ambiguous metrics or assumptions
• Use AI-assisted development tools responsibly to accelerate test development, explore edge cases in SQL logic, and improve code coverage

Required Qualifications:

• Strong professional experience with Python
• Advanced SQL expertise, including testing complex analytical queries and aggregations
• Hands-on experience with Robot Framework
• Experience with Selenium or equivalent browser automation tools
• Experience testing data-intensive, user-facing applications
• Experience working in CI/CD environments
• Proven background as a Software Engineer, Data-focused Test Engineer, or hybrid engineering role
• Strong understanding of how data transformations impact user experience
• Ability to work across frontend, backend, and data layers
• Fluency in English (C1 level) and Portuguese (C1 level)

Nice to Have:

• Experience testing data platforms, dashboards, or analytical products
• Familiarity with data pipelines or transformation layers
• Experience validating product metrics and KPIs with stakeholders
• Experience with performance testing of SQL-intensive workloads

Important Note:

This is not a traditional QA or manual testing role. The position is intended for engineers who design testing systems, write production-quality code, and reason deeply about data correctness and analytical logic.

You will spend more time designing testing architectures, validating complex SQL logic, and ensuring data integrity than executing manual test cases.

Why Join Us?

• Work Model: Remote
• Contract Type: Permanent / Employment or B2B, according to preference
• Health Insurance: Comprehensive coverage for your well-being
• Continuous Learning: Access to a Udemy Business subscription with thousands of courses and workshops
• Team Culture: A collaborative, relaxed, and innovative environment

If you meet the above criteria and are ready for an exciting opportunity in a dynamic environment, send us your CV!