Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Modeller - Technical Lead

Lorven Technologies Inc

Job Title: Data Modeller - Technical Lead


Location: Newport Beach, CA


Hiring Type: FTE


Experience: 8-12 Years


Role Summary:


We are looking for a hands-on Data Modelling Technical Lead to own the target-state logical and physical data model for a Fortune 500 insurance and financial services enterprise's multi-wave, enterprise-scale data modernization program. You will design and govern Snowflake-native dimensional and relational models across 9+ certified data products - spanning Policy, Claims, Finance, Actuarial, and MDM domains - and establish the ACORD-based modeling standards that the full delivery team will build on. Working directly alongside the onshore Technical Architect, you will be the authoritative voice on schema quality, naming conventions, and Collibra-aligned lineage definitions throughout the 18-24 month engagement.


Must-Have Skills:

  • 8+ years in enterprise data modeling with 3+ years leading modeling on complex, multi-source data platform programs
  • Deep expertise in logical and physical data modeling - dimensional modeling (star/snowflake schemas), normalized models, and Snowflake-native wide-table patterns
  • Hands-on Snowflake experience - schema design, clustering strategies, materialization types, and query performance fundamentals
  • Strong command of dbt - translating logical model designs into modular dbt model structures, YAML schema definitions, and test coverage
  • Experience integrating data models with a metadata governance platform (Collibra preferred) - business glossary, attribute-level lineage, and data contract definition
  • Demonstrated ability to produce and maintain data dictionaries, ERDs, and source-to-target mapping documents across multi-domain enterprise programs
  • Experience in a regulated industry (insurance, healthcare, or financial services) with awareness of PII/PHI data handling and compliance requirements
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Data Modeller - Technical Lead in Newport Beach, CA vacancy
  • $254k

     ...expertise, technology, and business model of the 21st century’s most...  ...that turns thousands of data streams into a realtime, 3D command...  ...JOB We are seeking a senior technical leader to architect and drive...  ...the system architecture, and lead a team of RL engineers, manipulation... 
    Suggested
    Full time
    Work experience placement

    Slope

    Costa Mesa, CA
    2 days ago
  • $132.6k - $176.9k

     ...Senior Salesforce Technical Lead / Architect (Service Cloud, FSL) Auto Club Enterprises (ACE) is seeking a highly experienced Senior...  ...Salesforce solution architecture and technical design, defining data models, integrations, security, and performance strategies aligned... 
    Suggested
    Full time
    Local area

    AAA

    Costa Mesa, CA
    8 days ago
  • $130k - $140k

    Technical Product Lead Full Time Professional Costa Mesa, CA, US 15 days ago Requisition ID: 1046 Salary Range: $130,000.00 To $140,000.00 Annually...  .... Ability toanalyze and improve manufacturing process data. Excellentwritten and verbal communication skills(technical... 
    Suggested
    Full time
    Contract work

    Pyramid Laboratories Inc

    Costa Mesa, CA
    3 days ago
  • $80k - $90k

    A swimwear and activewear company in California is seeking a Senior Technical Designer to oversee the creation of leading swim and lifestyle apparel. You will manage prototypes, collaborate with various teams, and maintain standards in construction and fit. The ideal candidate... 
    Suggested

    Beach Riot LLC

    Newport Beach, CA
    2 days ago
  • $96.55k - $138.06k

     ...Join us and be part of the transformation that’s driving the future of automotive innovation. Website: Role Overview The Technical Delivery Lead II will oversee end‑to‑end delivery of complex software and telematics projects, providing leadership, governance, and... 
    Suggested
    Local area

    Hyundai Autoever America

    Costa Mesa, CA
    1 day ago
  • $96.55k - $138.06k

    A leading automotive IT service provider based in Costa Mesa is seeking a Technical Delivery Lead II to oversee end-to-end delivery of complex software projects. This role involves managing project plans, collaborating with global teams, and ensuring high-quality outcomes... 

    Hyundai Autoever America

    Costa Mesa, CA
    2 days ago
  •  ...Overview: Job Title: Workday Technical Lead Location: [Irvine,CA , San Antonio TX"] About the Role As a Workday Technical...  ...design and governance of end-to-end architectures across cloud, data, integration, and application domains. Drive... 

    Purple Drive

    Irvine, CA
    2 days ago
  • $84k - $140.5k

     ...your best. Together we win! THE OPPORTUNITY The AVP, HOA Technical Lead provides technical leadership for HOA operations, supporting system...  ..., skills, abilities of the applicant in alignment with market data and other factors. Banc of California is an equal... 
    Work at office
    Local area
    Immediate start
    Flexible hours

    Banc of California

    Santa Ana, CA
    2 days ago
  •  ...Description: - HIRING - FOR AWS DATA LAKE ARCHITECT Oversee end-to-end Architecture...  ...Provide architectural blueprints and technical leadership to the team Experience 8...  ...on a client's business processes. Lead a diverse group of project partners and... 
    Full time

    Avani Technology Solutions

    Irvine, CA
    23 days ago
  • $160k - $210k

     ...About DZYNE DZYNE Technologies is leading the future of autonomous defense. Based...  ...Join us. Position : Unmanned Aircraft Technical Lead Location : Irvine, CA Work Arrangemen...  ...stability and control modes, models, concepts, and coefficients Working... 
    Full time
    Work experience placement
    Work at office
    Local area
    Visa sponsorship
    Work visa

    DZYNE Technologies

    Irvine, CA
    1 day ago
  •  ...Job Title: Technical Lead - AutoSys Migration (On-Premises to AWS) Location: Irvine,...  ...WCC with Autosys schedulers and validate data consistency. • Manage EEM security...  ...AAI data feeds, jobs, and forecasting models. • Analyze critical paths, SLA... 

    VBeyond

    Irvine, CA
    4 days ago
  • $80k - $95k

     ...WHAT YOU'LL DO As a Technical Platform Lead at Viant, you will serve as the senior representative of Platform Operations, accountable for...  ...alignment, and accountability on initiatives. Leverage advanced data analysis to uncover trends, inform optimizations, and... 
    Local area

    Viant

    Irvine, CA
    3 days ago
  •  ...Position: Senior Appian Technical Lead Location: Irvine, CA (Hybrid 2-3 Days) Position Type: Contract Min Experience...  ...scalable Appian applications using Appian BPM suite SAIL Process Models Records Reports Sites etc Collaborate with business... 
    Contract work

    Futran Tech Solutions Pvt. Ltd.

    Irvine, CA
    23 hours ago
  •  ...Position: Salesforce Tech Lead (Sales Cloud Expertise) Location...  ...Serve as the Salesforce Technical Lead , driving the architecture...  ...middleware tools. Oversee data management processes including...  ...Salesforce security, sharing models, and automation tools (Flows,... 
    Contract work
    Remote work

    Purple Drive

    Costa Mesa, CA
    2 days ago
  • $204.73k - $370.53k

     ...-class training facility, and leading market tools, we help our people...  ...currently seeking a Director, Technical Lead Forward Deployed Engineer...  ...systems, with a focus on data, machine learning, and AI-native...  ...full-stack capabilities, and model strategy fluency Proven ability... 
    H1b
    Local area

    KPMG

    Irvine, CA
    3 days ago
  •  ...Architect Cum Technical Lead With AI/GenAI Exp Seeking an architect cum technical lead (hands-on) with 12+ years of experience in Java,...  ...and implementing AI/Gen AI based use cases using the leading AI models/services (e.g., Claude, gpt, GitHub Copilot, Microsoft Copilot... 
    3 days per week

    Futran Tech Solutions Pvt. Ltd.

    Irvine, CA
    3 days ago
  •  ...Sharepoint Technical Team Lead Information Technology Job Description The SharePoint Technical Team Lead will enforce and evolve design...  ...Skilled in SharePoint Client Side and Server Side Object Model, HTML, CSS, JavaScript, jQuery, XML, XSD, AJAX, and UML. Ability... 
    Work experience placement

    Direct Staffing Inc

    Irvine, CA
    3 days ago
  •  ...Talascend is currently seeking a Lead Operating Engineer for a contract opportunity with our client in Costa Mesa, California . Overview Join as a lead operating engineer overseeing facility operations and engineering excellence, supervising staff... 
    Contract work
    For contractors
    Immediate start

    Talascend

    Costa Mesa, CA
    2 days ago
  • $129k - $171k

     ...the expertise, technology, and business model of the 21st century's most innovative companies...  ...operating system that turns thousands of data streams into a realtime, 3D command and...  ...Collaborate & Influence: Act as the key technical partner to our ERP, Manufacturing, Supply... 
    Full time
    Work experience placement
    Immediate start

    Anduril Industries

    Costa Mesa, CA
    2 days ago
  •  ...that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing...  ...professionals across more than 30 countries Position: AWS Java Technical lead Location: Irvine, CA Job Duration-Long Term... 
    Local area

    E-Solutions

    Irvine, CA
    2 days ago
  • $99k - $232k

     ...success of our Firm. You are expected to lead with integrity and authenticity, articulating...  ...Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax...  ...well-architected solutions - Managing data migrations and integration solutions -... 
    Full time
    H1b

    PwC

    Irvine, CA
    9 days ago
  • $220k - $250k

     ...Tech Lead – Data Scientist Founded in 2017, Obsidian Security was created to close a critical gap: securing the SaaS applications where...  ...of SaaS security! About the Role We are looking for a Technical Lead to drive the development of Obsidian's core ontology that... 
    Work from home
    Flexible hours

    Obsidian Security

    Newport Coast, CA
    2 days ago
  • $99k - $232k

     ...success of our Firm. You are expected to lead with integrity and authenticity, articulating...  ...Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax...  ...of Firm’s services and delivery models - Leading team of onshore and offshore... 
    Full time
    Work experience placement
    H1b

    PwC

    Irvine, CA
    10 days ago
  • $170k - $180k

     ...Job Description AI-Native Full Stack Engineer - Technical Lead Salary Range: $170k to $180k Job Summary We are seeking...  ...(Kafka, Event Hubs, NATS) Experience with model fine-tuning, distillation, or self-hosted inference Background... 

    Prosum

    Irvine, CA
    1 day ago
  •  ...Loan IQ SDK Senior Lead Developer - Senior Vice President Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you'll have the opportunity to grow your career, give... 
    Relocation

    Citi

    Costa Mesa, CA
    3 days ago
  • $220k - $292k

     ...bringing the expertise, technology, and business model of the 21st century's most innovative...  ...operating system that turns thousands of data streams into a realtime, 3D command and...  ...functional programming for our customers. As a lead Haskell engineer you'll work with EW... 
    Full time
    Work experience placement
    Immediate start
    Relocation

    Anduril Industries

    Costa Mesa, CA
    1 day ago
  •  ...PL/SQL, ETL Informatica Developer Location: Port Beach CA - Onsite from day 1 Long Term Contract Must Have Technical/Functional Skills Expertise in Oracle PL/SQL Expertise in PowerCenter Informatica Knowledge in Control M, Power... 
    Long term contract
    Contract work
    Flexible hours

    AceStack LLC

    Newport Coast, CA
    1 day ago
  •  ...Strong analytical and decision-making skills, especially within legacy environments. Effective communication skills for working with technical stakeholders in fast-paced, high-urgency situations. Preferred Qualifications Experience with AWS MGN for lift-and-shift migration... 
    Shift work

    Compunnel, Inc.

    Costa Mesa, CA
    23 hours ago
  •  ...Technical Test Lead Immediate need for a talented Technical Test Lead with experience in the IT Industry. This is a 06+ Months contract opportunity with long-term potential and is located in Irvine, CA. Key Requirements and Technology Experience: Bachelor's... 
    Contract work
    Immediate start

    Pyramid Consulting

    Irvine, CA
    3 days ago
  •  ...Sr. Database Architect is responsible for leading the design, implementation, and managing...  ...including structured, unstructured, and big data to align database architecture with...  ...Minimum 8 years progressive experience in data modelling, database performance tuning, strategic... 
    Work at office
    Immediate start

    HYUNDAI Translead, Inc

    Newport Beach, CA
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Modeller - Technical Lead. Be the first to apply!