ETL QA Analyst
- Denver, CO
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.
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).
This is a full-time position, located in Denver.
All your information will be kept confidential according to EEO guidelines.