Remote Data Engineer: Redshift, ETL & Databricks

InterSources Inc.; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

InterSources Inc. is seeking an experienced Data Engineer to develop, maintain, and optimize our Amazon Redshift data warehouse and ETL/ELT workflows for enterprise analytics and reporting.

The role covers production monitoring, performance tuning, and troubleshooting across SQL, ETL processes, and data pipelines, with an emphasis on reliability and timely data delivery. Familiarity with Tableau and Python scripting is required.

Qualifications

• Strong hands-on experience in Amazon Redshift data warehousing, SQL development, and production support.
• Experience with production job monitoring, scheduled automation, troubleshooting, and incident resolution.
• Demonstrated expertise in writing, debugging, tuning, and deploying complex SQL queries and data transformations.
• Experience supporting data warehouse workloads consumed by Tableau or similar BI platforms.
• Willingness to learn Databricks and participate in Redshift-to-Databricks modernization.

Responsibilities

• Monitor scheduled ETL jobs, Redshift workloads, data pipelines, and production data processing activities.
• Proactively identify and resolve job failures, performance bottlenecks, data discrepancies, and scheduling issues.
• Rapidly diagnose, debug, and resolve production issues involving SQL, ETL workflows, and scheduled automation.
• Perform root-cause analysis of recurring production incidents and implement permanent corrective solutions.
• Maintain operational documentation, incident resolution procedures, and production support runbooks.
• Collaborate with infrastructure, analytics, and other IT teams to resolve production issues and maintain data availability.

Skills

Amazon Redshift

SQL development

ETL/ELT pipelines

Production monitoring

Tableau

Python

S3

Databricks

Delta Lake

Data validation

Troubleshooting

Tools

Tableau

Python

Amazon Redshift

Databricks

Job description

InterSources Inc. is seeking an experienced Data Engineer to develop, maintain, and optimize our Amazon Redshift data warehouse and ETL/ELT workflows for enterprise analytics and reporting.

The role covers production monitoring, performance tuning, and troubleshooting across SQL, ETL processes, and data pipelines, with an emphasis on reliability and timely data delivery. Familiarity with Tableau and Python scripting is required.