CareFirst BlueCross BlueShield is seeking a Senior Data Engineer responsible for orchestrating, deploying, maintaining, and scaling cloud or on-premises infrastructure focused on big data and platform data management. The role involves developing solutions to transform the company's platforms to deliver data-driven insights and value, along with responsibilities in data modeling, quality control, and data delivery engineering.
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