Capital Blue Cross · 18 hours ago
Data Engineer II
Capital Blue Cross is committed to going the extra mile for their team and community. They are seeking a Data Engineer II who will design and maintain scalable cloud-based data pipelines and models to support reliable data products, involving hands-on ELT development and collaboration with analysts and stakeholders.
ConsultingHealth CareHealth InsuranceProfessional Services
Responsibilities
Build, refactor, and maintain pipeline components of data products for a cloud environment
Own the ingestion, storage, cleansing, profiling, transformation, and presentation of data products
Analyze large and complex datasets for quality, accuracy, anomalies, and performance
Own pre-UAT testing for every change using the standard ABC framework
Consultatively interface with analysts and stakeholders on new data requests, enhancements, recommendations, quality, and awareness items
Assess project-specific integration restrictions/options and recommend load strategy, storage targets, data access layer model, and solution architecture
Participate in modeling star-schema data marts, denormalized performant layers, presentation layers, and Data Vault (or other immutable storage)
Organize source code with versioning framework
Create and maintain project-specific reference architecture diagrams and engineering-oriented documentation
Triage emergent data concerns and coordinate with stakeholders through resolution
Qualification
Required
Demonstrated ability to program advanced SQL and Python
Demonstrated ability to write and maintain scripts using Bash (Unix shell), PowerShell, or DOS batch scripting
Demonstrated ability to use ELT applications such as WhereScape or IDMC
Demonstrated ability to present at team-wide code reviews
Demonstrated ability to proactively analyze and resolve data issues in an agile, collaborative environment
Knowledge of data ingestion using unstructured, semi-structured, and structured data
Knowledge of data quality concepts and the ABC framework
Familiar with source code versioning tools such as Git
Comprehensive understanding of both Star Schema modeling and Normalized Relational modeling
Understanding of Data Vault 2.1 is a plus
Foundational knowledge of data preparation needs for Large Language Models
Familiar with metadata capture, row access policies, data masking policies, and data governance principles
3+ years in database technologies and data engineering experience
3+ years of modeling, building, and testing data products experience
2+ years in cloud data infrastructure with a SaaS delivery model
Bachelor's Degree in Computer Science, Software Engineering, Healthcare Informatics or related studies; or 7 years of relevant experience in lieu of degree
Preferred
Azure and Snowflake experience are a plus
Healthcare experience is preferred
Benefits
Medical, Dental & Vision coverage
Retirement Plan
Generous time off including Paid Time Off
Holidays
Volunteer time off
Incentive Plan
Tuition Reimbursement
Company
Capital Blue Cross
At Capital Blue Cross, we promise to go the extra mile for our team and our community.
H1B Sponsorship
Capital Blue Cross has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (13)
2023 (5)
2022 (9)
2021 (5)
2020 (5)
Funding
Current Stage
Late StageLeadership Team
Recent News
2025-10-02
2022-10-14
Company data provided by crunchbase