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 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 Nation–owned 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 recruiting@ddc-dine.com
