Remote Senior ETL & Data Warehouse Engineer

Dine Development Corporation; Arizona; Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Life and disability coverage

Retirement with company match

Paid time off

Voluntary benefits

Tuition reimbursement

Job summary

Din Development Corporation is seeking a Senior ETL/Database Developer to design, develop, and maintain ETL processes supporting data warehousing and BI efforts. You will collaborate with data analysts, DBAs, and business stakeholders across AWS/Azure environments, focusing on DHA data.

The role requires strong SQL and ETL tooling experience (Talend, Informatica, SSIS), knowledge of RedShift, SQL Server, MySQL, and data modeling to deliver reliable data pipelines and performance tuning.

Qualifications

• A Bachelor's Degree in Engineering, Physics, Network Security, Computer Science, or a related field.
• Minimum 5 years of experience covering requirements, operational requirements, test and evaluation, training, and more.
• Experience with DHA data and healthcare datasets (inpatient/outpatient) is preferred.

Responsibilities

• Validate data post-migration. Design, development, deployment, and maintenance of system integrations between applications across public and private clouds (AWS, Azure, Application Integration and Enterprise web service APIs)
• Work directly with healthcare data, focusing on DHA and Cerner data covering both inpatient and outpatient data.
• Develop a strong understanding of databases running in the AWS cloud, specifically RedShift, SQL Server, and MySQL databases.
• Support data analysis and data mapping activities.
• Optimize existing ETL processes, data integration, and data preparation flows, moving them into production.
• Design and document ETL processes and performance tuning using Talend, Informatica, and SSIS (SQL Server Integration Services).
• Work with data science teams in refining and optimizing data science and machine learning models and algorithms.
• Develop stored procedures, triggers using Transact-SQL (T-SQL), PL/SQL, ANSI SQL, PostgreSQL.
• Support the maintenance and optimization of existing ETL processes leveraging enterprise ETL tools.
• Attend client meetings to capture requirements related to data migrations and transformation needs.
• Develop Data Warehouse / Data Mart / Data Modeling / Business Intelligence concepts.

Skills

ETL development

SQL

AWS RedShift

SSIS

Informatica

Talend

PostgreSQL

MySQL

Python

R

Data warehousing

Data mapping

Problem solving

Education

Bachelor’s Degree in Engineering

Bachelor’s Degree in Physics

Bachelor’s Degree in Computer Science

Related field degree

Tools

SSAS

PowerPivot

OpenShift

Zeppelin

Anaconda

Job description

Din Development Corporation is seeking a Senior ETL/Database Developer to design, develop, and maintain ETL processes supporting data warehousing and BI efforts. You will collaborate with data analysts, DBAs, and business stakeholders across AWS/Azure environments, focusing on DHA data.

The role requires strong SQL and ETL tooling experience (Talend, Informatica, SSIS), knowledge of RedShift, SQL Server, MySQL, and data modeling to deliver reliable data pipelines and performance tuning.