Data Quality Analyst

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 Mastery 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: 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 Show more Show less