Note: The job is a remote job and is open to candidates in USA. Adelaide is a fast-growing measurement company focused on attention measurement and activation. They are seeking an entry-level analytics engineer to support data teams, maintain data models, and improve data accessibility across the organization.
Responsibilities
- Contribute to maintaining a well-organized data catalog with accurate, accessible metadata for both technical and non-technical audiences
- Build, test, and maintain SQL-based data models in the data warehouse (Redshift) to support reporting and analytics
- Help create and manage a clean, reliable reporting and semantic layer in Looker using LookML, ensuring business logic and metrics are clearly defined and reusable across dashboards
- Work cross functionally across Account Managers, Customer Success, and Analytics to support reporting needs and improve data accessibility
- Monitor data adoption and identify opportunities to improve data usability and self-service analytics
Skills
- 0-2 years of experience in analytics, data engineering, or a related field
- SQL Proficiency - Strong ability to write, optimize, and debug SQL queries
- Hands-on experience with BI/dashboarding platforms (e.g. Looker, Tableau)
- Experience building SQL-based data models in a data warehouse environment
- Strong attention to detail in building data validation checks, profiling routines, and root cause analysis workflows
- Excellent interpersonal skills with experience working cross-functionally
- 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
- Familiarity with semantic modeling tools (e.g. LookML)
- Exposure to transformation frameworks such as dbt
- Understanding of ETL/ELT concepts
- 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
- Familiarity with tools like Looker, Redshift, S3, and dbt
Benefits
- Medical, dental, and vision insurance (for US)
- Paid time off
- Parental leave
- Employee development & wellness stipend
- Holiday break
- Volunteer time off
- Performance-based quarterly bonus
- Stock options
- 401(k) retirement plan (for US)
- Remote-first environment
- New York office access
- Access to available WeWork spaces
Company Overview
Adelaide develops a media analytics platform to measure omnichannel media quality. It was founded in 2019, and is headquartered in New York, New York, USA, with a workforce of 51-200 employees. Its website is https://www.adelaidemetrics.com/.