Analytics Consultant – (DBT, Microsoft Fabric, SQL)

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

Title

Analytics Engineer

Client

Fast-growing, PE-backed ecommerce company that specializes in selling healthcare products

Location

Remote (100% EST Hours)

Engagement

3 Month Contract to start

About the Role

Our client is looking for a hands-on Analytics Engineer to help modernize their internal data stack by transitioning existing reporting structures into a clean dbt data framework. In this role, you will focus primarily on advanced SQL transformation, establishing consistent metric definitions, and updating executive Power BI datasets to run on top of the updated architecture. You will work closely with internal analytics partners and key business leads to audit legacy databases, build automated testing safeguards, and guarantee complete numerical accuracy before going live.

Responsibilities

• Re‑architect core data transformations within dbt to establish consistent schema standards, proper key relationships, and unified business definitions
• Conduct full technical audits across current databases to flag, consolidate, or retire duplicate data sources and outdated views
• Build automated testing scripts and validation checks to verify row-level accuracy and metric alignment across all environments
• Update and repoint existing Power BI semantic layers, DAX calculations, and executive dashboards to connect seamlessly to the new architecture
• Map out data lineage, model dependencies, and clear documentation for all transformed datasets
• Collaborate across technical and non‑technical teams to review core transformation logic and obtain final release approvals

Must‑Have Skills

• Deep SQL mastery + strong background crafting multi‑table joins, complex CTEs, window functions, and executing query performance tuning
• Practical dbt expertise and comfortable building modular models, defining sources, writing custom macros, and setting up testing frameworks
• End‑to‑end Power BI skills: Proven experience building semantic models, writing custom DAX measures, and administering workspaces in Power BI Service
• Solid history of managing data model refactoring or migration efforts, specifically auditing data parity between legacy and updated systems
• Self‑directed problem solver comfortable tackling open‑ended data cleanup efforts and producing thorough technical documentation

Pluses

• Practical exposure to Microsoft Fabric architecture (Lakehouse/Warehouse)
• Background in the broader Azure ecosystem (Synapse, Azure SQL)
• Knowledge of structured data staging concepts (medallion/tiered architectures)
• Basic Python automation skills/

Compensation

• $60.00 – $68.00/hour W2