Analytics Engineer

Mantis Innovation

Analytics Engineer responsible for building data models and reporting solutions for Mantis Innovation's analytics platform. Focused on driving data-driven decision-making through scalable solutions.

Posted 5/14/2026full-timeHouston • Texas • 🇺🇸 United StatesMid-LevelSenior💰 $105,000 - $130,000 per yearWebsite

Tech Stack

Tools & technologies

PostgresPythonSQL

About the role

Key responsibilities & impact

Build and maintain dbt models on the Pacific Postgres warehouse, fed by Stitch and Fivetran
Develop PowerBI reports and SQL analyses for internal stakeholders: sales operations, financial forecasting, KPIs, executive scorecards
Build and extend ThoughtSpot Liveboards embedded inside the Perform customer portal, delivering Pacific-powered analytics directly to customers
Partner with Product, Sales Operations, and Finance to define KPIs across Procure and Perform — internal and customer-facing
Own data quality, testing, and documentation hygiene across dbt and downstream BI
Contribute to ELT pipeline reliability — source health, refresh cadence, schema change management
Use Claude as a core part of your workflow — AI-assisted SQL and dbt development, data Q&A, documentation, accelerated report iteration

Requirements

What you’ll need

4–6 years of analytics or data engineering experience
Strong SQL and database experience
Dimensional modeling fundamentals
Production dbt experience (models, tests, documentation)
Comfort with git-based development and code review
A track record of shipping BI dashboards or embedded analytics to non-technical audiences
Clear written communication; able to explain analytical decisions to business stakeholders
Nice to Have:
Stitch, Fivetran, or comparable modern data pipeline tooling
Postgres
Power BI and ThoughtSpot (or other embedded analytics - Sisense, Looker)
SQL and Python for data work
Hands-on experience using Claude or another LLM in analytics workflows
Exposure to facilities, energy, real estate, or industrial data
Prior partnership with product engineering and FP&A teams

Benefits

Comp & perks

Medical
Dental
Vision
FSA
HSA
401k Matching
Paid Vacation
Paid Sick
Paid Holidays
Paid Parental Leave
Paid Short Term & Long Term Disability
Tuition Reimbursement
Flexible hybrid work schedule

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdbtdimensional modelingPower BIThoughtSpotPythondata qualityELT pipelinedata analysisdocumentation

Soft Skills

clear written communicationanalytical decision explanationcollaborationstakeholder engagementcode reviewproblem-solvingattention to detailorganizational skillsadaptabilitycustomer-facing communication