Data Engineer, Consultant
Blue Shield of California6 days ago
Oakland, CA, USASenior
Responsibilities
- Lead the design and implementation of complex data pipelines and data products from development through production.
- Translate solution designs and business requirements into technical architectures and implementation plans.
- Architect and build scalable, secure, highly available data solutions across enterprise data platforms.
- Apply Data Vault 2.0, dimensional, and domain-oriented data modeling techniques.
- Embed data quality, testing, security, and observability into data pipelines.
- Drive incident analysis, stabilization, performance tuning, and deployment optimization.
- Identify opportunities to improve performance, reliability, and cloud cost management.
- Influence data engineering standards, patterns, and frameworks used by delivery teams.
- Provide technical leadership and mentorship to Data Engineers and Senior Data Engineers through design and code reviews.
- Support integration of AI/ML-ready datasets through reliable, well-modeled, and governed data.
- Communicate complex technical concepts to technical and non-technical stakeholders.
Requirements
- Bachelor’s degree or equivalent experience.
- Minimum of 7 years of data engineering experience.
- Advanced hands-on expertise in SQL, including automation and pipeline optimization.
- Strong experience with cloud platforms, preferably Azure, and services including ADLS, Synapse, and Data Factory.
- Extensive experience with Snowflake, Databricks, and orchestration tools such as Airflow or Tidal.
- Deep understanding of data modeling, integration patterns, data architecture, data quality, and data warehousing.
- Experience implementing CI/CD pipelines, Infrastructure as Code, and DataOps practices.
- Strong understanding of security, privacy, and compliance requirements in regulated environments.
- Experience with large-scale distributed data platforms and parallel processing architecture.
- Excellent communication and stakeholder engagement skills.
- Ability to provide technical leadership without formal people management responsibility.
- Healthcare industry experience, including exposure to Epic or similar ecosystems, is preferred.
About Blue Shield of California
Blue Shield of California is a nonprofit, tax-paying health plan that sells medical, dental, and vision insurance to individuals, employers, and Medicare/Medi-Cal beneficiaries across California. An independent member of the Blue Shield Association, it also administers government program plans. Founded in 1939 and headquartered in Oakland, the company serves nearly 6 million members statewide.