Data Engineer, Consultant

About the 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.

Responsibilities

• 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
• Collaborate 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
• Minimum of 7 years of data engineering experience
• Advanced hands-on expertise in SQL, including automation and pipeline optimization
• Extensive 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 large-scale, distributed data platforms and parallel processing architecture
• Excellent communication and stakeholder engagement skills
• Proven ability to lead technically without formal people management responsibility

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.