Business and Data Quality Analyst
GrubHub Holdings Inc. is the nation's leading online and mobile food-ordering company dedicated to connecting hungry diners with local takeout restaurants. The GrubHub Holding Inc. portfolio of brands includes GrubHub, Seamless, MenuPages and Allmenus. The company's online and mobile ordering platforms allow diners to order directly from thousands of takeout restaurants across the country and London, and every order is supported by the company's 24/7 customer service. GrubHub Holdings Inc. has offices in Chicago, New York City and London.
With a career at GrubHub Holdings Inc., you can order your cake and eat it, too!
We are looking for someone to develop a deep familiarity with data sources within the business, including production databases, reporting databases, and internal tools. This person will understand the provenance of data and potential sources of error and risk.
- For new projects, evaluate the proper level of QA and validation required for the data depending on the data, level of acceptable risk, and work required.
- If a project requires a high level of QA, then this role will work with the business to determine the right questions and assertions to ask of the data, write necessary SQL queries to perform those assertions, and validate the integrity of the data provided. This may require
- Deep dive into business reporting needs to make sure the validations and data meets expectations. Will require communicating directly with business stakeholders and communicating risk properly along with understand the goals the business is trying to achieve.
- Working with technology and writing the necessary test cases to ensure that data validations are automated and accurate.
- Continually review existing reporting and data and determine whether additional QA validations should be performed and if so, work with the technology department to generate the required assertions and tests for the data.
- Work with technology to make sure tests and validations are automated as much as possible and QA functionality is built properly into ETL environments.
- Take ownership of the information being presented in our business data sources. Seek out bugs and work with development team to build proper testing and validation regimen.
Required Skills:
Experience writing SQL on a production database or a data warehouse is required. One or more of the following data environments is a plus:
MySQL
Amazon Web Services - Redshift, Elastic Map-Reduce
MS-SQL
Microsoft Cube & SAS
Salesforce
Ability to understand the relationship between business processes and the underlying technical components. Particularly automated reporting, ETL, and business data tools.
Attention to detail and a near obsession with accuracy and integrity of data and reporting
Excellent written and verbal communication skillz