Remote Analytics Engineer - Data Modeling & BI Insights

Ensemble Health Partners; Oregon; Hybrid; USD 84,000 - 126,000; Full time

Job summary

Ensemble Health Partners seeks an Analytics Engineer to transform curated data into analytics-ready models powering dashboards and decision-making. The role sits at the intersection of data engineering, analytics, and business logic ownership, partnering with stakeholders to ensure trusted metrics and a well-defined semantic layer.

The ideal candidate excels in SQL-based transformations and dimensional modeling, with strong business acumen and a passion for enabling analysts and leaders with

Qualifications

• 3+ years in analytics engineering, BI, or related roles.
• Strong SQL and dbt experience with maintainable transformations.
• Understanding of dimensional modeling and semantic layers.

Responsibilities

• Design and maintain analytics-ready data models (facts, dimensions, data marts).
• Develop semantic layer transformations using SQL-based tooling.
• Define metrics and business logic for dashboards and reports.
• Collaborate with product, operations, and finance to translate requirements.
• Implement data quality checks and support BI dashboard development.
• Ensure analytics outputs are intuitive, discoverable, and trusted by leaders.

Skills

Advanced SQL

dbt

Dimensional modeling

Analytics engineering

BI tooling

Education

Bachelor's degree in CS/Data Analytics/Statistics

Tools

ETL tooling

Job description

Ensemble Health Partners seeks an Analytics Engineer to transform curated data into analytics-ready models powering dashboards and decision-making. The role sits at the intersection of data engineering, analytics, and business logic ownership, partnering with stakeholders to ensure trusted metrics and a well-defined semantic layer.

The ideal candidate excels in SQL-based transformations and dimensional modeling, with strong business acumen and a passion for enabling analysts and leaders with