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,