Senior Analytics Engineer, BI

Lime is the world's largest shared electric vehicle company. We’re on a mission to build a future where transportation is shared, affordable and carbon-free. Our electric bikes and scooters have powered 700+ million rides in 250+ cities on 5 continents, replacing an estimated 150+ million car trips. Named a Time 100 Most Influential Company and Fast Company Brand That Matters, Lime continues to set the pace for shared micromobility globally.

Lime is hiring a Senior Analytics Engineer to join our Data Science & Analytics team! In this role, you will report to the Manager of Analytics Engineering & BI and play a critical role in enhancing developer productivity across our data ecosystem. Your primary focus will be partnering with consumers of our data warehouse to ensure that our analytics infrastructure is scalable, performant, and easy to use for data professionals across the company.

Lime is at an exciting inflection point as we rapidly scale our data capabilities to support business growth. As we transition to a more structured, high-performing organization, we need someone who can immediately contribute by writing clear, efficient SQL and optimizing our data workflows. The ideal candidate has experience modeling B2C data using dbt and a deep understanding of ELT best practices. This is a unique opportunity to have an outsized impact—by improving data accessibility, enabling self-service analytics, and driving the efficiency of Lime’s data teams.

What You’ll Do

• Build and maintain scalable analytics infrastructure, including dbt transformations, legacy pipelines, and Tableau reporting.
• Develop and optimize complex SQL transformations to create reliable, high-performance datasets for reporting and self-service analytics.
• Collaborate with stakeholders (data scientists, product managers, and software engineers) to ensure analytics solutions align with business needs.
• Enforce data governance best practices, including documentation, lineage tracking, and data quality validation.
• Enable self-service analytics by structuring BI tools effectively and providing clear data documentation.
• Evaluate and integrate new technologies to improve automation, orchestration, and overall analytics workflows.
  
  

About You

• Expert reader and writer of SQL code with experience in performance tuning and query optimization.
• 5+ years of experience in analytics engineering, data modeling, or related fields.
• Experience with modern ELT best practices, especially dbt core.
• Proven ability to translate business requirements into scalable data models.
• Strong communication skills and ability to collaborate with both technical and non-technical stakeholders.
  
  

Preferred Experience

• Experience modeling B2C data.
• Familiarity with orchestration tools such as Airflow.
  
  

If you want to make an impact, Lime is the place for you. Not sure if you meet all the qualifications? If this role excites you we encourage you to apply. Explore all opportunities on our career page.

Lime is an Equal Opportunity Employer, but that’s just the start. We believe different perspectives help us grow and achieve more. That’s why we’re dedicated to hiring and developing the most talented and globally diverse team – which includes individuals with different backgrounds, abilities, identities and experiences. Applicants who require a reasonable accommodation for any part of the application or hiring process can email [email protected] for assistance.

Use of artificial intelligence or an LLM such as ChatGPT during the interview process will be grounds for rejection of your application.

Compensation Range: CA$107K - CA$147K