Job Title: Ab Initio Developer
Role Type: 12 + months contract – good chance of extensions
Location: Reston, VA –can work REMOTE EST (monthly onsite meetings) – candidates LOCAL to the DMV area preferred (or within 1-2 hour driving distance) EST will also be considered.
PURPOSE:
The Senior Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud (Relational and NoSQL, distributed and converged) with emphasis on reliability, automation and performance. This role will focus on developing solutions and helping transform the company's platforms deliver data-driven, meaningful insights and value to company.
Qualifications
Experience:
Should have 8-10 + years of overall experience
Minimum of 5 years’ experience with Ab Initio, developing and updating ETL/ELT scripts using Ab Initio preferably in Hadoop / Cloudera ecosystem
Strong hands-on experience with database design and developing modeling tools.
Experience with HIVE DB, Spark and AWS ecosystem is preferred.
Experience with AWS Platform - Glue, Aurora Postgres, RedShift, S3 preferred
Prior experience in HealthCare HIGHLY preferred
Hands-on experience with application development, relational database layout, development, data modeling.
Preferred Qualifications
Knowledge and understanding of Ab Initio CDC preferred, not required
Knowledge and understanding of HIVE DB, Spark, Cloudera and AWS ecosystems
Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python)
Knowledge and understanding of database design and implementation concepts.
Knowledge and understanding of data exchange formats.
Knowledge and understanding of data movement concepts.
Knowledge and understanding of CI/CD (preferably Jenkins)
Strong technical and analytical and problem solving skills to troubleshoot to solve a variety of problems.,
Requires strong organizational and communication skills, written and verbal, with the ability to handle multiple priorities.
Education Level: Bachelor's Degree
Education Details: Computer Science, Information Technology or Engineering or related field
In Lieu of Education
In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
ESSENTIAL FUNCTIONS:
20% Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using multiple technologies.
15% 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.
15% Develops data models by studying existing data warehouse architecture; evaluating alternative logical data models including planning and execution tables; applying metadata and modeling standards, guidelines, conventions, and procedures; planning data classes and sub-classes, indexes, directories, repositories, messages, sharing, replication, back-up, retention, and recovery.
15% Creates data collection frameworks for structured and unstructured data.
15% 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.
10% Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.
10% Applies and implements best practices for data auditing, scalability, reliability and application performance.
System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.