ETL Developer

Job Summary::

The 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/Cerner data covering both inpatient and outpatient data, coupled with strong understanding of measure development. 

• 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.
• Validate data post-migration.
• 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: 

Must be a US citizen able to obtain a Secret clearance.  

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 (includes Minimum)

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

Diné Development Corporation (DDC) is a Navajo Nation owned family of companies that delivers IT, professional, and environmental solutions to advance the missions of federal, state, and tribal government agencies. As thought leaders and innovators, our team of specialists build client-centric solutions that solve critical challenges faced by defense, civilian, and healthcare organizations. Employing a mission-focused approach, we deliver value that not only enhances current operations, but also drives future change. Closely aligned with this approach is our commitment to advancing the Navajo Nation and its People. Through economic development and community empowerment, we elevate the Navajo Nation to provide lasting impact and sustainable growth for future generations. DDC’s ability to unite legacy-inspired technologies, industry best practices, and proven methodologies has contributed to our success for twenty years.

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.

#LI-DNP