Power BI Analyst | Onsite

Photon Career Site

87d • $50,000 - $175,000

About The Position

The position involves responsibilities related to data quality assurance and validation, ensuring that data across various sources is accurate and aligned. The candidate will perform investigations into data issues raised by the Business Strategy (BST) and Investment teams, evaluate key performance indicators (KPIs) and delivery trends to identify any anomalies or drop-offs. Additionally, the role includes managing taxonomy and naming conventions, tracking outstanding issues, and ensuring timely resolutions. The candidate will also compile and distribute data for non-automated reports and maintain existing dashboards using tools like Tableau or Power BI.

Requirements

• 5 years of experience in data QA and validation.
• Intermediate SQL skills (ability to query, validate, and troubleshoot data sets).
• Familiarity with BI tools (Tableau, Power BI, Looker, etc.) for dashboard updates.
• Media/advertising industry experience strongly preferred (should understand concepts like impressions, reach, delivery, KPIs).
• Strong attention to detail and problem-solving mindset.
• Ability to work closely with BST, Investment, and Analytics teams to resolve issues quickly.
• Clear communication skills to flag and track issues effectively.

Responsibilities

• Compare data across UI and API sources to ensure accuracy and alignment.
• Perform first-pass investigation of data issues raised by Business Strategy (BST) and Investment teams.
• Evaluate KPI and delivery trends to identify anomalies and drop-offs.
• Flag mismatches in taxonomies or naming formats.
• Track and manage outstanding taxonomy issues to ensure timely resolution by BST and Investment teams.
• Compile and distribute data for non-automated reports.
• Update and maintain existing dashboards (Tableau/Power BI or similar).

Benefits

• Medical, vision, and dental benefits
• 401k retirement plan
• Variable pay/incentives
• Paid time off
• Paid holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees