Remote Analytics Engineer - Data Models & Marts

Myriad360; Oregon; Hybrid; USD 35,000 - 50,000; Full time

Job summary

Myriad360 is seeking a data engineer who turns business questions into governed, reliable data products. You’ll build dbt models, define metrics, and collaborate with analysts to turn requirements into clear definitions and reusable assets.

You’ll own data quality, documentation, and release plans, ensuring changes are safe and traceable across Snowflake, BigQuery, or Redshift, with Git-based reviews and strong communication with business partners.

Qualifications

• Strong SQL and production data modeling experience.
• Hands-on dbt or equivalent transformation framework experience.
• Experience with cloud data warehouses (Snowflake/BigQuery/Redshift).
• Strong dimensional modeling and data mart design skills.
• Experience testing, documenting, and maintaining data models.
• Familiarity with Git and code-review practices.
• Ability to translate requirements into clear data definitions and metrics.
• Ability to explain data discrepancies and their causes.

Responsibilities

• Build and maintain dbt models and certified data marts for key business domains.
• Collaborate with analysts to translate requirements into clear data definitions, models, and measures.
• Establish consistent business logic for shared metrics and dimensions.
• Build and maintain data quality tests; investigate failures and trace issues to their source.
• Document model purpose, ownership, definitions, dependencies, and known limitations.
• Assess downstream effects before changing models, metrics, or source assumptions.
• Use Git and established review and deployment practices to release changes safely.
• Support datasets and semantic models used in reporting and applications.
• Improve existing models and workflows as business needs evolve.
• Communicate tradeoffs, dependencies, and risks to technical and business partners.

Skills

SQL

dbt

Dimensional Modeling

Data Quality

Data Governance

Git

Data Pipelines

Tools

Snowflake

BigQuery

Redshift

Job description

Myriad360 is seeking a data engineer who turns business questions into governed, reliable data products. You’ll build dbt models, define metrics, and collaborate with analysts to turn requirements into clear definitions and reusable assets.

You’ll own data quality, documentation, and release plans, ensuring changes are safe and traceable across Snowflake, BigQuery, or Redshift, with Git-based reviews and strong communication with business partners.