Data Analytics Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

IT Full Time Ama Waterways, LLC, Calabasas, CA, US

30+ days ago Requisition

Salary Range: $90,000.00 To $ Annually

At Ama Waterways, we believe meaningful careers begin with purpose, passion and a shared commitment to delivering unforgettable experiences. For those who value curiosity, connection and personal enrichment, Ama Waterways offers the opportunity to help craft meaningful river journeys that invite travelers to follow their own current. Built on a foundation of heartfelt hospitality, we treat our guests—and each other—with genuine care, warmth and respect.

Ama Waterways fosters a collaborative environment both onboard our ships and across our global network of offices, where team members grow together, support one another and take pride in upholding the high standards and thoughtful service our company is known for.

We invite talented, motivated professionals to explore our career opportunities and begin their journey with Ama Waterways today.

Ama Waterways is hiring a Data Analytics Engineer to own the analytics layer of our modern data platform. You will design governed data marts, build the semantic layer that powers our scorecards, and partner directly with Finance, Marketing, Revenue Management, Operations, and Reservations to turn ambiguous business questions into trusted models and dashboards. You will work on top of a Snowflake-native warehouse that is actively being built out, alongside a Senior Data Engineer who owns the ingestion plumbing.

You will apply software engineering practices to analytics: version control, dbt tests, CI/CD, and clear documentation. You will also be an AI-native practitioner. Our daily environment is Claude Code, Snowflake Cortex, and dbt Cloud, and we expect you to use them fluently, not curiously.

• Governed semantic models in dbt for our top business KPIs: bookings, occupancy, revenue, cancellations, retention, marketing performance, and operations metrics.
• Marts and reporting views on top of our medallion warehouse (Bronze, Silver, Gold, Reporting), with strict typing and clear grain documentation.
• Tableau and Power BI assets that share a single source of truth in the warehouse. No off-platform calculations.
• Cortex Analyst semantic YAML for natural-language data exploration by our internal users.
• Data quality tests on every model you author, with clear ownership of the freshness and accuracy SLAs.
• Companion views for the AMA Pulse scorecard (currently 72 KPIs across 894,000 rows of historical sailings).
• BI assets that consolidate analytical work currently spread across the AMA Pulse Streamlit app, Tableau Cloud, and ad-hoc SQL.

Modeling and SQL

• Build dbt models in our medallion layout. Use staging, intermediate, and mart models with explicit grain. Use SCD2 snapshots where business questions span time.
• Write performant SQL in Snowflake. Read query profiles when something is slow. Use clustering and warehouse sizing deliberately.
• Apply consistent naming conventions and audit columns across every mart.

Semantic layer and metric governance

• Define metrics in the dbt Semantic Layer with explicit dimensions, time grains, and ownership.
• Author Cortex Analyst semantic YAML for the marts that internal teams query through natural language.
• Maintain a single canonical definition for every business KPI. No duplicate metric logic across Tableau, Power BI, and Streamlit.

BI development and governance

• Build, optimize, and govern dashboards in Tableau Cloud and Power BI.
• Implement row-level and object-level security, usage monitoring, and deployment workflows.
• Au…