Senior ETL/Database Developer

DDC SPINSYS LLC; Scottsdale (AZ); On-site; USD 100,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Retirement savings with company match

Paid time off

Tuition reimbursement

Job summary

Diné Development Corporation (DDC) is seeking a Senior ETL/Database Developer to design, develop, and maintain ETL processes supporting our data warehouse and BI efforts. Work with analysts, DBAs, and stakeholders to meet enterprise requirements using SQL and enterprise ETL tools.

The role focuses on DHA and Cerner data across inpatient and outpatient settings, leveraging cloud platforms (AWS/Azure). Strong experience with SQL Server, SSIS, SSAS, SSRS, and data modeling is required on a

Qualifications

• Bachelor’s degree or higher in Engineering, Physics, Computer Science or related field.
• Minimum 5 years of experience in ETL, data warehousing, and BI data integration.
• Strong understanding of measure development.
• Experience with SQL Server 2008-2016, SSIS, SSAS, SSRS, multidimensional modeling, Tabular, PowerPivot, and T-SQL.
• Familiarity with healthcare data sets (MHS/DHA/MDR/M2/ICDB/COHORT/Essentris) and container platforms such as OpenShift (preferred).
• Proficiency in Python, Zeppelin, Anaconda, R and data wrangling techniques.
• Excellent communication and project management skills.

Responsibilities

• Design, develop, deploy, and maintain ETL and data integration pipelines.
• Validate data post-migration and optimize ETL processes for production.
• Work with AWS/Azure cloud data platforms (RedShift, SQL Server, MySQL, PostgreSQL).
• Collaborate with data analysts, DBAs, and stakeholders to meet business requirements.
• Develop and document data warehouse/data mart concepts and data models.

Skills

SQL

SSIS

SSAS

SSRS

T-SQL

Problem solving

Education

Bachelor’s degree in Engineering

Tools

Talend

Informatica

OpenShift

AWS

Azure

RedShift

SQL Server

MySQL

PostgreSQL

Job description

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 environmentExperience and exposure to MHS/DHA/MDR/M2/ICDB/COHORT/Essentris data sets is a plusWork authorization/security clearance requirementsAbility to obtain or already possess a DoD Secret clearance for this position requires U.S. Citizenship. No contractors or third parties please.About UsDiné 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.BenefitsEligible 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 StatementThis 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]