Junior Analytics Engineer

Adelaide; United States; Remote; USD 65,000 - 85,000; Full time

Job summary

Adelaide, a leading digital advertising measurement company, is seeking an entry-level analytics engineer to build and maintain data models and collaborate with cross-functional teams. This fully remote position offers mentorship, learning opportunities, and a supportive work culture focused on innovation. Ideal candidates will possess strong SQL skills and a degree in a quantitative field.

Benefits

Medical, dental, and vision insurance

Paid time off

Parental leave

Wellness & Development Stipend

Performance-based quarterly bonus

Stock options

401k Retirement Plan

Qualifications

• 0-2 years of experience in analytics or data engineering.
• Strong ability to write and debug SQL.
• Hands-on experience with BI/dashboarding tools like Looker or Tableau.

Responsibilities

• Assist in building and maintaining data models with dbt.
• Help create reliable reporting layers in Looker using LookML.
• Collaborate with stakeholders to automate data analysis processes.

Skills

SQL Proficiency

Data Quality & Testing

Communication & Collaboration

Creative Problem Solving

Education

Bachelor’s degree in a quantitative field

Tools

Looker

dbt

Python

Job description

Fast-growing measurement company looking for an entry level analytics engineer to help bridge the gap between data engineering and data analysis.

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 Senior Data Analytics Engineer; it will behave cross functionally across Data teams with an emphasis on supporting the Analytics team and their workflows.

In this role, you will be joining a team of data scientists and engineers. You'll help build and maintain the semantic layer of our data pipeline, ensuring clean, consistent, and reusable data models. Day-to-day activities range from developing and testing data models, editing LookML, managing a data catalog, automating data analysis workflows, and working closely with stakeholders to understand and support their data needs.

We’re seeking a candidate with 0-2 years of experience in analytics, data engineering, or a related field, and a passion for building clean, reliable data systems.

This is a fully remote position within the United States, with opportunities to connect with colleagues at our New York office. You will need to be in 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
• How to build and maintain modular, scalable data models using tools like dbt and Looker (LookML)
• Best practices for working millions of data points
• How to collaborate effectively across teams to meet stakeholder needs

Core Responsibilities

• Assist in building, testing, and maintaining transformational data models (dbt, Redshift)
• Help create and manage a clean, reliable reporting layer in Looker using LookML
• Work cross functionally with emphasized support to the Analytics Team
• Help identify and automate manual data analysis processes (python, dbt)
• Contribute to maintaining a well-organized data catalog with accurate, accessible metadata for both technical and non-technical audiences
• Ensure metric consistency across dashboards and data tools
• Collaborate with analysts and PMs to document key metrics and definitions
• Monitor adoption and identify opportunities for improved data usability

What you'll bring

• SQL Proficiency - Strong ability to write, optimize, and debug SQL queries. You also understand data modeling and warehouse best practices, and you’re committed to writing clean, readable, and well-documented code.
• BI & Visualization Tools - Hands-on experience with BI/dashboarding platforms (e.g. Looker, Tableau).
• Data Modeling Tools - Familiarity with semantic modeling tools (e.g. LookML) and dbt; understanding of ETL concepts. Experience with orchestration tools (e.g. Airflow) is a plus.
• Data Quality & Testing - Strong attention to detail in building data validation, profiling routines, and root cause analysis workflows
• Programming Skills - Experience with Python for data transformation, scripting, and automation; experience with associated libraries (e.g. pandas, openpyxl) is a plus
• 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

What will set you apart

• A Creative Problem Solver - Approaches problems with an open mind finding innovative solutions to data wrangling, transformation, and analytics that drive real business impact
• Comfortable with ambiguity - You’re at ease with incomplete requirements or changing stakeholder needs, and you excel at asking the right questions to find solutions
• Relevant Tech Stack Experience - Familiarity with tools like Looker, Redshift, S3, and dbt
• Medical, dental, a nd vision insurance
• Paid time off
• Parental leave
• Wellness & Development Stipend
• Holiday break
• Volunteer time off
• Performance-based quarterly bonus
• Stock options
• 401k Retirement Plan

Workplace & Equipment

• 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:

65,000 - 85,000 USD per year (Remote (United States))