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 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 #J-18808-Ljbffr