Title: Data Quality Specialist
Location: Midtown New York, NY
Duration: 9-Month Contract

Summary:

Our client - a major media and entertainment firm located in NYC - has an immediate need for a Data Analyst

Overview:

The firm's Ad Revenue Analytics team is building a Data Warehouse and Business Intelligence Platform to unlock the organization's digital ad-serve data and drive revenue growth. The Data Quality Control Engineer for Ad Revenue Analytics will sit within the Product team and be responsible for building automated data quality controls. In this role you will work closely with the data engineering team and the internal technology teams to integrate with vendor APIs and QC data within the platform against the data provided by our vendors. Additionally, you will work with the Product team leads and our internal stakeholders to develop methods of proactively identifying potential sources of data quality issues.

Job Duties:

• Utilize vendor APIs to build automated checks for the in-house data warehouse datasets
• Build processes to identify data misclassifications
• Become a subject matter expert on our data pipeline
• Perform periodic data audits to identify vendor gaps and garbage data, as well as provide recommendations on improvements
• Build release management software to perform automated regression testing

Required Skills:

• 3-5 years of development experience in Python or equivalent
• Educational background in software development, engineering, or an equivalent quantitative field
• Strong understanding of JSON file formats, as well as other industry standards
• Proven ability building QC products and processes
• Extensive experience utilizing APIs and building automated processes
• Experience pulling data using SQL statements
• Ability to drive your own development and work independently
• Ability to clearly define requirements and create appropriate timelines for deliverables

Additional Skills:

• Prior experience with Looker, AWS, Presto and/or Qubole is a plus
• Prior experience and understanding of media, media & entertainment businesses, and/or ad revenue systems would be very helpful

Key aspects of the position:

• Take requirements, building them into software, and integrating with API's.
• Develop requirements, working with them to make sure it works as desired, so the QC/model building part of things doesn't need to be part of their skillset.
• Need to have a good understanding of dataset manipulation, which will be a common feature across both.

This will involve:

• Strong background in data analytics, data pipelines
• Expert at SQL & Python
• Expert at working with APIs
• Expert at working with JSON file formats.