Logo of Huzzle

Data Modeler, Senior

  • Job
    Senior Level
  • Data
  • $99K - $148.5K
  • Oakland, +1

AI generated summary

  • You need a bachelor’s degree, 5 years of data modeling experience, knowledge of ERWIN/ER/Studio, Data Vault 2.0, SDLC, strong communication, decision-making, planning, and problem-solving skills, and the ability to work in a team-based environment.
  • You will lead data modeling sessions, develop standards, collaborate with teams, create models, update data dictionaries, and generate DDL for data engineering at Blue Shield of California.


  • ​​Requires a bachelor's degree or equivalent experience
  • ​Requires at least 5 years of prior relevant experience​
  • Requires at least 5 years of experience responsible for the analysis and design of data models at the conceptual, logical, and physical levels and for the development and maintenance of existing enterprise models
  • Demonstrated ability to understand, produce, and extend large and complex data models for operational and dimensional reporting data stores
  • Experience coordinating information requirements of multiple departments, including assessment of usefulness, reliability, and cleanliness of data from several sources
  • Ability to effectively present complex technical information to non-technical audiences and to senior decision-makers
  • Experience with ERWIN or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred
  • Experience with Data Vault 2.0 is preferred
  • Strong SDLC knowledge, with excellent process and Strong SDLC knowledge, with excellent process and application system documentation skills
  • Solid understanding of Data Management and Metadata Management processes and principles, with the ability to effectively communicate and sell those ideas to others
  • Demonstrated success working in a team-based environment
  • Information systems project management or leadership experience preferred
  • Requires strong decision-making, organizational, planning, and problem-solving skills
  • Excellent analytical skills are required
  • Strong facilitation and negotiation skills are required
  • Strong communication skills are required; technical and business writing skills are required
  • Strong interpersonal skills, with competence in interfacing with business users required
  • Ability to summarize and present design alternatives
  • Ability to influence and sell soundness of design and deliverables


  • Demonstrate lead-level capabilities in conceptual analysis, problem-solving, and data analysis
  • Take ownership of initiatives or projects with the ability to lead and facilitate business requirements and data analysis and modeling sessions
  • Lead data model review sessions; Develop, adopt and mature the data modeling standards and guidelines aligning to industry best practices
  • Collaborate with subject matter experts, business analysts, data analysts, and other data modelers to create data modeling deliverables
  • Provide support in the use of enterprise data, including guidance in understanding and exploitation of the underlying data and business models, and identifying optimal data sourcing and mapping
  • Assist in developing and publishing data management standards, policies, and procedures, including the management and maintenance of related tools and environments
  • Create fully attributed and documented conceptual, logical and physical models
  • Create, validate, and update the data dictionary by coordinating with data governance team and business users. Capture business rules for logical and physical mapping in the models; Work closely with the data governance team to define data classification, PHI/sensitive information, and enterprise reference data in Collibra and modeling tool
  • Generate physical model DDL and SQL for views for data engineering implementation


What is the main focus of the Data and Analytics organization?

The Data and Analytics organization focuses enterprise-wide to partner with business stakeholders to apply the power of data & analytics to deliver new insights and data-driven solutions to accelerate business outcomes.

What team does the Data Modeler, Senior report to?

The Data Modeler, Senior will report to the Manager of Data Management.

What type of data models will the Data Modeler, Senior be responsible for designing and maintaining?

The Data Modeler, Senior will be responsible for designing, implementing, and maintaining Data Vault 2.0 and Dimensional models within the D&A organization.

What leadership qualities are valued for this role?

The organization values leaders who are energized by creative and critical thinking, building and sustaining high-performing teams, getting results the right way, and fostering continuous learning.

#WeNeverStop #WhoWeStandFor #BlueShieldCares #WhatWeStandFor #QuienesSomos #SiempreAdelante #ProudToBeBSCA

Founded Year

Mission & Purpose

Blue Shield of California strives to create a healthcare system worthy of its family and friends that is sustainably affordable. Blue Shield of California is a tax-paying, nonprofit, independent member of the Blue Shield Association with 4.7 million members, 7,800 employees, and $22.9 billion in annual revenue. Founded in 1939 in San Francisco and now headquartered in Oakland, Blue Shield of California and its affiliates provide health, dental, vision, Medicaid and Medicare healthcare service plans in California. Blue Shield of California complies with applicable state laws and federal civil rights laws, and does not discriminate on the basis of race, color, national origin, ancestry, religion, sex, marital status, gender, gender identity, sexual orientation, age, or disability.