Lime, building a future of shared, affordable, and carbon-free transportation, is hiring a Staff Analytics Engineer for its Data Science & Analytics team. You will act as the principal architect for the management reporting warehouse, partnering with Finance leadership to design systems with high governance to support business performance data and external audits.

What You'll Do

Design the long-term technical vision for Lime’s management reporting warehouse to build a robust, scalable semantic layer that supports FP&A, Accounting, and Strategy.
Define and enforce the organization's standards for dbt modeling, SQL style, CI/CD workflows, and data testing, ensuring audit-grade precision.
Enforce strict data governance best practices, including comprehensive documentation and automated data quality validation to support audit requirements.
Collaborate with Finance stakeholders to ensure analytics solutions support month-end close, quarterly business reviews, and board-level reporting.
Evaluate and integrate technologies that improve the automation and orchestration of reporting pipelines, reducing manual intervention and risk.

What We're Looking For

9+ years of experience in analytics engineering or data warehousing, with a proven track record of designing data architectures that have scaled with a company's hyper-growth.
Deep expertise in dbt Core internals (macros, custom materializations, package management) and a philosophy on how to structure large-scale dbt projects for performance and maintainability.
Expert at modeling concepts like Contribution Margin, Cohort Retention, and Utilization Rates, and translating these business concepts into immutable code.
Demonstrated ability to influence technical and non-technical stakeholders at the Director/VP level, navigating conflicting requirements to reach the best long-term technical solution.

Nice to Have

Experience designing systems for strict internal controls or working in a heavily regulated environment.
Deep familiarity with orchestration tools and how they interact with the transformation layer.

Technical Stack

dbt Core
SQL

Team & Environment

Sits within the central data team, reporting to Lime’s leader of Analytics Engineering & BI.

Benefits & Compensation

Comprehensive Health & Wellness: A choice of medical, dental, and vision plans. Company-paid life and disability insurance and company-funded mental health benefits.
Financial & Retirement Planning: 401(k) plan with pre-tax and Roth options, and access to a Health Savings Account (HSA) with a monthly company contribution.
Family & Fertility Support: Paid parental leave for birthing and non-birthing parents, plus fertility and family-forming benefits.
Paid Time Off: Unlimited vacation, paid leaves, and 10 company holidays.
Unique Lime Perks: Complimentary use of Lime vehicles in participating cities, a monthly phone allowance, dedicated learning and development days, and access to perks including One Medical, Wellhub, and Headspace.

Work Mode

This is a remote position open to candidates in Canada and the United States.

Lime is proud to be an Equal Opportunity Employer. We consider all qualified applicants for employment, including those with arrest or conviction records, in accordance with applicable federal, state, and local laws.