Senior Analytics Engineer

Summary

Join Liftoff as an Analytics Engineer and bridge the gap between data engineering and data analysis, transforming raw data into clean, structured datasets. You will design and maintain efficient data models, develop user-facing data products using SQL and Looker, and optimize Liftoff's BI layer. Responsibilities include independently completing tasks, resolving technical debt, maintaining data pipelines, and collaborating with users to optimize queries. This role requires a Bachelor's degree in Computer Science or a related field, 5+ years of SQL experience, and 2+ years of Looker experience. Proficiency in Python and experience with JupyterLab and DBT are also necessary. The position offers full-time remote work in the Pacific Time Zone and a full compensation package including equity and health/vision/dental benefits. Travel is required for planning meetings and other work events.

Requirements

• Minimum Bachelors Degree in Computer Science or related field
• 5+ years of experience with SQL , including expertise in writing efficient, optimized queries
• Strong experience with Data Analytics and a solid understanding of query plans and data model optimization
• 2+ years of experience with Looker , including developing user-facing dashboards, reports, and complex data models
• Proficiency in Python for data analysis, automation, and integration with data workflows
• Experience with JupyterLab for interactive analysis, data exploration, and creating reproducible workflows
• Experience with DBT , Rill , and Looker for data modeling and BI tools
• Strong knowledge of database fundamentals (execution plans, join strategies, etc.), with the ability to tune queries for performance
• Excellent communication skills and experience collaborating with different teams to understand requirements

Responsibilities

• Design and maintain efficient data models for company-wide analysis , collaborating closely with business users
• Develop user-facing data products using SQL and analytics on core infrastructure managed by the Data Engineering team
• Optimize and improve Liftoff 's Looker-based BI layer to scale and meet business needs
• Independently complete tasks , managing your priorities and contributing to larger projects with minimal supervision
• Identify and resolve technical debt, improving team productivity and project health
• Maintain and troubleshoot data pipelines, ensuring reliable operation
• Collaborate with users to optimize queries, design aggregations, and suggest performance improvements
• Follow best practices like version control and CI/CD, ensuring maintainable and scalable code
• Ensure high-quality work that meets security, reliability, and privacy standards

Preferred Qualifications

• Experience in ad-tech
• Knowledge of AgroCD , Kubernetes , AWS , and Github
• Familiarity with Big Data technologies like Apache Spark or Databricks
• Experience with a second programming language (especially Scala )
• Familiarity with machine learning workflows

Benefits

• Health/vision/dental benefits
• Equity
• Full-time remote work