Senior ETL/Database Developer

Diné Development Corporation

About The Position

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.

Requirements

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.
Strong understanding of measure development.
Experience with SQL Server 2008-2016, SSIS, SSAS, SSRS, Multi-dimensional modeling, Tabular, PowerPivot, T-SQL.
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.
U.S. Citizenship.
Ability to obtain or already possess a DoD Secret clearance for this position.

Nice To Haves

Experience and exposure to MHS/DHA/MDR/M2/ICDB/COHORT/Essentris data sets (preferred).
Familiarity with container application platforms such as OpenShift (preferred).
Working in a fast-paced environment
Experience and exposure to MHS/DHA/MDR/M2/ICDB/COHORT/Essentris data sets is a plus

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.