Data Analyst

TL;DR Fast-growing measurement company seeking a versatile Data Analyst eager to transform data into actionable insights for leading brands and agencies. Ideal for a proactive problem-solver who can balance autonomy with responsiveness in a role where quiet stretches and urgent deliverables often coexist. Who We Are Adelaide is the leader in one of the fastest-growing areas of digital advertising: attention metrics. Since 2020, we’ve been a trusted measurement partner for 40% of Fortune 50 companies. They rely on our metric, AU, to maximize the effectiveness of media spend. AU is “the attention economy's most widely recognized metric,” according to Adweek, and we swept the measurement category in the 2024 Adexchanger awards. Our business is growing rapidly—we’ve doubled revenue in just 18 months and grew our team by 45% last year. Earlier this year, in partnership with The New York Times, we launched Adelaide for Publishers, the next step in our vision to create a more fair and equitable marketplace for media. Adelaide is backed by prominent investors such as Human Ventures (Joe Marchese), Aperiam Ventures (Joe Zawadzki & Eric Franchi), WGI (Jonah Goodhart), and Irwin Gotlieb. While we have an office in NYC, we’re very remote-friendly and support flexible work arrangements. How We Operate We are a team of action-oriented doers; management rolls up their sleeves to contribute daily. Our culture is rooted in curiosity and loosely held but rigorously vetted opinions; everyone is encouraged to contribute to planning and strategy. Position Overview This position reports to the Director of Analytics; it works to standardize and automate analytical processes. In this role, you will join a team of Data Analysts who support our clients by delivering media quality analysis, campaign reporting, and optimization opportunities to advertisers, agencies, and publishers alike. You’ll be responsible for developing and automating reporting workflows and insights tools for both internal and external use. Day-to-day activities will include SQL querying, Excel modeling, client reporting and insight delivery. We’re seeking a candidate with 2+ years of experience in programmatic advertising and digital media analytics. This is a fully remote position within the United States, with opportunities to connect with colleagues at our New York office. You can expect to visit NYC a few times per year. What You'll Learn An important part of our culture is continuing education and the sharing of ideas. We offer:

• A large network of investors and advisors for you to access that will help your team succeed
• Mentorship from executives with decades of experience in adtech and media
• Regular internal knowledge-sharing sessions
• Education budget to accelerate your team’s development

Specifically, In This Role, You Will Learn

• Gain a deep understanding of attention metrics and media quality measurement
• Work alongside Senior Analysts and Data Scientists to build scalable solutions for our business
• Learn how business units collaborate by working within a transparent, cross-functional environment
• Network with industry leaders to drive adoption

Core Responsibilities

• Use SQL and Excel to explore, clean, and filter data in preparation for analysis
• Collaborate with other teams to ensure data quality, accuracy, and consistency
• Aid in the automation of analytics processes using Python and Excel modeling
• Create reports and dashboards that communicate key findings and trends to clients
• Provide client support by answering questions, resolving issues, and providing guidance on how to use our platform and metric
• Stay updated on the latest developments and best practices in the digital media industry

What You'll Bring

• Client Engagement & Insight Delivery – Experience communicating directly with clients to present findings, answer questions, and translate analytical results into actionable recommendations; able to build trust, tailor insights to different audiences, and support strategic decision-making through data.
• SQL Proficiency - ability to write, optimize, and debug SQL queries; solid understanding of data modeling concepts and warehouse best practices a plus
• Excel Expertise – command of Excel, including pivot tables, lookup functions, and formula-based analysis to support data exploration and reporting tasks; working knowledge of Macros a plus
• BI & Visualization Tools - Hands-on experience with BI/dashboarding platforms (e.g. Looker, Tableau); familiarity with semantic modeling layers a plus (e.g. LookML, dbt) a plus
• Programming Skills - familiarity with Python for data transformation, scripting, and automation; experience with associated libraries (e.g. pandas, openpyxl) a plus
• Data Quality & Testing - Strong attention to detail in building data validation, profiling routines, and root cause analysis workflows
• Communication & Collaboration - Excellent interpersonal skills with experience working cross-functionally; ability to translate technical concepts for non-technical audiences and deliver training/support
• Educational Background & Experience - Bachelor’s degree in a quantitative, technical, or analytical field (e.g. Computer Science, Math, Physics, Engineering) or a rigorous coding bootcamp with a portfolio demonstrating the above skills.

Benefits Health & Wellness

• Medical, dental, and vision insurance
• Paid time off
• Parental leave
• Wellness & Development Stipend
• Holiday break
• Volunteer time off

Financial & Compensation

• Competitive salary
• Stock options
• 401k Retirement Plan

Workplace & Equipment

• Remote-first environment
• New York office
• Access to WeWork spaces available

Equal Employment Opportunity (EEO) Statement Adelaide is proud to be an Equal Opportunity Employer, committed to fostering a diverse, equitable, and inclusive workplace where all employees can thrive. We consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other legally protected status. Our commitment to equal opportunity employment extends beyond basic compliance to encompass the active cultivation of a workplace that values different perspectives, backgrounds, and experiences. The Pay Range For This Role Is 75,000 - 90,000 USD per year(Remote)