Data Quality Analyst

Company Description

Forbes Advisor is a new initiative for consumers under the Forbes Marketplace umbrella that provides journalist- and expert-written insights, news and reviews on all things personal finance, health, business, and everyday life decisions. We do this by providing consumers with the knowledge and research they need to make informed decisions they can feel confident in, so they can get back to doing the things they care about most.

At Marketplace, our mission is to help readers turn their aspirations into reality. We arm people with trusted advice and guidance, so they can make informed decisions they feel confident in and get back to doing the things they care about most. We are an experienced team of industry experts dedicated to helping readers make smart decisions and choose the right products with ease. Marketplace boasts decades of experience across dozens of geographies and teams, including Content, SEO, Business Intelligence, Finance, HR, Marketing, Production, Technology and Sales. The team brings rich industry knowledge to Marketplace’s global coverage of consumer credit, debt, health, home improvement, banking, investing, credit cards, small business, education, insurance, loans, real estate and travel. 

Marketplace is hiring! We are looking to build out a QA function within our growing Business Intelligence & Operations team and therefore we require a Data Quality Analyst to help with establishing this function. We’re looking for intelligent, collaborative applicants who are passionate about implementing best in-class reporting. If that sounds like you, then we encourage you to apply.

Job Description

Short term objectives

We know the importance data validation can play in creating better reporting for our business - we have identified areas we want you to make an impact within the first 3 months.

 Push 40% of partners through the ingestion validation process

Push 40% of partners through the mapping validation process

Data Team Culture

Our team requires four areas of focus from every team member (see below). We use these focus areas to guide our decision making and career growth. To give you an idea of these requirements, the top three from each area are:

Mastery:

· Demonstrate skills expertise in relevant tool (e.g., GA, Tableau) or code language (e.g., SQL)

· Think about the wider impact & value of decisions

· Understand and anticipate the need for scalability, stability, and security

 Communication:

· Provide clear, actionable feedback from peer reviews

· Communicate effectively to wider teams and stakeholders

· Proactively share knowledge everyday

 Ownership:

· Lead complex initiatives that drive challenging goals

· Create and push forward cross cutting concerns between teams

· Demonstrate consistently sound judgement

 Behaviours:

· Challenge yourself and others through questioning, assessing business benefits, and understanding cost of delay

· Own your workload and decisions - show leadership to others

· Innovate to find new solutions, or improve existing ways of working - push yourself to learn everyday

Responsibilities:

• Reports directly to Senior Business Analyst and works closely with Data & Revenue Operations functions to support key deliverables 

• Reconciliation of affiliate network revenue by vertical and publisher brand at monthly level

• Where discrepancies exist, investigation by to isolate whether specific days, products, providers, or commission values

• Validate new tickets going on to the Data Engineering JIRA board to ensure requests going into Data Engineering are complete, accurate and as descriptive as possible

• Investigation results to be updated into JIRA tickets and all outputs saved in mapping google sheet

• Use Postman API, Webhooks to pull revenue data from partner portals and verify against partner portals and BQ

• Monitor API failures, rate limits, and response inconsistencies impacting revenue ingestion.

• As necessary, seek revenue clarifications from the vertical’s RevOps team member

• As necessary, clarify JIRA commentary for data engineers

• Understand requirements, goals, priorities, and communicate to the stakeholders on progress towards data goals 

• Ability to ensure outputs are on time and on target

Qualifications

• At least two (2) years of data quality analysis experience 

• A strong understanding of SQL and how it can be used to validate data (experience with BigQuery is a plus)

• An understanding of large, relational databases and how to navigate these datasets to find the data required

• Ability to communicate data to non-technical audiences through the use of reports and visualisations

• Strong interpersonal and communication skills 

• Comfortable working remotely and collaboratively with teammates across multiple geographies and time zones 

Additional Information

Perks:

● Day off on the 3rd Friday of every month (one long weekend each month)

● Monthly Wellness Reimbursement Program to promote health well-being

● Monthly Office Commutation Reimbursement Program

● Paid paternity and maternity leaves