Remote Analytics Engineer: SQL-Driven Data Modeling

Ensemblehp; United States; Remote; USD 84,000 - 126,000; Full time

Benefits offered by this job

Healthcare benefits

Tuition reimbursement

Professional development

Quarterly incentive programs

Job summary

Ensemblehp is seeking an Analytics Engineer to transform curated data into analytics-ready data models powering reports and dashboards. You will own the semantic layer and work with stakeholders to ensure trusted metrics.

The role emphasizes SQL-based transformations, dimensional modeling, and a strong business sense to empower analysts and leaders. The ideal candidate has 3+ years in analytics/BI, advanced SQL, dbt experience, and understandings of dimensional modeling and semantic layers.

Qualifications

• Bachelor’s degree or equivalent experience in CS, data analytics, statistics or related field.
• 3+ years in analytics engineering, analytics, BI, or related role.
• Advanced SQL expertise with maintainable transformations.
• Hands-on dbt experience.
• Understanding of dimensional modeling and semantic layer concepts.
• Experience supporting BI tools and dashboards.

Responsibilities

• Design and maintain analytics-ready data models (facts, dimensions, marts).
• Develop semantic/transform layer using SQL-based tooling.
• Define metrics and business logic for dashboards and reports.
• Collaborate with product, operations, finance and stakeholders.
• Ensure data quality and trusted analytics outputs.
• Provide guidance to analysts and BI developers.

Skills

Advanced SQL

dbt experience

Dimensional modeling

Semantic layer

BI tools

Healthcare data

Communication skills

Analytical thinking

Education

Bachelor’s degree in Computer Science or related

Tools

Data modeling tools

Job description

Ensemblehp is seeking an Analytics Engineer to transform curated data into analytics-ready data models powering reports and dashboards. You will own the semantic layer and work with stakeholders to ensure trusted metrics.

The role emphasizes SQL-based transformations, dimensional modeling, and a strong business sense to empower analysts and leaders. The ideal candidate has 3+ years in analytics/BI, advanced SQL, dbt experience, and understandings of dimensional modeling and semantic layers.