Remote Analytics Engineer (dbt, SQL, Power BI)

Talener; Loveland (OH); Remote; USD 83,000 - 94,000; Full time

Job summary

Talener is seeking an Analytics Engineer to help modernize the data stack for a fast-growing ecommerce client. This 3‑month contract focuses on transforming reporting structures into a clean dbt framework, with emphasis on SQL transformations, consistent metrics, and updating executive Power BI datasets.

You will audit legacy databases, build automated tests, and ensure numerical accuracy before going live, collaborating with analytics partners and business leads.

Qualifications

• Deep SQL mastery with multi‑table joins, CTEs, window functions and performance tuning.
• Practical dbt expertise with modular models, sources, macros and testing frameworks.
• End‑to‑end Power BI skills: semantic models, custom DAX measures, Power BI Service administration.
• Experience refactoring data models and auditing parity between legacy and updated systems.
• Self‑directed problem solving with thorough technical documentation.

Responsibilities

• Re‑architect core data transformations in dbt to establish consistent schema standards and definitions.
• Audit current databases to flag, consolidate, or retire duplicate data sources and outdated views.
• Build automated testing scripts and validation checks for row‑level accuracy across environments.
• Update and repoint Power BI semantic layers, DAX calculations, and dashboards to the new architecture.
• Map out data lineage, model dependencies, and document transformed datasets.
• Collaborate with technical and non‑technical teams to review core transformation logic and obtain release approvals.

Skills

SQL mastery

dbt expertise

Power BI skills

Data modeling

Documentation

Tools

Power BI

dbt

DAX

Job description

Talener is seeking an Analytics Engineer to help modernize the data stack for a fast-growing ecommerce client. This 3‑month contract focuses on transforming reporting structures into a clean dbt framework, with emphasis on SQL transformations, consistent metrics, and updating executive Power BI datasets.

You will audit legacy databases, build automated tests, and ensure numerical accuracy before going live, collaborating with analytics partners and business leads.