Ab Initio Developer

Our client, a premier Federal Healthcare organization has an urgent need for an Lead Ab Initio Developer to provide hands-on work designing and implementing data integration solutions for data warehouse and business intelligence systems. The Lead Data Engineer is 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.
Responsibilities include:

- 20% 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.
- 20% 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.
- 15% 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.
- 15% 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.
- 15% 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.
- 10% Interprets data, analyzes results using statistical techniques, and provides ongoing reports. Executes quantitative analyses that translate data into actionable insights. Provides analytical and data-driven decision-making support for key projects. Designs, manages, and conducts quality control procedures for data sets using data from multiple systems.
- 5% Improves data delivery engineering job knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

This position is currently a hybrid position (1-2 days per month onsite in Reston VA). This position is a contract to permanent opportunity with our client. We are seeking candidates that reside in the Maryland, Wash DC, Virginia or West Virginia states.

Required Skills

- BS Degree Required (In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.)
- 8 years Experience in data engineering and cross functional team to implement scalable and fine tuned ETL/ELT solutions for optimal performance. Experience developing and updating ETL/ELT scripts. Hands-on experience with application development, relational database layout, development, data modeling.
- At least one (1) year as a LEAD
- Must have AWS Experience (services in Data is preferred, such as Kafka, Redshift, Glue, etc..)
- Must have 6+ years of ETL Design and Development experience using Ab Initio. Continous flows for real time processing is required.
- 2+ years of Data Integration project experience on Cloudera Platform
- Working knowledge of HDFS, Hive, Impala and other related Hadoop technologies
- Sound understanding of SQL and ability to write well performing SQL queries

Preferred Skills:
- Ab Initio CDC (Change Data Capture) in a Data Integration/ETL project
- MongoDB Experience
- Python Experience
- Healthcare Insurance Industry Experience

Apply Now

Return to Search Results

Have a Question?





Anticipated Start Date

Monday, July 1, 2024

Job Type


Anticipated Duration

12 month T2P

Date Posted

Monday, June 10, 2024

Know someone who would be a good fit? We pay for referrals!

Share this job:

Call 800-ELITE-50
Reference #11414

Elite Technical Services, Inc. participates in the E-Verify program to confirm the employment eligibility of all persons hired. This means that we will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization. Elite Technical Services, Inc. will not use E-Verify to pre-screen job applicants.

Elite Technical Services, Inc. is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.