Solution Design Lead, Consultant

Blue Shield Of California

$100K — $150K *


More than 4w ago


11 - 15 years of experience

bookmark empty
report an issue with job

Job Description

Your Role

The Data Solution team is responsible for technical design and end-to-end delivery of complex data-driven solutions and data products for the enterprise. The Solution Design Lead will report to the Sr Manager, Data Solutions . In this role you will be partnering with Enterprise Architects, Portfolio, Analytics and Data engineering teams for designing technical solutions and building data products to meet enterprise data needs. You will be responsible for driving the data product by designing and implementing cloud data lakes, data warehouse and data mart solutions. If you have a passion for innovation with a data driven mindset and can-do attitude, we are looking for you.

Your Work

In this role, you will:

Provide technical expertise and leadership in designing and implementing data-related products and solutions within the organization

Lead the review and design for new data products, maintain product documentation including technical design specifications and release notes

Work closely with data engineers and data analyst teams, utilizing agile methodologies to plan and prioritize product backlog.

Work collaboratively to drive adoption and enforcement of technical standards, design principles, best practices, guidelines ensuring compliance and integrity of data product

Partner with Portfolios to enable, architect, implement and define the technical requirements, principles and models that guide data solution decisions for on-prem, cloud and hybrid ecosystem

Design end to end robust, scalable, real time data pipelines and data platform architecture that will support the analytical and reporting needs of the entire organization.

Build strong relationships and drive alignment on difficult topics. Effectively work across team boundaries to implement data architecture and data management best practices

Provide comprehensive analytical thinking to ensure time to market, cost impact and value are properly understood, estimated, and controlled across people, process, and technology.

Monitor and analyze the performance of data product, identify areas of improvement or optimization to enhance the data product and its features

Collaborate with stakeholders to gather their data-related needs, translate them into technical stories, prioritize features and enhancements, create product roadmaps considering business objectives


Your Knowledge and Experience

Requires a bachelor's degree or equivalent experience

Requires at least 10 years of prior relevant experience

Strong understanding of data management practices, data modelling (data vault 2.0), master data management, data integration, data architecture, data virtualization, data warehousing, data privacy and security.

Hands on experience with SQL, Python, Informatica PowerCenter/IICS, Collibra, Reltio Master Data Management, DBT Cloud, DBT core, Denodo, Synapse and Golden Gate replication

Prior experience in data product management is highly desirable. This includes skills with creating roadmaps, converting business requirements to technical stories, feature prioritization and working collaboratively across cross-functional teams.

Proficiency in SQL and Python is a must. Strong background with ETL, ETL data pipeline development is required.

Excellent Communication skills for engaging with stakeholders, facilitating discussions, and conveying complex technical concepts. Ability to lead and influence stakeholders while maintaining data quality standards and delivering a high-quality data product is desired

Experience in designing solutions for large data warehouses with a good understanding of cluster and parallel architecture. Expert in one or more of NoSQL and database appliances and platforms (Snowflake, Synapse, Databricks)

Azure or Snowflake Cloud Certification is a plus

Adept in agile methodologies, such as Scrum or Kanban, is required for managing product backlog, sprint planning and facilitating agile development.


At Blue Shield of California we are parents, leader, students, visionaries, heroes, and providers. Everyday we come together striving to fulfill our mission, to ensure all Californians have access to high-quality health care at a sustainably affordable price. For more than 80 years, Blue Shield of California has been dedicated to transforming health care by making it more accessible, cost-effective, and customer-centric. We are a not-for-profit, independent member of the Blue Cross Blue Shield Association with 6,800 employees, more than $20 billion in annual revenue and 4.3 million members. The company has contributed more than $500 million to Blue Shield of California Foundation since 2002 to have a positive impact on California communities. Blue Shield of California is headquartered in Oakland, California with 18 additional locations including Sacramento, Los Angeles, and San Diego. We're excited to share Blue Shield of California has received awards and recognition for LGBT diversity, quality improvement, most influential women in corporate America, Bay Area's top companies in volunteering & giving, and one of the world's most ethical companies. Here at Blue Shield of California, we're striving to make a positive change across our industry and the communities we live in , Join us!


Blue Shield of California’s mission is to ensure all Californians have access to high-quality health care at a sustainably affordable price. We are transforming health care in a way that truly serves our nonprofit mission by lowering costs, improving quality, and enhancing the member and physician experience.

To fulfill our mission, we must ensure a diverse, equitable, and inclusive environment where all employees can be their authentic selves and fully contribute to meet the needs of the multifaceted communities we serve. Our comprehensive approach to diversity, equity, and inclusion combines a focus on our people, processes, and systems with a deep commitment to promoting social justice and health equity through our products, business practices, and presence as a corporate citizen.

Blue Shield has received awards and recognition for being a certified Great Place to Work, best place to work for LGBTQ equality, leading disability employer, one of the best companies for women to advance, Bay Area’s top companies in volunteering & giving, and one of the world’s most ethical companies. Here at Blue Shield of California, we are striving to make a positive change across our industry and the communities we live in – join us!

Our Values:

Honest. We hold ourselves to the highest ethical and integrity standards. We build trust by doing what we say we're going to do and by acknowledging and correcting where we fall short.

Human. We strive to be our authentic selves, listening and communicating effectively, and showing empathy towards others by walking in their shoes.

Courageous. We stand up for what we believe in and are committed to the hard work necessary to achieve our ambitious goals.

Our Workplace Model:

Blue Shield of California is dedicated to making work-life balance a reality. Whether you prefer to work in an office or from home, we understand flexibility is more important than ever. That’s why Blue Shield is a hybrid company, offering you the opportunity to decide where you can do your best and most meaningful work.

Two ways of working: Hybrid (our default) and office

Hybrid – In a business unit approved office a few times per year to 3 days per week, on average

Office – In a business unit approved office 4+ days a week, on average. If the role you’re applying for is deemed an “Essential Role,” the company has determined that the role can only be performed in a Blue Shield office or in the field and would require your to meet the office worker classification.

Physical Requirements:

Office Environment - roles involving part to full time schedule in Office Environment. Due to the current public health emergency in California, Blue Shield employees are almost all working remotely. Based in our physical offices and work from home office/deskwork - Activity level: Sedentary, frequency most of work day.

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.

COVID-19 Vaccination Policy:

From the earliest days of the pandemic, Blue Shield of California has been unyielding in our commitment to putting the health and safety of our people, our members and our communities first. As a health care company, Blue Shield requires all employees to be up to date with COVID-19 vaccination prior to start date as a condition of employment. Blue Shield will consider requests for medical or religious accommodation to this vaccination requirement prior to your start date.

The definition of "up to date with your COVID-19 vaccine" is when you have received all doses in the primary series and one booster when eligible. If you are unable to be up to date with your COVID-19 vaccine by your start date, your start date will need to be postponed and you will have 30 days to remedy. If you cannot fulfill the requirement nor obtain accommodation within 30 days, your offer will be rescinded.

About Blue Shield Of California

Learn More 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.
stats icon
Total value of jobs:
stats icon
Total Jobs:
stats icon
Average Pay:
stats icon
% Masters:

More Jobs at Blue Shield Of California

$85K — $128K *

Yesterday• 11 - 15 years exp



$136K — $204K *

3 days ago• 11 - 15 years exp



$75K — $113K *

3 days ago• 11 - 15 years exp



$145K — $217K *

3 days ago• 11 - 15 years exp



$136K — $204K *

3 days ago• 11 - 15 years exp



Find similar IT Solutions Consultant jobs: