Analytics Engineer

Havenparkcommunities

Where
Hybrid in Orem, UT

Posted 55 days ago· Checked live at Havenparkcommunities 1 hour ago

Stale: open 55 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what Havenparkcommunities asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Havenparkcommunities's own hiring page 1 hour ago.
What is the job?
We're building a modern analytics platform from the ground up: a layered, well-tested data model in Snowflake that becomes the single source of truth for the business, and a governed semantic layer that lets stakeholders, not just analysts, ask questions and get trustworthy answers. As an Analytics Engineer, you own the transformation layer.
What does it pay?
The posting doesn't say.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

We're building a modern analytics platform from the ground up: a layered, well-tested data model in Snowflake that becomes the single source of truth for the business, and a governed semantic layer that lets stakeholders, not just analysts, ask questions and get trustworthy answers.

As an Analytics Engineer, you own the transformation layer.

What you'll do

  • Build the Core data model. Design and implement facts and dimensions in dbt following a disciplined staging → intermediate → core → mart architecture. Model slowly changing dimensions, handle mixed-grain snapshot sources, and make defensible grain and materialization decisions.
  • Migrate legacy reporting onto Core. Reconstruct existing business-critical views and reports on top of the new model, reconciling outputs line-for-line so stakeholders can trust the cutover.
  • Work fluently with AI in the loop. Use AI coding tools to accelerate model development, test writing, and the dbt/GitHub workflow, while critically reviewing every output, correcting it, and taking full ownership of correctness, performance, and style.
  • Own data quality. Write dbt tests (generic, singular, and unit), establish contracts on data-out models, and treat a failing CI check as a release blocker, not a suggestion.
  • Integrate diverse sources. Work across data from a myriad of sources, each with its own quirks, grains, and coverage gaps you'll need to understand and document.
  • Build the semantic / AI-ready layer. Curate mart models and metric definitions with the metadata (certification, PII level, known issues) that powers governed self-service and agentic AI, so non-analysts can safely ask their own questions.
  • Raise the bar on engineering practice. Small, reviewable PRs; a shared style guide; version control as the source of truth; documentation that the next engineer — or AI agent — can actually use.

Nice-to-haves

  • Experience using AI coding assistants (e.g., Claude Code, Copilot, Cursor) in a professional, review-gated workflow.
  • ELT tooling (Fivetran, CData) and experience taming third-party source schemas.
  • Semantic layer/metrics layer work, or experience preparing data for AI/LLM consumers.
  • BI tooling (e.g., Power BI, Sigma) and partnering directly with report consumers.
  • Domain exposure to real estate, property management, finance/GL, or operations.
  • Python for ancillary tooling and automation.

Why you'll like it here

  • Greenfield with guardrails. You're building the platform, not babysitting legacy — but with real standards, code review, and CI from day one.
  • AI-accelerated, human-owned. We give you the best modern tooling to move fast, and we trust you to own the outcome. Less time on boilerplate, more time on judgment.
  • Your work ships decisions. The models you build directly drive how communities are run and capital is deployed.
  • Craft is valued. Small diffs, clean models, and good tests are how we measure quality here — not heroics.