Sr. Data Modeler

Role : Sr. Data Modeler

Location : Tampa, FL (Hybrid)

The Senior Database Designer is responsible for building the organization’s enterprise data models and database structures. The role is responsible for conceptual, logical, and physical data modeling that supports operational systems, analytical workloads, and harmonized data domains within the enterprise data ecosystem. The position will partner closely with business SMEs, data engineering, governance, and analytics teams to ensure that data structures are documented, standardized, scalable, performant, and aligned to corporate governance policies and integration standards. The successful candidate will bring deep expertise in dimensional and relational modeling, strong proficiency with modern cloud data platforms, and the ability to drive modeling best practices across the organization.

Key Responsibilities

Enterprise Data Modeling and Architecture

• Lead the design and delivery of conceptual, logical, and physical data models for enterprise data domains and data products (operational and analytic).
• Develop harmonized, reusable, and governed data models that support single-source-of-truth design principles.
• Establish and maintain modeling standards, including naming conventions, dimensional modeling patterns, SCD2 strategies, surrogate key methodologies, lineage documentation, and data enrichment frameworks.
• Design models to support high-volume incremental ingestion (CDC), complex history tracking, and auditable data transformations.
• Produce and maintain full metadata and lineage documentation through approved tools (e.g., ER / Studio, Unity Catalog).

Integration, Data Engineering Enablement, and Delivery

Performance, Quality, and Governance

Stakeholder Engagement

Qualifications

o Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related discipline.

o 7+ years of progressive experience in data modeling, database design, and data architecture.

o Demonstrated expertise with relational and dimensional modeling (3NF and star schema design).

o Proficiency with cloud-based modern data stack environments (Azure preferred; Databricks experience highly valued).

o Strong proficiency with SQL for model validation, profiling, and optimization.

o Experience with data modeling tools such as ER / Studio, ERwin, DB Schema, or equivalent.

o Hands-on experience supporting data warehouses, datamarts, and metadata-driven modeling approaches.

o Experience supporting data ingestion and CDC design patterns and SCD2 data history strategy.

o Strong attention to detail regarding data quality, lineage, governance, and documentation.

o Excellent communication skills with proven ability to clearly articulate design rationale to technical and non-technical audiences.

o Experience in the insurance or financial services industry with knowledge of policy, client, and revenue data structures.

o Familiarity with ETL / ELT orchestration tools (Fivetran, Airflow, MuleSoft) and distributed processing frameworks (Spark).

o Experience with semantic modeling layers (e.g., Tableau semantic layer, dbt metrics, or similar).

o Certification in cloud platforms (Azure Data Engineer, AWS Data Analytics, or equivalent).