Senior Data Analyst
About The Position
As part of our Technology & Analytics team, you help architect the systems, insights, and intelligence that power smarter decisions across the agency. The Builders and Translators connect strategy, activation, and performance by transforming raw data into meaningful action. Your work ensures our teams and clients can move with clarity, confidence, and precision. As a Senior Data Analyst, you will own end-to-end data integrity across media and advertising clients, helping ensure the accuracy, reliability, and performance of the data that powers decision-making. This role combines deep technical expertise with client partnership, requiring someone who can both solve complex data challenges and communicate clearly with internal and external stakeholders. You’ll work closely with teams across Media, Account Services, Ad Operations, and Technology to implement tracking solutions, troubleshoot issues, validate performance data, and continuously improve how we scale analytics operations across the agency.
Requirements
- 4+ years of experience in data analytics, marketing analytics, advertising technology, or media analytics within an agency, SaaS, or client-facing environment
- Advanced proficiency in Microsoft SQL Server, including T-SQL, CTEs, joins, window functions, stored procedures, and query optimization
- Hands-on experience implementing and troubleshooting tracking technologies such as Google Tag Manager, Meta Pixel, Adobe Launch, or equivalent platforms
- Strong understanding of digital media measurement, including attribution, conversion tracking, campaign pacing, impressions, clicks, and media flighting
- Experience working with large datasets across multiple platforms and systems
- Familiarity with BI and visualization tools such as Tableau, Power BI, or Looker
- Exceptional analytical thinking and structured problem-solving skills
- Strong attention to detail with a commitment to data accuracy and reliability
- Ability to communicate technical concepts clearly to both technical and non-technical audiences
- Strong organizational skills with the ability to manage multiple priorities in a fast-paced environment
- Collaborative mindset with experience working across disciplines and stakeholder groups
- Curiosity-driven approach to learning, testing, and continuous improvement
- Confidence navigating ambiguity and solving complex, multi-layered technical challenges
- You must be authorized to work in the United States for any employer. At this time, we are not sponsoring or providing assistance with obtaining work authorization.
Nice To Haves
- Exposure to cloud data environments such as Snowflake, BigQuery, or Azure is preferred
- Experience with Python or R for data analysis or automation is a plus
- Knowledge of programmatic media platforms such as DV360, The Trade Desk, or Amazon DSP is preferred
Responsibilities
- Lead end-to-end onboarding for new clients, including discovery conversations, requirements gathering, tracking implementation, and validation of data flows
- Partner directly with clients and technical teams to implement, test, and troubleshoot tracking pixels across websites, apps, and media platforms
- Diagnose and resolve complex data discrepancies related to pixel firing, custom code conflicts, tagging issues, API sync failures, and media flight scheduling
- Perform ongoing quality control checks to ensure data accuracy, consistency, and completeness across reporting systems and dashboards
- Write advanced SQL queries and transformation logic to extract, reconcile, and analyze large datasets from multiple data sources
- Serve as a trusted technical resource for clients, translating complex data challenges into clear, actionable insights and solutions
- Build scalable QA frameworks, documentation, and repeatable processes that improve operational efficiency and reduce recurring issues
- Collaborate cross-functionally with Media, Ad Operations, Engineering, Creative, and Account teams to ensure alignment across the campaign lifecycle
- Support optimization and reporting efforts by identifying trends, anomalies, and opportunities within campaign and audience data
- Contribute to the evolution of our analytics infrastructure and data best practices as the agency continues to scale
Benefits
- Flexible Paid Time Off
- Comprehensive Medical, Dental, and Vision plans
- Competitive Parental Leave that gives you time to bond with your family
- Hybrid work model with in-office collaboration
- Mental health support
- Annual agency contribution to 401(k)
- Flexible Spending Accounts (FSAs) and Healthcare FSA
- Commuter benefits and corporate discounts
- Carrot Fertility and family-building support
- Employee Assistance Program (EAP)
- Casual work environment, team building, and other social events
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
