Remote Data Engineer
Insight Global
Washington, DC, United States
6 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on dejobs.org
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Compensation
$135,200.0 - $156,000.0
Working hours
Regular working hours
Job source
Tech stack
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)
+20 more
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
Job 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.
Requirements
- 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on dejobs.org
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦