Data Modeler

• Lead the end-to-end data modeling lifecycle, from conceptual through physical models
• Design logical and physical data models optimized for Snowflake and analytical workloads
• Translate business requirements into clear, scalable data structures
• Partner with data engineers to ensure models are efficiently implemented in Snowflake
• Support model-to-source and model-to-target mappings
• Ensure models support performance, scalability, and secure data access
• Maintain data dictionaries, lineage documentation, and metadata artifacts
• Collaborate with data governance teams on naming standards and data quality rules
• Participate in design reviews, change management, and impact analysis for data changes

Senior Data Modeler designing Snowflake data foundations for Trissential’s enterprise clients

Senior Data Modeler, Snowflake

Senior Data Modeler designing Snowflake data models for Trissential’s enterprise clients. Building scalable foundations for analytics, reporting, governance, and secure data access.

• Design enterprise-wide data modeling standards, including conceptual, logical, and physical models for governed, performant, reusable data products on Snowflake
• Translate business concepts, Critical Data Elements (CDEs), and analytics needs into structured schemas and semantic definitions
• Define and maintain canonical entities, conformed dimensions, and metric definitions aligned to the glossary/ontology
• Implement physical data models on Snowflake, including star/snowflake schemas, Data Vault, and 3NF structures where appropriate
• Optimize Snowflake implementations using micro-partitioning, materialized views, search optimization, and clustering choices
• Document design decisions such as SCD handling and surrogate keys
• Define and maintain data product contracts, including schemas, SLAs/SLOs, versioning, and change policies
• Ensure models are discoverable and governed with complete metadata, lineage, and ownership in the catalog
• Classify and tag CDEs/PII and enable tag-based masking and row-access policies, including evidence for attestations
• Publish modeling standards and runbooks supporting performance and reliability goals, including BI latency targets under 10 seconds where required
• Provide guidance on warehouse strategy, result caching, and model refactoring
• Specify validation rules and profiling thresholds tied to CDEs and integrate tests into CI/CD and stewardship workflows
• Create model diagrams, semantic definitions, and consumer guides
• Partner with stewards and analysts to drive adoption and deprecate redundant reports and datasets
• Work model-as-code using Git-based CI/CD and testing while designing for privacy and performance
• Mentor junior data modelers as needed

Principal Data Modeler designing governed Snowflake data products for Empower’s financial services business

Principal Data Modeler

Principal Data Modeler designing governed Snowflake schemas, semantic definitions, and data contracts.
Supporting Empower’s financial services data products through governance, performance optimization, and model-as-code practices.

• Build, maintain, and improve financial models and analytical tools supporting actuarial pricing, manual rating, and reporting for stop-loss, reinsurance, and captive programs
• Translate the data currently being collected into usable and actionable initiatives, and assist with the development, collection, organization, and reporting of additional data meaningful for the firm
• Support initiatives to automate and standardize Excel-based tools, including the application of AI to speed up calculations, quality checks, and data organization
• Update and maintain rating templates and rate calculators used by the underwriting team for new and renewal business
• Perform quality checks and validate the outputs of financial models against source data
• Assist in tracking cost drivers, trends, and portfolio-level metrics across stop-loss and captive programs
• Collaborate with actuarial, underwriting, finance and sales teams to gather requirements for tools, templates, and reports
• Prepare and maintain clear documentation for financial models, tools, and related processes
• Support ad hoc data requests and analyses for the Chief Actuary and Actuarial Directors
• Maintain and expand working knowledge of healthcare reinsurance, stop-loss, and captive insurance concepts

Building financial models and tools for healthcare reinsurance pricing at Ryan Specialty

Stop Loss Data Modeler

Building, maintaining, and improving financial tools and models for healthcare reinsurance pricing. Collaborating with actuarial and underwriting teams to support company goals.

• Design, develop, and maintain conceptual, logical, and physical data models that support the VFMP Modernization Portfolio.
• Produce comprehensive database design documentation, including entity relationship diagrams, data models, data dictionaries, metadata definitions, and data flow diagrams.
• Analyze business requirements and translate them into scalable, efficient, and maintainable database designs.
• Evaluate and configure database technologies to align user requirements with system capabilities, performance objectives, and operational needs.
• Determine appropriate database structures, file organization, indexing strategies, partitioning methods, and storage optimization techniques.
• Define and implement database security, data integrity, and access control procedures consistent with VHA and Federal information security requirements.
• Plan, coordinate, and support the migration and conversion of legacy databases into modernized environments while preserving data quality and integrity.
• Collaborate with application development, systems engineering, and EDI teams to ensure data models support provider, eligibility, claims, and related transaction processing.
• Support modernization initiatives that improve efficiency across high-volume business operations, including:
• - Beneficiary enrollment
• - Claims adjudication
• - Appeals processing
• - Benefits coordination
• - Care coordination
• - Pharmacy support
• - Nurse review
• - Processing of non-standard customer requests
• Ensure data models enable modernization objectives by supporting:
• - Inventory management within established Key Performance Indicators (KPIs)
• - Processing timeliness as operational volumes increase
• - High levels of data accuracy and integrity
• - Enterprise performance measurement and reporting
• - User-friendly and maintainable solutions for VFMP and VHA
• Collaborate with Integrated Project Teams (IPTs), business analysts, solution architects, database administrators, and vendors to ensure consistent enterprise data architecture.
• Identify opportunities to improve data quality, reduce redundancy, standardize data definitions, and enhance enterprise data governance.
• Support testing, validation, and quality assurance activities to ensure data models function as intended within enterprise applications.
• Document data standards, modeling conventions, database architecture, and migration procedures to support long-term system maintenance.

Data Modeler providing technical expertise for VHA's Veterans Family Member Program

Data Modeler providing technical expertise in designing data models for VHA's Veterans Family Member Program modernization initiatives. Collaborating with various teams to improve operational efficiency and data integrity.

• Support our solution architects, software developers, data analysts and data scientists on data and analytics initiatives
• Serve in a lead capacity on client initiatives
• Ensure optimal data delivery architecture is consistent throughout ongoing projects
• Be self-directed and comfortable supporting the data needs of multiple teams, systems, and products
• Be excited by the prospect of building our company’s data engineering capabilities to support our next generation of products and data initiatives
• Lead, grow, and mentor a data engineering team in developing, maintaining, and monitoring data solutions for clients
• Assist in defining client solutions and support managing their delivery

Senior Data Modeler delivering data solutions for life sciences, consumer products, and retail

Senior Data Modeler – Databricks

Senior Data Modeler delivering data solutions for life sciences and retail industries at Clarkston Consulting. Leading data initiatives and mentoring engineering teams in a hybrid work environment.

• Manage an enterprise data model collaborating with clinicians and data scientists
• Author and maintain entity-relationship diagrams and data dictionaries
• Implement solutions to transform source data to a common data model
• Collaborate with clinicians to implement and validate feature definitions
• Monitor data quality with traceability to source systems
• Evaluate completeness of source data models

Senior Data Modeler managing enterprise data model in healthcare industry

Senior Data Modeler

Senior Data Modeler managing enterprise data model collaborating with healthcare professionals at Tempus. Responsible for implementing solutions for data integration and quality monitoring in clinical settings.

Data Modeler jobs in United States