> Markdown version of [/jobs/ext/3995247-remote-data-engineer](https://www.wearedevelopers.com/jobs/ext/3995247-remote-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Remote Data Engineer - **Company:** Insight Global - **Location:** Washington, DC, United States - **Experience:** Experienced - **Salary:** $135,200.0 - $156,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Airflow, Amazon Web Services, Amazon S3, Data Analysis, Software as a Service, Cloud Computing, Code Review, Databases, Continuous Integration, Information Engineering, Extract Transform Load (ETL), Data Security, Data Sharing, Identity and Access Management, Performance Tuning, Systems Development Life Cycle, Query Optimization, Role-Based Access Control, Salesforce.Com, SQL Databases, File Transfer Protocol (FTP), Sql Optimization, Snowflake, Git, Marketo, Deployment Automation, Functional Programming, Restful APIs, Terraform, Data Pipelines, Databricks - **Published:** October 28, 2026 - **Apply:** https://dejobs.org/x/x/958DD13E3EFB4BC4AC3F6ECADE902CD7/job/ ## About the Role * Snowflake - Advanced SQL, data modeling, performance optimization, RBAC, stages, and data integration patterns. * dbt / dbt Cloud - Models, tests, macros, incremental models, sources, documentation, jobs, and deployment patterns. * Fivetran - Connector configuration, schema management, sync troubleshooting, monitoring, and ingestion architecture. * SQL - Complex joins, CTEs, window functions, reconciliation, and query optimization. * Git / CI/CD - Branching, pull requests, code reviews, and automated deployment workflows. * Apache Airflow / AWS MWAA for orchestration. * AWS services such as S3, IAM, Lambda, Secrets Manager, and FSx. * Salesforce, Marketo, and other SaaS integrations. * REST API and SFTP/file-based ingestion. * Snowflake Secure Data Sharing. * Snowpark / Snowpark Container Services (SPCS). * Databricks. * Terraform / Infrastructure as Code. * Data quality and observability frameworks. * Experience modernizing or migrating legacy ETL/integration platforms. * 5+ years of Data Engineering or related experience. * 2+ years of hands-on experience with Snowflake and dbt. * Production experience implementing and supporting Fivetran pipelines. * Experience operating within enterprise DEV * QA * PROD SDLC and change-management processes. * Experience designing reusable ingestion and transformation patterns. * Strong production troubleshooting and root-cause analysis skills. ## Description * Design, build, and support end-to-end data pipelines using Fivetran, dbt, and Snowflake. * Configure and manage Fivetran connectors across SaaS applications, databases, APIs, and file-based sources. * Develop and maintain dbt models, including staging, intermediate, mart, and publish layers. * Implement dbt testing, source freshness, incremental processing, documentation, and reusable macros. * Develop optimized Snowflake SQL and scalable analytical data models. * Support Snowflake objects, security/RBAC, stages, data sharing, and data-loading patterns. * Implement data quality, reconciliation, monitoring, and operational alerting. * Troubleshoot production pipelines and perform root-cause analysis across ingestion and transformation layers. * Participate in Git-based development, CI/CD, code reviews, and DEV/QA/PROD deployments. * Collaborate with application, infrastructure, security, analytics, and business teams to onboard new data sources.