Analytics Consultant - (DBT, Microsoft Fabric, SQL)

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 definitionsConduct full technical audits across current databases to flag, consolidate, or retire duplicate data sources and outdated viewsBuild automated testing scripts and validation checks to verify row-level accuracy and metric alignment across all environmentsUpdate and repoint existing Power BI semantic layers, DAX calculations, and executive dashboards to connect seamlessly to the new architectureMap out data lineage, model dependencies, and clear documentation for all transformed datasetsCollaborate 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 tuningPractical dbt expertise and comfortable building modular models, defining sources, writing custom macros, and setting up testing frameworksEnd-to-end Power BI skills: Proven experience building semantic models, writing custom DAX measures, and administering workspaces in Power BI ServiceSolid history of managing data model refactoring or migration efforts, specifically auditing data parity between legacy and updated systemsSelf-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