Senior Cloud ETL Engineer - 100% Remote Opportunity!

General Dynamics Information Technology (GDIT) provides healthcare information technology services and resources to support the Center for Medicare and Medicaid Services (CMS).

As a Senior Cloud ETL Engineer you will provide operation and maintenance support to the program with the design, development and maintenance of ETL jobs in the AWS enterprise data warehouse and Snowflake for a CMS Program.

In this role, a typical day will include:

• 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.
• 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.
• Mentor and provide guidance to junior team members.
• Identify process improvements and innovative ways to solve existing or new problems.
• Attend daily stand-up Scrum calls.

Required Qualifications:

• BA/BS in a Computer Science or related technical discipline or the equivalent combination of education, technical certifications or training, or work experience.
• 8+ years of IT experience with at least 8 years of SQL development experience developing on multiple relational database platforms including Teradata.
• 4+ years of Cloud ETL development experience using AWS Services / tools, Databricks, Snowflake, and/or similar technologies.
• 8+ years of direct related computer programming experience.
• Expertise with physical data modeling, partitioning and developing optimization/indexing strategies on the Teradata platform or similar DBMS.
• Experience with Informatica PowerExchange/ Informatica PowerConnect/ Informatica PowerCenter.
• Experience with UNIX scripting and utilities.
• In depth knowledge on Data Warehouse (DW) concepts for ETL Development
• Experience in Code migration and deployment using AWS resources in the cloud environment.
• Experience in working with Python programming.
• Experience in working with Snowflake environment and development.
• 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.
• Only US Citizenship and Green Card holder can be considered for this position.

Desired skills/experience

• Prior experience developing healthcare IT solutions strongly preferred.
• Experience in Github, or similar version control tools.
• Experience with Airflow DAG implementation.
• Prior experience using the Agile development framework, and CI/CD DevOps

The likely salary range for this position is $128,000 - $192,000, this is not, however, a guarantee of compensation or salary; rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

View information about benefits and our total rewards program.