Diné Development Corporation · 12 hours ago
ETL Developer
Diné Development Corporation is seeking an ETL Developer to design, develop, and maintain ETL processes for data warehousing and business intelligence. The role involves working with data analysts and stakeholders to fulfill enterprise requirements while optimizing existing ETL processes and supporting data analysis activities.
Executive Office
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
Other duties as assigned
Qualification
Required
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
Must be a US citizen able to obtain a Secret clearance
Strong understanding of measure development
Experience with SQL Server 2008-2016, SSIS, SSAS, SSRS, Multi-dimensional modeling, Tabular, PowerPivot, T-SQL
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 and exposure to MHS/DHA/MDR/M2/ICDB/COHORT/Essentris data sets
Familiarity with container application platforms such as OpenShift
Proficient in Microsoft Office Suite and technical aptitude with tools like Python, Zeppelin, Anaconda, Machine Learning, Data wrangling techniques, R
Company
Diné Development Corporation
Diné Development Corporation (DDC) is a family of companies that delivers IT, engineering, and professional services solutions that solve the dynamic challenges of federal agencies.