Senior ETL/Database Developer

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

Senior ETL/Database Developer

Location: Remote

Position Type: Full time

Req ID: JR100335

The Senior ETL/Database Developer will be responsible for designing, developing, and maintaining ETL processes to support our data warehousing and business intelligence efforts. The successful candidate will work closely with data analysts, database administrators, and business stakeholders to meet business and enterprise requirements using SQL and ETL tools. The Data Integrator/Developer will have experience with DHA data covering both inpatient and outpatient data, coupled with a strong understanding of measure development.

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.

Education

• A Bachelor's Degree in Engineering, Physics, Network Security, Computer Science, or a related field.
• Minimum 5 years of experience, covering systems requirements, operational requirements, test and evaluation, training, and more.

Experience

• Minimum: 5 years of experience including:
• Strong understanding of measure development.
• Experience with SQL Server 2008-2016, SSIS, SSAS, SSRS, Multi-dimensional modeling, Tabular, PowerPivot, T-SQL.
• Experience and exposure to MHS/DHA/MDR/M2/ICDB/COHORT/Essentris data sets (preferred).
• Familiarity with container application platforms such as OpenShift (preferred).
• Proficient in Microsoft Office Suite and technical aptitude with tools like Python, Zeppelin, Anaconda, Machine Learning, Data wrangling techniques, R.
• Strong critical thinking, troubleshooting skills, and organization & planning skills.
• Excellent interpersonal, verbal, and written communication skills.
• Proven ability to manage multiple tasks and deadlines in a fast-paced environment.
• Preferred Experience:
• Working in a fast-paced environment
• Experience and exposure to MHS/DHA/MDR/M2/ICDB/COHORT/Essentris data sets is a plus
• Work authorization/security clearance requirements
• Ability to obtain or already possess a DoD Secret clearance for this position requires U.S. Citizenship. No contractors or third parties please.

About Us

Din Development Corporation (DDC) is a Navajo Nationowned family of companies that provides government agencies and commercial organizations with high-quality IT, professional, environmental, and research and development services. DDC is dedicated to empowering the Navajo Nation and the communities we serve.

Benefits

• Eligible full-time employees receive a comprehensive benefits package, including medical, dental, vision, life and disability coverage, retirement savings with company match, and paid time off.
• Additional benefits include voluntary supplemental benefits, access to an employee assistance program, and educational assistance with tuition reimbursement.

Equal Opportunity & Compliance Statement

This contractor and subcontractor shall abide by the requirements of 41 CFR 60-1.4(a), 60-300.5(a), and 60-741.5(a). These regulations prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities, and prohibit discrimination against all individuals based on their race, color, religion, sex, sexual orientation, gender identity, national origin, or for inquiring about, discussing, or disclosing information about compensation, or any other basis prohibited by law.

We participate in E-Verify.

DDC is committed to providing equal employment opportunities to all applicants and employees. If you require a reasonable accommodation to participate in the application or interview process, please contact Recruiting for assistance [e-mail]

PI286744865