Analytics Engineer

Role Overview

• 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

• 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

Tech Stack

• Postgres
• Python
• SQL

Benefits

• 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