Validate and QA data across UI and API sources, investigate issues, manage taxonomy mismatches, compile non-automated reports, and update/maintain dashboards (Power BI/Tableau). Collaborate with Business Strategy, Investment, and Analytics teams to resolve data and KPI anomalies.
Key Responsibilities - Exp: 5 year
- Data QA & Validation
- 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.
- Taxonomy & Naming Conventions
- Flag mismatches in taxonomies or naming formats.
- Track and manage outstanding taxonomy issues to ensure timely resolution by BST and Investment teams.
- Reports & Dashboards
- Compile and distribute data for non-automated reports.
- Update and maintain existing dashboards (Tableau/Power BI or similar).
Ideal Candidate Profile
- Technical Skills:
- Intermediate SQL skills (ability to query, validate, and troubleshoot data sets).
- Familiarity with BI tools (Tableau, Power BI, Looker, etc.) for dashboard updates.
- Domain Knowledge:
- Media/advertising industry experience strongly preferred (should understand concepts like impressions, reach, delivery, KPIs).
- Soft Skills:
- 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.
Compensation, Benefits and Duration
Minimum Compensation: USD 50,000
Maximum Compensation: USD 175,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is available for independent contractors
No applications will be considered if received more than 120 days after the date of this post
Photon New York, New York, USA Office
New York, United States
Similar Jobs
Healthtech
The Senior Business Intelligence Analyst will transform data into insights, design dashboards, and provide analytical support for strategic decisions, working closely with stakeholders and teams.
Top Skills:
AWSAzureGCPPower BIPythonSQL
Artificial Intelligence • Big Data • Machine Learning • Security • Software • Cybersecurity • Big Data Analytics
As a Business Intelligence Analyst, you will manage analytics projects, build dashboards and reports using SQL and Snowflake, and work with stakeholders to translate data needs into actionable insights.
Top Skills:
BigQueryDbtLookerOmniRedshiftSnowflakeSQLTableau
Security • Cybersecurity
The Business Intelligence Analyst develops and delivers business intelligence solutions, creates Power BI dashboards, ensures data integrity, and collaborates with stakeholders to drive efficiency, enhancing NASA's exploration projects.
Top Skills:
ExcelPower BISharepointSmartsheetSQLVisio
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory



