Lead Data Engineer (Remote)

Job description

**Resp & Qualifications**

**PURPOSE:**
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:**

+ 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.
+ 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.
+ 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.

**SUPERVISORY RESPONSIBILITY:**
Position does not have direct reports but is expected to assist in guiding and mentoring less experienced staff.

May lead a team of matrixed resources.

**QUALIFICATIONS:**

**Education Level:** Bachelor's Degree in Computer Science, Information Technology or Engineering or related field OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

**Experience:** 8 years Experience in leading 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.

**Knowledge, Skills and Abilities (KSAs)**

+ 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.
+ 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.
+ Able to effectively provide direction to and lead technical teams.
+ 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.
+ Expert level Knowledge, understanding and hands-on experience with Ab Initio in CDP and AWS (EC2, S3, Aurora, Redshift, Glue crawler, Glue, EKS).
+ Must have deep expertise in large-scale data processing frameworks, Ab Initio and Hadoop deployed on Cloudera (CDH/CDP) and AWS cloud environments.

Implement end-to-end data lineage, and establish data governance frameworks that support auditing, and enabling effective impact analysis.
+ The incumbent will also be part of level-3 on-call support on a rotational basis to support level-1 and level-2 personnel as needed during off-business hours and weekends.

**Salary Range:** $113,616 - $225,654

**Salary Range Disclaimer**

The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the work is being performed.

This compensation range is specific and considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, internal peer equity, and market and business consideration.

It is not typical for an individual to be hired at the top of the range, as compensation decisions depend on each case's facts and circumstances, including but not limited to experience, internal equity, and location.

In addition to your compensation, CareFirst offers a comprehensive benefits package, various incentive programs/plans, and 401k contribution programs/plans (all benefits/incentives are subject to eligibility requirements).

**Department**

Enrollment Business Area - Tec

**Equal Employment Opportunity**

CareFirst BlueCross BlueShield is an Equal Opportunity (EEO) employer.

It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

**Where To Apply**

Please visit our website to apply: www.carefirst.com/careers

**Federal Disc/Physical Demand**

Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs.

**PHYSICAL DEMANDS:**

The associate is primarily seated while performing the duties of the position.

Occasional walking or standing is required.

The hands are regularly used to write, type, key and handle or feel small controls and objects.

The associate must frequently talk and hear.

Weights up to 25 pounds are occasionally lifted.

**Sponsorship in US**

Must be eligible to work in the U.S. without Sponsorship

#LI-RC1

REQNUMBER: 21332

Required Skill Profession

Other General