Key Responsibilities:
Design, develop, and maintain scalable data transformation pipelines using dbt Core and dbt Cloud.
Build and maintain reusable dbt models, macros, tests, snapshots, seeds, and packages following established development standards.
Configure and manage dbt Cloud environments, jobs, schedules, deployments, and orchestration workflows.
Configure, manage, and troubleshoot Fivetran connectors for SaaS applications, databases, files, and other supported source systems.
Understand and manage Fivetran schema changes, historical syncs, incremental loads, connector configurations, and destination behavior.
Design and develop scalable data solutions within Snowflake, including databases, schemas, tables, views, secure views, and other required data objects.
Write advanced and optimized SQL for complex data transformations, data validation, reconciliation, and analytics requirements.
Build curated, analytics-ready datasets and data marts that can support BI tools, reporting, advanced analytics, and downstream applications.
Translate business requirements and source-system structures into scalable data models and transformation logic.
Perform source-to-target mapping, data profiling, reconciliation, and validation across source systems, Fivetran, Snowflake, and dbt transformation layers.
Apply strong dimensional modeling principles, including fact tables, dimension tables, star schemas, and appropriate data-grain definition.
Use Git-based development practices including branching, pull requests, code reviews, version control, and controlled deployments.
Implement and support CI/CD processes for dbt development and deployment across development, testing, and production environments.
Design and build Snowflake Bronze/Raw, Silver/Cleansed, Gold/Business-Ready, and Semantic layers following a medallion-style architecture, with dbt used for reusable and governed transformations.
Configure and manage Fivetran ingestion pipelines, including source connections, scheduling, initial load validation, monitoring, and troubleshooting.
Use Git, Azure DevOps, and CI/CD pipelines for source control, approvals, deployment automation, and release promotion across environments.
Apply Snowflake security practices including RBAC, object-level permissions, and dynamic data masking where required.
Develop, configure, test, and refine the Snowflake CoCo AI Agent, working with business stakeholders to validate semantic definitions, business metrics, governed questions, and AI-generated responses.
Troubleshoot production data issues across the end-to-end pipeline from source → Fivetran → Snowflake → dbt → consumption layer.
Collaborate with data architects, data engineers, BI developers, analysts, and business stakeholders to deliver reliable data solutions.
Participate in technical design discussions, code reviews, solution reviews, and implementation planning.
