Sr. Data Modeler

Please note that we do not offer visa sponsorship for this position.

We are seeking highly skilled individuals to join our Enterprise Data Architecture practice. In this role, you will design high-quality domain (canonical) data models, consumption-layer dimensional models, and drive data architecture and governance standards across our enterprise data platform. You will collaborate with business and technical stakeholders to define, document, and govern how data flows across the organization – supporting analytics, reporting, operational use cases, and advanced data science initiatives.

This role is ideal for professionals who enjoy hands-on solution designing, driving best practices, and shaping the long-term data architectural foundation for a modern and fast-growing life insurance and annuities organization. This role will be key to create models for several layers of our enterprise data platform, define end to end data lineage, participate in data engineering design reviews, collaborate with all stakeholders, and take complete ownership in establishing a highly performant data platform for the organization.

This position currently offers an onsite work schedule, with the expectation that you are in the office four (4) days per week during onsite core days. Our current onsite core days are Monday, Tuesday, Wednesday, and Thursday.  The work schedule type and core days are subject to change with advance notification and manager discretion.

• →Design and maintain conceptual, logical, and physical data models aligned with business capabilities.
• →Build consumption-layer models for analytics, BI, and machine learning.
• →Define and enforce modeling standards, naming conventions, and data governance practices.
• →Document data lineage, transformation logic, and metadata using enterprise tools.
• →Collaborate with Data Engineers, Analytics, and Data Science teams to implement models and optimize performance.
• →Analyze source data quality, recommend cleansing solutions, and support data quality frameworks.
• →Stay current with industry standards and emerging practices (ACORD, DAMA-DMBOK, Data Vault, Kimball, Data Mesh).
• →Contribute to agile delivery and produce architecture deliverables within sprint timelines

• Bachelor’s degree in STEM preferred; advanced degree is a plus.
• 5–10+ years in data architecture, data modeling, or enterprise analytics.
• Strong experience with canonical/domain modeling, dimensional modeling, and semantic modeling.
• Proficiency in SQL and familiarity with Azure Databricks (Delta Lake, Unity Catalog).
• Experience with data modeling tools (Erwin, ER/Studio) and metadata management platforms (Purview, Collibra, Alation).
• Knowledge of data governance, master/reference data concepts, and privacy/security controls.
• Domain experience in life insurance, annuities, or related financial services preferred.
• Excellent communication skills and ability to work in agile environments.