Loveland, OH

Analytics Consultant – (DBT, Microsoft Fabric, SQL)

Talener

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

If interested in learning more, please apply directly. Or reach out to Landers Clayton w/ Talener @ lclayton@talener.com

{“@context”:”http://schema.org”,”@type”:”JobPosting”,”baseSalary”:null,”datePosted”:”2026-10-09″,”validThrough”:”2027-10-09″,”description”:”<div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Title:</strong> Analytics Engineer</div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><br fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"></div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Client:</strong> Fast-growing, PE-backed ecommerce company that specializes in selling healthcare products</div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Location: Remote (100% EST Hours)</div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><br fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"></div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Engagement:</strong> 3 Month Contract to start</div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><br fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"></div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">About the Role</strong> 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.</div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Responsibilities</strong></div><ul data-path-to-node="11" fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit; margin-top: 0px; margin-bottom: 10px;"><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Re-architect core data transformations within dbt to establish consistent schema standards, proper key relationships, and unified business definitions</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Conduct full technical audits across current databases to flag, consolidate, or retire duplicate data sources and outdated views</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Build automated testing scripts and validation checks to verify row-level accuracy and metric alignment across all environments</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Update and repoint existing Power BI semantic layers, DAX calculations, and executive dashboards to connect seamlessly to the new architecture</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Map out data lineage, model dependencies, and clear documentation for all transformed datasets</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Collaborate across technical and non-technical teams to review core transformation logic and obtain final release approvals</div></li></ul><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Must-Have Skills</strong></div><ul data-path-to-node="13" fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit; margin-top: 0px; margin-bottom: 10px;"><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Deep SQL mastery + strong background crafting multi-table joins, complex CTEs, window functions, and executing query performance tuning</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Practical dbt expertise and &nbsp;comfortable building modular models, defining sources, writing custom macros, and setting up testing frameworks</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">End-to-end Power BI skills: &nbsp;Proven experience building semantic models, writing custom DAX measures, and administering workspaces in Power BI Service</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Solid history of managing data model refactoring or migration efforts, specifically auditing data parity between legacy and updated systems</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Self-directed problem solver comfortable tackling open-ended data cleanup efforts and producing thorough technical documentation</div></li></ul><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Pluses&nbsp;</strong></div></div><ul data-path-to-node="15" fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit; margin-top: 0px; margin-bottom: 10px;"><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Practical exposure to Microsoft Fabric architecture (Lakehouse/Warehouse)</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Background in the broader Azure ecosystem (Synapse, Azure SQL)</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Knowledge of structured data staging concepts (medallion/tiered architectures)</div></li><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">Basic Python automation skills/</div></li></ul><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: bold; font-family: inherit; font-size: inherit;">Compensation</strong></div><ul data-path-to-node="17" fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit; margin-top: 0px; margin-bottom: 10px;"><li fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">$60.00 – $68.00/hour W2</div></li></ul><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><br fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"></div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;">If interested in learning more, please apply directly. Or reach out to Landers Clayton w/ Talener @ <a fr-original-style="" href="mailto:lclayton@talener.com" style="box-sizing: border-box; user-select: auto; background: transparent; color: rgb(0, 112, 192); text-decoration: none; font-family: inherit; font-size: inherit; cursor: pointer;">lclayton@talener.com</a></div><div fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"><br fr-original-style="" style="box-sizing: border-box; font-family: inherit; font-size: inherit;"></div></div>”,”employmentType”:”CONTRACTOR”,”hiringOrganization”:{“@type”:”Organization”,”name”:”Talener”},”jobLocation”:{“@type”:”Place”,”address”:{“@type”:”PostalAddress”,”streetAddress”:null,”addressLocality”:”Loveland”,”addressRegion”:”OH”,”postalCode”:null,”addressCountry”:null}},”title”:”Analytics Consultant – (DBT, Microsoft Fabric, SQL)”,”url”:”https://talener.com/jobs/?cjobid=AD586232108&rpid=1735047&postid=atuJEX8gcZg”,”identifier”:{“@type”:”PropertyValue”,”name”:”Talener”,”value”:null}}

back to search jobs

We take a direct path to technology staffing success.

Contact Us