Seeking a Ab Initio Developer with strong AWS Cloud experience! This long term contract position is mostly remote, however, monthly visits (1-2x) to our clients Reston VA office is mandatory.

The selected candidate will be responsible for orchestrating, deploying, maintaining and scaling cloud OR on-premise infrastructure targeting big data and platform data management (Relational and NoSQL, distributed and converged) with emphasis on reliability, automation and performance. This role will focus on leading the development of solutions and helping transform the company's platforms deliver data-driven, meaningful insights and value to company.

ESSENTIAL FUNCTIONS:
- Lead the team to design, configure, implement, monitor, and manage all aspects of Data Integration Framework. Defines and develop the Data Integration best practices for the data management environment of optimal performance and reliability.
- Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using Hadoop or equivalent MapReduce platform.
- Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise. Understands Dimensional Modeling, De-normalized Data Structures, OLAP, and Data Warehousing concepts.
- Oversees the delivery of engineering data initiatives and projects. Supports long term data initiatives as well as Ad-Hoc analysis and ELT/ETL activities. Creates data collection frameworks for structured and unstructured data. Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.
- Enforces the implementation of best practices for data auditing, scalability, reliability and application performance. Develop and apply data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.

Required Skills

- BS Degree is highly preferred
- 10 years experience leading database design and ETL development, within Ab Initio specifically. Experience in leading data engineering and cross functional teams to implement scalable and fine tuned ETL/ELT solutions (batch and streaming) for optimal performance. Experience developing and updating ETL/ELT scripts.
- SME level, hands-on experience with Ab Initio ETL development is critically important
- Hands on experience with AWS Cloud - Athena and Glue is required, strong foundation in other services recommended: EC2, S3, Redshift, Sagemaker etc-
-Strong SQL Querying for complex projects is required
- Healthcare payor industry experience is a big plus
-GenAI / Machine Learning is a big plus