Blue Shield Of California

Data Engineer, Consultant

Blue Shield Of California$100K — $130K *
Lodi, CA 95240In-Person
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree or equivalent experience required.
  • Minimum of 7 years of data engineering experience needed.
  • Advanced SQL expertise, with a focus on automation and pipeline optimization.
  • Strong experience with cloud platforms, preferably Azure (ADLS, Synapse, Data Factory).
  • Extensive experience with modern data platforms such as Snowflake and Databricks.
  • Deep knowledge of data modeling, integration patterns, and data warehousing is essential.
  • Proven experience in implementing CI/CD pipelines and DataOps practices.

Responsibilities

  • Lead the design and implementation of complex data pipelines and products.
  • Translate solution designs into technical architecture and implementation plans.
  • Architect scalable and secure data solutions across enterprise platforms.
  • Apply advanced data modeling techniques for analytics and reporting.
  • Embed data quality and testing across data pipelines by design.
  • Drive operational excellence, including performance tuning and optimization.
  • Mentor and provide technical leadership to junior data engineers.

Benefits

  • Flexible workplace model encouraging in-person collaboration twice a week.
  • Provisions for reasonable accommodations for employees with medical conditions.
  • Commitment to engagement processes for remote work adjustments.
Full Job Description
Job Description

Your Role

The Data Services team is responsible for technical design and end-to-end delivery of complex data-driven solutions and data products for the enterprise. The Data Engineer,Consultant will report to the Sr Manager, Data Solutions / Manager. This role serves as a senior individual contributor and technical leader, responsible for driving end-to-end delivery of complex data engineering solutions across cloud data platforms. The DE-C partners closely with Solution Design Leads, Architects, Product Managers, and business stakeholders to translate solution designs and business requirements into scalable, secure, and production-ready data products.

Responsibilities

Your Work

In this role, you will:
  • Lead the design and implementation of complex, data pipelines and data products from development through production
  • Translate solution designs and business requirements into detailed technical architecture and implementation plans
  • Architect and build scalable, secure, and highly available data solutions across enterprise data platforms
  • Apply advanced data modeling techniques (Data Vault 2.0, dimensional, and domain-oriented models) to support analytics and reporting needs
  • Embed data quality, testing, security, and observability by design across data pipelines
  • Drive operational excellence, including incident analysis, stabilization, performance tuning, and deployment optimization
  • Identify and implement optimization opportunities related to performance, reliability, and cloud cost management
  • Influence and evolve data engineering standards, patterns, and frameworks used by delivery teams
  • Provide technical leadership and mentorship to Data Engineers and Senior Data Engineers through design reviews and code reviews
  • Work within an agile / DevSecOps pod model, collaborating closely with solution leads, data modelers, analysts, and business partners
  • Support integration of AI/ML-ready datasets by ensuring data is well-modeled, reliable, and governed
  • Communicate complex technical concepts clearly to both technical and non-technical stakeholders


Qualifications

Your Knowledge and Experience
  • Requires a bachelor's degree or equivalent experience.
  • Requires a minimum of 7 years of data engineering experience.
  • Advanced hands-on expertise in SQL, including automation and pipeline optimization
  • Strong experience with cloud platforms (Azure preferred) and services such as ADLS, Synapse, and Data Factory
  • Extensive experience with modern data platforms including Snowflake, Databricks, and orchestration tools such as Airflow or Tidal
  • Deep understanding of data modeling, integration patterns, data architecture, data quality, and data warehousing
  • Proven experience implementing CI/CD pipelines, Infrastructure as Code, and DataOps practices
  • Strong understanding of security, privacy, and compliance requirements in regulated environments
  • Experience working with largescale, distributed data platforms and parallel processing architecture
  • Excellent communication and stakeholder engagement skills
  • Proven ability to lead technically without formal people management responsibility
  • Preferred: Healthcare industry experience, including exposure to Epic or similar ecosystems


#LI-FB1

Our Workplace Model:

We believe in fostering a workplace environment that balances purposeful in-person collaboration with flexibility - providing clear expectations while respecting the diverse needs of our workforce. Our workplace model is designed around intentional in-person interaction, collaboration, connection, creativity and flexibility:
  • For most teams, this means coming into the office two days per week.
  • Employees living more than 50 miles from an office location, out of state employees, and employees in certain member-facing roles should work with their manager to determine in-office time based on business need.
  • For employees with medical conditions that may impact their ability to work in-office, we are committed to engaging in an interactive process and providing reasonable accommodations to ensure their work environment is conducive to their success and well-being.

The Company reserves the right to require more presence in the office based on business needs, and requirements are subject to change with periodic reviews.

Physical Requirements:

Office Environment - roles involving part to full time schedule in Office Environment. Based in our physical offices and work from home office/deskwork - Activity level: Sedentary, frequency most of work day.

Please click here for further physical requirement detail.

About Blue Shield Of California

Blue Shield of California is a not-for-profit health plan provider that has been providing Californians with access to high-quality healthcare for over 80 years. The company offers a range of health insurance products and services to individuals, families, and employers. Blue Shield of California is committed to improving the health and wellbeing of its members and the communities it serves. The company is also committed to sustainability and has implemented a number of initiatives to reduce its environmental impact.
Learn more about Blue Shield Of California
Size
7,000 employees
Industry
Founded
1981

Similar Jobs

More Jobs at Blue Shield Of California

More Information Technology Jobs

Find similar Data Engineer, Consultant jobs: