The role involves planning and executing automated data quality tests, including the creation of regression suites and SQL validations for pipelines and reports. Additionally, the engineer will implement data observability monitoring and mentor team members on data testing best practices.
THIS OPENING IS AVAILABLE FOR CANDIDATES IN LATIN AMERICA, NOT LIMITED TO ONLY MEXICO.
Sonatafy Technology, headquartered in Scottsdale, Arizona, is an award-winning nearshore software development company with a strong reputation. They have a dedicated in-house team of engineers, offering end-to-end software solutions and supporting client development staff augmentation. Catering to companies of all sizes and industries, including some of the world's largest brands, Sonatafy Technology is a trusted provider of nearshore enterprise-level cloud and mobile application software development services.
Responsibilities:
Planning
- Collaborate with the engineering team to refine work requests in an agile development system, translating requirements into testable data quality criteria.
- Develop comprehensive test plans and test cases as part of project planning, including test strategy for validation, reconciliation, regression, and monitoring.
- Provide accurate estimates of effort and duration of QA tasks.
Testing
- Create and maintain automated tests to validate pipeline requirements, transformation logic, and downstream analytics/report outputs.
- Write and optimize SQL queries for automated validations (such as row counts, uniqueness, referential integrity, reconciliation, business-rule checks, etc.)
- Build regression suites for critical datasets and dashboards to ensure consistent numbers across releases and backfills.
- Create and maintain deterministic test datasets (fixtures) and “golden” expected results for repeatable validation.
- Assist with the verification and recreation of user-reported data issues, including data lineage/traceback from report to source.
- File detailed and actionable defect reports, including reproduction steps, expected outcomes, and evidence (queries, sample records, screenshots of report values when relevant).
- Work collaboratively with engineers to troubleshoot defects, validate fixes, and prevent recurrence via new tests and monitoring.
- Continuously improve QA processes, frameworks, and tools for data testing and validation to align with best practices.
Integration & Monitoring
- Integrate test automation with deployment automation, work tracking, and test tracking systems to enforce automated quality gates
- Schedule and manage automated test runs (PR/CI, nightly, and post-deploy), ensuring consistent and reliable execution.
- Implement data observability checks and alerting for freshness, volume, distribution/anomaly detection, and schema drift; tune alert thresholds to reduce noise.
- Collect, consolidate, and analyze test and monitoring results to identify trends, systemic issues, and opportunities to improve data reliability.
- Define and develop key performance indicators (KPIs) for measuring test effectiveness (coverage, escaped defects, time-to-detection, time-to-resolution).
Collaboration
- Manage and prioritize work using the ticketing system while maintaining regular communication in stand-ups and stakeholder meetings.
- Conduct code reviews of test code, SQL validation logic, and monitoring rules to ensure adherence to best practices and high-quality deliverables.
- Partner with Data Engineering and BI stakeholders to validate semantic models and report logic (e.g., dataset/model measures, transformations, refresh behavior).
- Contribute to technical documentation of processes, tools, workflows, and standards.
Leadership & Mentorship
- Mentor other team members by sharing knowledge, conducting training sessions, and providing guidance on best practices for data testing and quality.
- Take ownership of complex or high-impact initiatives (e.g., establishing regression strategy, monitoring standards), ensuring timely delivery and alignment with business objectives.
Requirements and Skills:
- Bachelor’s degree in Computer Science, Information Systems /other relevant degree or equivalent professional experience.
- Demonstrated experience writing automated QA tests, especially for back-end systems without UI
- Expert knowledge of relevant languages, such as SQL, Python, JavaScript, and/or C#
- Expert knowledge of test automation tools such as Cypress, Great Expectations
- Excellent analytical and problem-solving skills with a high level of attention to detail.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
- Experience with CI/CD pipelines and version control systems (e.g., Jenkins, Git).
- Knowledge of business intelligence tools such as Power BI or Tableau.
- Understanding of Agile development processes.
Why Work with Sonatafy?
At Sonatafy, you'll join a community of highly skilled engineers across Latin America supporting innovative U.S.-based teams. You’ll be part of a fast-moving, client-first culture where your code has real-world impact. We offer competitive compensation, a remote-first lifestyle, and career growth opportunities across industries and technologies.
If you have reached this point and feel you are our ideal candidate, it’s time for you to apply! To apply, please submit your resume in English.
Recruitment Scam Notice:
Sonatafy recruitment communications will only come from @sonatafy.com email addresses. We do not request fees, sensitive financial information, or conduct hiring solely through online forms without interviews. If you receive a suspicious message, contact us at careers@sonatafy.com.