Note: The job is a remote job and is open to candidates in USA. Pano AI develops AI-powered wildfire detection and intelligence technology that helps fire professionals respond to and contain wildfires more safely. The Analytics Engineer will provide dedicated analytics support to the Operations team by building and maintaining dbt models, SQL-powered Metabase dashboards, data quality processes, vendor performance analysis, and staffing forecasts.
Responsibilities
- Own the dbt models, Metabase dashboards, and self-serve tools that ICs and leadership rely on daily to do their jobs and check KPIs
- Investigate performance differences across vendors and time periods to surface trends and gaps that inform operational decisions
- Catch data quality issues in core reporting tables before they mislead decisions, and implement a fix whether that fix requires a change to underlying dbt models the tooling built on tope of those models
- Perform root-cause analysis of anomalies in vendor and agent performance data using a rigorous, hypothesis-driven approach
- Keep metric definitions consistent as Ops scales across multiple vendors, and proactively catch broken or misleading metrics before they reach a decision-maker
- Forecast staffing needs by analyzing historical incident volume, seasonality, and throughput data — and by identifying and incorporating external data sources (e.g., fire activity, weather, seasonal trends) where they meaningfully improve the forecast
- Analyze headcount and coverage against demand, and support scenario planning for peak wildfire season staffing
- Document findings clearly for both technical and non-technical audiences
- Spend real time with Ops' day-to-day workflows — understanding how agents and leads actually work — and bring that context back into the tools and analysis you build, rather than working solely from the back end
- Travel to international vendor sites to observe operations firsthand and bring those insights back into your analysis and tooling
Skills
- • Proven technical proficiency in SQL, including the ability to manage and sustain production-grade BI infrastructure across platforms like Metabase or Looker
- • Experience using dbt (Cloud or Core) to develop robust data models complete with unit tests and documentation
- • An inquisitive mindset with a commitment to immersing yourself in operational workflows, moving beyond the query editor to understand the human side of the process
- • Proficiency in Python for statistical analysis; hands-on experience with time-series modeling or predictive forecasting is highly valued
- • Ability to identify and integrate relevant third-party datasets to enhance internal analysis and provide a more comprehensive operational picture
- • A rigorous, skeptical approach to data, ensuring you deeply understand what a metric represents before utilizing it for critical decisions
- • Effective collaboration skills for partnering with central data teams, including the ability to define well-scoped and prioritized requests
- • Articulate written communication capable of translating complex analytical findings for both technical peers and operational stakeholders
- • Resilience and adaptability within a high-stakes, rapid-growth environment where data integrity is paramount to operational success
- Hands-on experience with time-series modeling or predictive forecasting is highly valued
Benefits
- Regular full-time roles are eligible for equity.
- Benefits are tailored to local market standards and statutory requirements in the employee's country of employment, and may include health coverage, retirement or pension contributions, and paid time off.
- Hybrid-remote work environment
Company Overview
Company H1B Sponsorship