Analytics Engineer

Mantis Innovation provides managed facility services and turnkey program management with technology-enabled solutions that target the entire building footprint. We look at the entire facility—inside and out—and can impact 70% of what a building operator allocates critical budget dollars toward, including: Strategic electricity and natural gas procurement, renewable energy, and demand response; climate impact reduction and reporting, net zero strategies, and sustainability planning; roofing, solar, HVAC assessment management, pavement, building envelope, data center optimization, and EV charging; lighting/LED retrofits, HVAC/mechanical systems, and BMS/BAS improvements and implementation.Mantis is a tech-enabled facilities, energy, and sustainability partner to enterprise and upper-mid-market organizations with complex, multi-site portfolios. We combine advisory services, proprietary technology, and turnkey execution to help clients reduce operating costs, manage risk, and improve building performance.Three things make that work: deep domain expertise, an unusual operating model that pairs advisory with execution, and a serious investment in data and technology. Mantis is a data-hungry company. Data is not a side function here it is what fuels how we run the business internally and how customers experience value externallThe OpportunityMantis operates three proprietary platforms: Procure (energy procurement and reverse auctions), Perform (the unified client portal for asset management, energy, rebates, and efficiency), and Pacific (our enterprise reporting and analytics platform).Pacific is the data backbone. It pulls from every internal system and key external sources to power sales operations, financial forecasting, KPIs, and executive scorecards — and, through ThoughtSpot embedded inside Perform, delivers analytics directly to our customers as part of the product. Pacific is also the foundation we built so AI works reliably at Mantis: the data layer where most companies struggle, we addressed first.We are scaling Pacific. The updated customer engagement platform, Perform, launches June 1. Embedded customer analytics is moving toward tiered paid offerings. Internal demand for trusted reporting is accelerating. Today, Pacific is owned by a single analytics engineer; that does not scale. We are hiring an Analytics Engineer to build alongside the platform lead: own production analytics work end-to-end, raise the bar on quality and documentation, and help shape how AI-assisted analytics engineering operates on top of a real data foundation.We expect an established practitioner who can ship.What You’ll DoBuild and maintain dbt models on the Pacific Postgres warehouse, fed by Stitch and FivetranDevelop PowerBI reports and SQL analyses for internal stakeholders: sales operations, financial forecasting, KPIs, executive scorecardsBuild and extend ThoughtSpot Liveboards embedded inside the Perform customer portal, delivering Pacific-powered analytics directly to customersPartner with Product, Sales Operations, and Finance to define KPIs across Procure and Perform — internal and customer-facingOwn data quality, testing, and documentation hygiene across dbt and downstream BIContribute to ELT pipeline reliability — source health, refresh cadence, schema change managementUse Claude as a core part of your workflow — AI-assisted SQL and dbt development, data Q&A, documentation, accelerated report iteration — and help define how analytics engineering at Mantis runs AI-forwardRequiredWhat you Bring4–6 years of analytics or data engineering experienceStrong SQL and database experienceDimensional modeling fundamentalsProduction dbt experience (models, tests, documentation)Comfort with git-based development and code reviewA track record of shipping BI dashboards or embedded analytics to non-technical audiencesClear written communication; able to explain analytical decisions to business stakeholdersNice To HaveStitch, Fivetran, or comparable modern data pipeline toolingPostgresPower BI and ThoughtSpot (or other embedded analytics - Sisense, Looker)SQL and Python for data workHands-on experience using Claude or another LLM in analytics workflowsExposure to facilities, energy, real estate, or industrial dataPrior partnership with product engineering and FP&A teamsWhat We Care About Beyond The Checklist CuriosityBusiness acumenA bias toward shipping work that actually gets usedPacific is not a side project; it is a foundational element of our enterprise.Your work will show up in:Board decksSales pipeline reviewsThe screens our customers log into every dayHow You’ll Grow Months 1–6Own a Pacific reporting domain end-to-endShip production dbt models and downstream PowerBI or ThoughtSpot deliverablesBuild relationships across product, ops, and financeMonths 6–12Contribute to architecture and KPI standards alongside the function leadTake point on a cross-functional analytics initiativeYear 2+Develop into a senior analytics engineer and co-lead on PacificGain direct visibility to the CTOHave a clear path to broader scope as the team growsWhy Mantis A data foundation that is real.Pacific has been built deliberately over years.You will not spend your first six months untangling broken pipelines — you will build on a working stack and extend it where it matters.Customer-facing impact.Pacific data is not just for internal dashboards.It powers the analytics our customers use to make capital and operational decisions on their own portfolios.AI without the hype.We use Claude as a working tool, every day, because the data underneath supports it.You will help define how that operates as a discipline, not a demo.Scale with backing.Mantis is private equity–backed (Blackstone) and in an active growth phase, both organic and through acquisition.Analytics is core to how that scale gets executed.Ownership early.This is a two-person function today.The work you do is visible, and it matters.$105,000 - $130,000 a yearNote: Employees are held accountable for all duties of this job. This job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the position. What else can we offer you? We offer a fantastic lineup of benefits, including Medical, Dental, Vision, FSA, HSA, 401k Matching, Paid Vacation, Paid Sick, Paid Holidays, Paid Parental Leave, Paid Short Term & Long Term Disability, Tuition Reimbursement, and a flexible hybrid work schedule (for office-based employees). Working at Mantis also brings tremendous professional development opportunities that allow you to make a real impact on both the company and your career!Not sure you meet every single requirement?Studies show that women and individuals from underrepresented groups often hesitate to apply unless they check every box. At Mantis, we’re committed to building an inclusive and equitable team—so if this role excites you, we’d love to hear from you, even if your experience doesn’t match every single qualification.Mantis Innovation is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.