Sr. Data Engineer (Remote)

Resp & Qualifications

PURPOSE:
The Senior 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 developing solutions and helping transform the company's platforms deliver data-driven, meaningful insights and value to company.

ESSENTIAL FUNCTIONS:

• Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using multiple technologies.

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

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

• Creates data collection frameworks for structured and unstructured data.

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

• Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.

• Applies and implements best practices for data auditing, scalability, reliability and application performance.

SUPERVISORY RESPONSIBILITY:
Individual Contributor -   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:

• 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: Bachelor's Degree, 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: 5 years Experience with database design and developing modeling tools. 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, understanding, and development experience in Informatica IICS ETL tool. Informatica PowerCenter knowledge is a nice-to-have.

• Knowledge, understanding, and development experience in writing SQL queries and Snowflake experience preferred.  Oracle and/or SQL Server knowledge is a nice-to-have. 

• Experience developing in a DevOps environment utilizing CI/CD.

• Knowledge and understating of troubleshooting and resolving ETL code issues.

• Knowledge and understanding of cloud platforms (Azure preferred).

• Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python)

• Knowledge and understanding of data exchange formats

• Knowledge and understanding of database design and implementation concepts

• Ability to recognize, analyze, and solve a variety of problems

• Knowledge and understanding of data movement concepts

• Excellent communication skills both written and verbal

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

Department

Department: (ODS/ETL Members)

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.

Hire Range Disclaimer

Actual salary will be based on relevant job experience and work history.

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