Business Intelligence Engineer

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. Compensation Base Salary Range: $80,000-$100,000 This role includes a competitive compensation package consisting of base salary, performance-based bonus, and equity. Final compensation will be determined based on experience, level, and location. What you'll learn An important part of our culture is continuous learning and the open sharing of ideas. We offer: Access to a broad network of investors and advisors who can help you and your team succeed Mentorship from executives with decades of experience in adtech and media Regular internal knowledge-sharing sessions An education budget to support ongoing professional growth and development In this role you'll 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 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 What you'll bring SQL Proficiency - Strong ability to write, optimize, and debug SQL queries. You understand data modeling and warehouse best practices and are committed to writing clean, readable, and well-documented code. BI & Visualization Tools - Hands-on experience with BI/dashboarding platforms (e.g. Looker, Tableau) and familiarity with building or supporting a semantic layer for reporting. Data Modeling Tools - Experience building SQL-based data models in a data warehouse environment. Familiarity with semantic modeling tools (e.g. LookML) and exposure to transformation frameworks such as dbt is a plus. Understanding of ETL/ELT concepts is expected. Data Quality & Testing - Strong attention to detail in building data validation checks, profiling routines, and root cause analysis workflows to ensure reliable reporting data. Communication & Collaboration - Excellent interpersonal skills with experience working cross-functionally. Ability to translate technical concepts for non-technical audiences and help support adoption of data tools. 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 Benefits Health & Wellness Medical, dental, and vision insurance (for US) Paid time off Parental leave Employee development & wellness stipend Holiday break Volunteer time off Financial & Compensation Competitive salary Performance-based quarterly bonus Stock options 401(k) retirement plan (for US) Workplace & Equipment Remote-first environment New York office access Access to available WeWork spaces 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.