Lead Ab Initio Developer
Description:
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.
Essential functions:
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.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
The requirements listed below are representative of the knowledge, skill, and/or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education level:
Master's Degree
Education details:
Information Technology or Computer Science or Business Analytics
Experience:
10 years Experience leading database design and ETL development. 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. Hands-on experience with Ab Initio ETL development in Hadoop and AWS ecosystem, relational database layout, development, data modeling.
In lieu of education
In lieu of a Master's degree, an additional 6 years of relevant work experience is required in addition to the required work experience.
Preferred qualifications
Knowledge, Skills and Abilities (KSAs)
Expert in at least one programming language (i.e., SQL, NoSQL, Python)., Expert
Knowledge of multiple database technologies - structured and un-structured., Expert
Ability to quick learn new technology and take direction., Expert
Strong customer service orientation., Expert
Provide direction to and lead technical teams., Expert
Provide direction and lead teams on Big Data and AWS technologies., Expert
Requires strong organizational with the ability to handle multiple priorities., Expert
Excellent communication skills both written and verbal., Expert
The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes them ineligible to perform work directly or indirectly on Client programs. Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time. Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.
Licenses/certifications
AWS Certified Big Data - Specialty (Must Have)
Cloudera Certified Developer for Apache Hadoop (CCDH) (Must Have)
OCP Java SE 6 Programmer Certification (Good to have)
Additional skills:
7+ years hands on experience as a Big Data Engineer in Hadoop and AWS ecosystem in Healthcare industry; preferably BCBS.
Hands on experience with developing application for batch data loads and data streaming using technologies using Cloudera/Hadoop and/or AWS technologies in Healthcare industry.
Description:
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.
Essential functions:
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.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
The requirements listed below are representative of the knowledge, skill, and/or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education level:
Master's Degree
Education details:
Information Technology or Computer Science or Business Analytics
Experience:
10 years Experience leading database design and ETL development. 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. Hands-on experience with Ab Initio ETL development in Hadoop and AWS ecosystem, relational database layout, development, data modeling.
In lieu of education
In lieu of a Master's degree, an additional 6 years of relevant work experience is required in addition to the required work experience.
Preferred qualifications
Knowledge, Skills and Abilities (KSAs)
Expert in at least one programming language (i.e., SQL, NoSQL, Python)., Expert
Knowledge of multiple database technologies - structured and un-structured., Expert
Ability to quick learn new technology and take direction., Expert
Strong customer service orientation., Expert
Provide direction to and lead technical teams., Expert
Provide direction and lead teams on Big Data and AWS technologies., Expert
Requires strong organizational with the ability to handle multiple priorities., Expert
Excellent communication skills both written and verbal., Expert
The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes them ineligible to perform work directly or indirectly on Client programs. Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time. Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.
Licenses/certifications
AWS Certified Big Data - Specialty (Must Have)
Cloudera Certified Developer for Apache Hadoop (CCDH) (Must Have)
OCP Java SE 6 Programmer Certification (Good to have)
Additional skills:
7+ years hands on experience as a Big Data Engineer in Hadoop and AWS ecosystem in Healthcare industry; preferably BCBS.
Hands on experience with developing application for batch data loads and data streaming using technologies using Cloudera/Hadoop and/or AWS technologies in Healthcare industry.