Cloud ETL Engineer

General Dynamics Information Technology

1d•$102,000 - $138,000•Remote

About The Position

Seize your opportunity to make a personal impact as a Cloud ETL Engineer supporting Drug data Processing System (DDPS) Part D Processing for CMS. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. At GDIT, people are our differentiator. As a Cloud ETL Engineer you will help ensure today is safe and tomorrow is smarter. Our work depends on Cloud ETL Engineer joining our team to DDPS Part D processing for CMS, to support IRA legislation Mandated ETL development and testing for CMS Part D Medicare processing ETL programming. How a Cloud ETL Engineer will Make an Impact: Builds and codes applications and/or models using various computer programming languages. Designs, develops, deploys, and maintains advanced operating systems and operating system software Installs enhancements and performs updates to software of existing systems, including middleware and application programs that run on the system Performs troubleshooting of advanced problems and provides customer support for software systems and application issues Debugs advanced problems with system software. Provides recommendations for continuous improvement Performs maintenance tasks to keep systems running smoothly Writes and updates test procedures and programs May coach and provide guidance to less-experienced professionals May serve as a team or task lead What You’ll Need to Succeed: Education: BA/BS in a Computer Science or related technical discipline or the equivalent combination of education, technical certifications or training, or work experience.

Requirements

5+ years of direct related computer programming experience.
5+ years of IT experience with at least 4 years of SQL development experience developing on multiple relational database platforms like Snowflake.
2+ years of Cloud ETL development experience using AWS Services / tools, Databricks, Snowflake, and/or similar technologies.
4+ years of physical data modeling, partitioning, and developing optimization/indexing strategies on the Teradata platform or similar DBMS.
2+ years of experience with Snowflake and Snowflake ETL for loading data from AWS S3
2+ years of experience with UNIX scripting and utilities.
In depth knowledge on Data Warehouse (DW) concepts for ETL Development
2+ year of experience in Code migration and deployment using AWS resources in the cloud environment.
3+ years of experience in working with Python and Spark programming.
Candidate must be able to obtain and maintain a Public Trust clearance and must have lived in the United States at least three (3) out of the last five (5) years.
AWS Development using S3, EC2 Lambda functions
Extract Transform Load (ETL)
Python (Programming Language)
Apache Spark programming
Knowledge on Snowflake Data Warehouse with ETL
Knowledge on Databricks and notebook, coding and execution
GitHub Code configuration and Management

Nice To Haves

Prior experience developing healthcare IT solutions strongly preferred.
2+ years of experience in Github, or similar version control tools.
Prior experience using the Agile development framework, and CI/CD DevOps
Prior working experience with Medicare Part D Data with ETL development

Responsibilities

Builds and codes applications and/or models using various computer programming languages.
Designs, develops, deploys, and maintains advanced operating systems and operating system software
Installs enhancements and performs updates to software of existing systems, including middleware and application programs that run on the system
Performs troubleshooting of advanced problems and provides customer support for software systems and application issues
Debugs advanced problems with system software.
Provides recommendations for continuous improvement
Performs maintenance tasks to keep systems running smoothly
Writes and updates test procedures and programs
May coach and provide guidance to less-experienced professionals
May serve as a team or task lead
Attend daily stand-up scrum calls.
Collaborate in a "war-room" setting with business analysts, developers, testers, architect, scrum master, and product owner to assist in grooming, designing, coding, unit testing user stories related to the Program Increment and current iteration.
Exercise positive interpersonal communication skills and works independently and within an agile team during all phase of the software development lifecycle.
Design, develop and implement complex ETL processes of healthcare data to meet a wide range of business and system requirements.
Support the ETL operational processes including but not limited to: automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration.
Investigate and corrects software defects and analyzes and maintains data quality.
Mentor and provide guidance to junior team members.
Identify process improvements and innovative ways to solve existing or new problems.

Benefits

Full-flex work week to own your priorities at work and at home, with core work hours Monday – Friday 9:00 AM ET – 3:00 PM ET
401K with company match
Comprehensive health and wellness packages
Internal mobility team dedicated to helping you own your career
Professional growth opportunities including paid education and certifications
Cutting-edge technology you can learn from
Rest and recharge with paid vacation and holidays
Challenging work that makes a real impact on the world around you
Remote work

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume