Data Modeler

Job Role: Data Modeler with strong expertise in Asset & Wealth Management or Retirement Services or Financial Services

Location: Charlotte, NC. Hybrid - 3 days in office.​

No of position: 1

Exp. Start date: 1^st week of September

Year of Experience: 12+ Years

Type: Full Time

Core Technologies : Erwin | Databricks | Snowflake | AWS | SQL | Data Warehouse | Lakehouse | Medallion Architecture | Canonical Data Modeling | BI/Analytics | Data Governance

Job Description

We are seeking an experienced Data Modeler with strong expertise in Asset & Wealth Management or Retirement Services or Financial Services. The candidate will design scalable enterprise data models supporting Data Warehouse, Lakehouse, Data Products, BI, and AI initiatives.

Key Responsibilities

·       Design and maintain conceptual, logical, and physical data models.

·       Develop canonical, conformed, and dimensional data models using Star and Snowflake schemas.

·       Define facts, dimensions, hierarchies, measures, KPIs, and business rules.

·       Support Lakehouse and Medallion Architecture (Bronze, Silver, Gold).

·       Translate business requirements into reusable data domains and data products.

·       Define data modeling, metadata, naming, and governance standards.

·       Partner with Data Governance teams on data quality, ownership, lineage, and glossary.

·       Support data catalog, semantic layer, BI, analytics, and AI initiatives.

·       Lead model reviews and collaborate with business, product, engineering, and architecture teams.

Required Skills

·       12+ years of experience in Data Modeling/Data Architecture.

·       Strong experience in Asset Management, Wealth Management, Retirement, or Financial Services.

·       Hands-on experience with Erwin.

·       Strong knowledge of Databricks, Snowflake, AWS, and SQL.

·       Experience with Canonical Data Modeling, Dimensional Modeling, Lakehouse, and Medallion Architecture.

·       Strong understanding of BI/Analytics, Data Governance, Metadata, and Data Lineage.

·       Excellent communication and stakeholder management skills.

Preferred Skills

·       Experience with Data Mesh and Domain-Driven Design.

·       Experience building Data Products and Semantic Data Layers.

·       Knowledge of Collibra, Alation, or similar data governance/catalog tools.

·       Experience supporting AI/ML and self-service BI initiatives.

·       Relevant AWS, Databricks, Snowflake, or Data Architecture certifications.