Senior Analytics Engineer

Opiniion Inc. is a resident satisfaction software company that partners with property management companies to improve living experiences. They are seeking a Senior Analytics Engineer to build the analytics layer on top of their data infrastructure, focusing on data modeling, dashboard creation, and stakeholder collaboration.

Responsibilities:

• Build and maintain dimensional and semantic models in Databricks that serve as the analytics layer for the company, working within a medallion architecture (bronze, silver, gold)
• Own the gold layer — write clean, tested, version-controlled SQL transformations that turn curated silver-layer data into business-ready tables optimized for reporting and analysis
• Partner with data engineers on data quality, lineage, and freshness across the medallion layers to ensure models are reliable and well-documented
• Design and build dashboards and topics in Omni Analytics for Product, Client Success, Sales, Marketing, and executive stakeholders
• Implement governance practices for dashboards: naming conventions, documentation, version control, and testing
• Create client-facing analytics views that can be shared externally to demonstrate platform value
• Collaborate with Product and leadership to document KPI definitions and implement them consistently across all reporting surfaces
• Contribute to a metric catalog so that stakeholders reference the same numbers from the same source
• Flag data quality issues proactively and work with the data engineering team to resolve them
• Conduct deep-dive investigations into conversion drops, data mismatches, and funnel issues using SQL and platform tooling
• Document findings and build repeatable analysis runbooks so investigations don’t start from scratch each time
• Partner with product engineering to identify gaps in event instrumentation and recommend improvements
• Help internal teams learn Omni Analytics so they can answer routine questions without filing a request
• Write lightweight documentation for dashboards, data models, and common queries

Requirements:

• 5+ years in analytics engineering, BI development, or product analytics roles
• Advanced SQL — you write complex, performant queries daily and are comfortable with window functions, CTEs, and large-scale data
• Hands-on experience with a modern BI tool (Omni, Looker, or similar) — building explores, semantic layers, and governed dashboards
• Experience with Databricks, BigQuery, or a comparable cloud analytics platform for data modeling and transformation
• Familiarity with medallion layer architecture (bronze/silver/gold) is strongly preferred
• Familiarity with ELT/ETL orchestration tools (Fivetran, dbt, or similar)
• Product-minded: you don't just build tables — you understand what questions the business is trying to answer and work backward from there
• Builder mentality: you prefer creating tested, documented, reusable assets over one-off queries
• Clear communicator: you can explain data findings to non-technical stakeholders in writing and in conversation
• Cross-team collaborator: you proactively build relationships across departments, seek out context before building, and make sure your work is shaped by the people who will use it — not just the people who requested it
• Comfortable with ambiguity: this is a first-of-its-kind role at Opiniion, and you'll help shape how analytics work gets done
• dbt or similar modeling/testing frameworks
• Python for light ETL, scripting, or anomaly detection
• Comfortable working with data from MongoDB or other NoSQL sources
• GA4 or product analytics instrumentation experience
• Proptech, real estate technology, or multifamily industry experience
• Experimentation platforms or statistical analysis background