Data Engineer, Consultant

Blue Shield of California; California; On-site; USD 123,000 - 185,000; Full time

Job summary

Stellarus is seeking a Data Engineer, Consultant to lead end-to-end delivery of complex data pipelines and data products across cloud platforms. You will translate solution designs and business requirements into scalable, secure data solutions and mentor engineers.

You will collaborate with solution leads, data modelers, analysts, and business partners in an agile DevSecOps environment, driving data quality, observability, and governance while enabling AI/ML-ready datasets.

Qualifications

• Bachelor's degree or equivalent required.
• 7+ years of data engineering experience.
• Advanced SQL and pipeline optimization.
• Cloud platforms focus with Azure (ADLS, Synapse, Data Factory).
• Experience with Snowflake, Databricks, and orchestration tools such as Airflow or Tidal.
• Strong data modeling, CI/CD, DataOps, security/compliance knowledge.
• Ability to lead technically without formal people management.

Responsibilities

• Lead design and implementation of complex data pipelines and data products from development through production.
• Translate designs and business requirements into architectural plans.
• Architect scalable, secure, highly available data solutions across enterprise platforms.
• Apply Data Vault 2.0, dimensional, and domain-oriented models for analytics.
• Embed data quality, testing, security, and observability by design.
• Drive operational excellence: incident analysis, tuning, and deployment optimization.
• Identify optimization opportunities for performance, reliability, and cloud cost management.
• Evolve data engineering standards and frameworks used by teams.
• Provide technical leadership and mentorship through reviews.
• Collaborate in an agile/DevSecOps pod with solution leads, modelers, analysts, and business partners.
• Support integration of AI/ML-ready datasets with governed, well-modeled data.

Skills

Strong communication

Leadership without management

Education

Bachelor's degree or equivalent

Tools

Azure

ADLS

Synapse

Data Factory

Snowflake

Databricks

Airflow

Tidal

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.

Job Description

Our leadership model is about developing great leaders at all levels and creating opportunities for our people to grow – personally, professionally, and financially. We are looking for leaders that are energized by creative and critical thinking, building and sustaining high-performing teams, getting results the right way, and fostering continuous learning.

Responsibilities

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

• 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

About Us

About Stellarus and the Ascendiun Family of Companies

Stellarus, launched in January 2025, is designed to scale innovative healthcare solutions that support customers in creating a health care experience deserving of their family, friends, and neighbors. Stellarus is part of a family of organizations that is overseen by a nonprofit corporate entity named Ascendiun. The Ascendiun Family of Companies also includes Blue Shield of California and its subsidiary, Blue Shield of California Promise Health Plan and Altais, a clinical services company. Stellarus’ vision is to empower its customers to create a healthcare experience that is worthy of their family, friends, and neighbors. Stellarus’ objective is to offer innovative, modern, scalable solutions that challenge the health care status quo. This very closely aligns with Blue Shield of California’s vision by using innovation to improve quality, affordability, and experience for members. To achieve our mission, we foster an environment where all employees can thrive and contribute fully to address the needs of the various communities we serve. We are committed to creating and maintaining a supportive workplace that upholds our values and advances our goals.

Our Values

At Stellarus, our core values of agility, trust, drive, courage and service shape our approach to developing innovative product offerings.

Our Workplace Model

• 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.

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.

Equal Employment Opportunity

External hires must pass a background check/drug screen. Qualified applicants with arrest records and/or conviction records will be considered for employment in a manner consistent with Federal, State and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or disability status and any other classification protected by Federal, State and local laws.

JOB INFO

Job Identification : 20261361

Job Category : Information Technology

Posting Date : 2026-11-06T21:26:04+00:00

Job Schedule : Full time

Locations :

• Oakland, CA, United States
• WA, United States
• RI, United States
• OH, United States
• MO, United States
• CA, United States
• Long Beach, CA, United States
• AZ, United States
• CO, United States
• FL, United States
• GA, United States
• MD, United States
• MN, United States
• NV, United States
• OR, United States
• El Dorado Hills, CA, United States
• Lodi, CA, United States
• Rancho Cordova, CA, United States
• San Diego, CA, United States
• AL, United States
• IL, United States
• VA, United States
• WI, United States
• TX, United States
• NY, United States

Pay Range for California : $123090.00 to $184800.00

Pay Range for Bay Area : $138756.00 to $208320.00

Note : Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate experience, location (California, Bay Area, or outside California), and current employee salaries for similar roles.

Role can be filled by a candidate requiring sponsorship : No