ETL QA Analyst

  • Denver, CO
  • Full-time

Company Description

Digital First Media, a business name of MediaNews Group, offers news reporting and third party advertising and directory opportunities through its more than 800 multi-platform products which include: web, mobile, tablet and print.

Job Description

Digital First Media is seeking an ETL QA Analyst to test our data warehouse. The ideal candidate will have a strong QA background with expert knowledge of databases and ETL pipelines. Must be a strong team player and be able to work alongside data engineers, data scientists, developers, other QA and product owners to build a robust set of tests.

What You’ll Be Doing:

  • Developing and documenting test plans and test cases, including automated tests where applicable.

  • Fostering a culture of zero-tolerance for buggy software delivery.

  • Collaborating with development engineers to drive issues to resolution.

  • Testing databases, data driven applications and ETL pipelines.

  • Checking the quality and accuracy of large amounts of data in the data warehouse and identifying defects.

  • Following and validating data from source systems to production.

  • Reading and adjusting SQL code written by data warehouse engineers for troubleshooting, optimization, and performance tuning purposes.

You Should Have:

  • A deep understanding of QA methodology and process.

  • Strong analytical, troubleshooting and problem solving skills.

  • The desire to learn and understand data so that data discrepancies are easily noticed and identified prior to delivery to end users.

  • Hands-on experience with reading and writing complex SQL.

  • Experience with collaboration, code inspection and review, and git.

  • Minimum of 3 years of QA or mix of QA and development experience.

You May Have:

  • Experience with Amazon Redshift or PostgreSQL.

  • Experience in scripting languages such as Python or Bash.

  • Experience with Linux/macOS.

  • Experience working in an Agile environment.

  • Experience with AdTech systems (e.g., Google AdWords, Facebook Ads, The TradeDesk, Google Analytics).

Additional Information

This is a full-time position, located in Denver. 

All your information will be kept confidential according to EEO guidelines.