Lead Data Engineer

Senior Data Engineer Location: Remote Employment: 6-Month Contract Experience: 4+ Years Job Summary: We are looking for a Senior Data Engineer with strong hands-on experience in dbt Core, dbt Cloud, Fivetran, and Snowflake . The candidate will design, develop, deploy, and support scalable cloud-based ELT pipelines and analytics-ready data solutions. Key Responsibilities: Build and maintain dbt models, macros, tests, snapshots, seeds, packages, and documentation . Configure and manage dbt Cloud jobs, schedules, deployments, and environments . Configure and troubleshoot Fivetran connectors, incremental loads, schema changes, and syncs . Develop scalable Snowflake databases, schemas, tables, views, and data models . Write advanced SQL for transformation, validation, reconciliation, and performance optimization. Design Bronze/Raw, Silver/Cleansed, Gold/Business-Ready, and Semantic layers . Apply dimensional modeling, fact/dimension tables, star schemas, and proper data grain . Implement Git, Azure DevOps, CI/CD, code reviews, and multi-environment deployments . Apply Snowflake security including RBAC and dynamic data masking . Support and refine Snowflake CoCo AI Agent semantic definitions and business metrics. Troubleshoot end-to-end pipelines across Source Fivetran Snowflake dbt BI/Consumption . Collaborate with data architects, engineers, BI teams, analysts, and business stakeholders. Required Skills: 4+ years of Data Engineering / Analytics Engineering experience. Strong dbt Core & dbt Cloud experience. Strong Fivetran experience. Strong Snowflake experience. Advanced SQL and data transformation skills. Strong knowledge of ELT, data warehousing, dimensional modeling, and cloud data platforms . Experience with Git, Azure DevOps, CI/CD, automated testing, and data quality . Preferred: dbt/Snowflake certification. Python experience. Salesforce, NetSuite, SAP, or Workday integration experience. Data governance, lineage, metadata, and observability experience. Consulting/client-facing experience.

For applications and inquiries,