Senior Data Engineer (Remote)

CareFirst BlueCross BlueShield is seeking a Senior Data Engineer to orchestrate, deploy, maintain, and scale cloud or on-premises infrastructure for big data and platform data management. The role focuses on developing solutions that deliver data-driven insights and value to the company, involving responsibilities such as developing infrastructure systems, analyzing data, and creating data collection frameworks.

Responsibilities:

• 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

Requirements:

• 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
• 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 and understanding of at least one programming language (i.e., SQL, Informatica, 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
• 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
• Python
• Azure Data Factory
• CICD
• Microsoft Azure Cloud stack