Earnbetter

Job Search Assistant

Logo

Data QA Engineer

MediaRadar • New York, NY • Posted 3 days ago via ZipRecruiter

Boost your interview chances in seconds

Tailored resume, cover letter, and cheat sheet

In-person • Full-time • $100,000-$110,000/yr • Contract • Senior Level

Job Highlights

Using AI ⚡ to summarize the original job post

MediaRadar is seeking a highly skilled and experienced Data QA Engineer to ensure the quality and reliability of data transformation and integration projects. The role involves developing and maintaining automated test scripts, creating test plans and cases, and executing SQL scripts to validate data across multiple databases. The ideal candidate will work closely with various teams to understand ETL requirements, troubleshoot issues, and implement solutions to enhance test performance and efficiency.

Responsibilities

  • Develop and maintain automated test scripts to ensure high-quality software delivery.
  • Create and maintain comprehensive test plans and test cases
  • Write and optimize SQL scripts to perform data validation and verification across Databricks, Microsoft SQL Server, Citus, and Oracle databases
  • Execute and validate end-to-end ETL processes, ensuring accurate data transformation and integration across various database systems
  • Collaborate with ETL developers, data engineers, and business analysts to understand ETL requirements and data flows
  • Work closely with development, data engineering, and product teams to ensure test coverage and resolve any quality issues
  • Utilize strong analytical skills to troubleshoot issues, identify root causes, and implement effective solutions
  • Develop and document best practices for test automation processes, providing recommendations for continuous improvement to enhance test performance and efficiency.
  • Provide support to team members and stay up-to-date with industry trends and advancements in test automation technologies

Qualifications

Required

  • Proficiency in SQL
  • Experience with databases such as SQL Server, Databricks, Citus/PostgreSQL, and Oracle
  • Experience with SQL data testing tools such as QuerySurge, Datafold, and Soda SQL
  • Solid understanding of ETL processes, data warehousing concepts, and database systems
  • Experience with continuous integration and continuous deployment tools like Atlassian Bamboo, Jenkins, Azure DevOps, or GitLab CI
  • Experience with test case and project management tools such as Jira, Zephyr Squad and TestRail

Preferred

  • Knowledge of Javascript, Python and C#/.NET framework

About MediaRadar

MediaRadar is a leading sales enablement platform for media and ad tech companies, offering customized solutions to help close deals and outperform the competition. Their award-winning platform provides strategic insights and analysis for media planners, sellers, and buyers, helping increase revenue and optimize advertising campaigns with comprehensive solutions for the advertising industry.

Full Job Description

Job Description

Job Description

We are seeking a highly skilled and experienced Data QA Engineer to join our team. This role is crucial in ensuring the quality and reliability of our data transformation and integration projects. You will be responsible for building and executing complex SQL scripts, and validating data across multiple databases including Microsoft SQL Server, Databricks, Citus and Oracle.

Requirements

Key Responsibilities:

  • Develop and maintain automated test scripts to ensure high-quality software delivery.
  • Create and maintain comprehensive test plans and test cases
  • Write and optimize SQL scripts to perform data validation and verification across Databricks, Microsoft SQL Server, Citus, and Oracle databases
  • Execute and validate end-to-end ETL processes, ensuring accurate data transformation and integration across various database systems
  • Collaborate with ETL developers, data engineers, and business analysts to understand ETL requirements and data flows
  • Work closely with development, data engineering, and product teams to ensure test coverage and resolve any quality issues
  • Utilize strong analytical skills to troubleshoot issues, identify root causes, and implement effective solutions
  • Develop and document best practices for test automation processes, providing recommendations for continuous improvement to enhance test performance and efficiency.
  • Provide support to team members and stay up-to-date with industry trends and advancements in test automation technologies

Required Qualifications:

  • Proficiency in SQL and experience with databases such as SQL Server, Databricks, Citus/PostgreSQL, and Oracle
  • Experience with SQL data testing tools such as QuerySurge, Datafold, and Soda SQL for automating database validation and ensuring data integrity across multiple platforms
  • Solid understanding of ETL processes, data warehousing concepts, and database systems
  • Experience with continuous integration and continuous deployment tools like Atlassian Bamboo, Jenkins, Azure DevOps, or GitLab CI
  • Experience with test case and project management tools such as Jira, Zephyr Squad and TestRail
  • Knowledge of Javascript, Python and C#/.NET framework is a plus

Benefits

At MediaRadar, employees are encouraged to work hard, have fun and develop strong relationships with their peers. We are committed to creating a diverse, inclusive, and welcoming environment for all employees, living our core values every day. Our inclusive culture promotes respect, equality, and opportunity at every level, reflecting our value of being Teammates and working together harmoniously. We Listen to the diverse voices within our team, fostering curiosity and an environment where everyone's opinions matter. We are proud to be an equal opportunity employer.

Benefits

In addition to career progression, training and development, and an excellent work/life balance, future Radarians can expect a great benefits package that includes:

  • Medical, Dental & Vision Insurance
  • 401k with Company Match
  • Flexible PTO
  • Commuter Benefits
  • Gym Discounts
  • Summer Fridays

This is a 12 month contract role with a base salary range of $100,000 - $110,00 plus benefits. A final compensation offer will ultimately be based on the candidate's location, skill level and experience, and the Company's pay equity.

If you need assistance or an accommodation, you may contact us at careers@mediaradar.com