We are seeking an experienced Data Modeler with strong expertise in Asset & Wealth Management, Retirement Services, or Financial Services. The candidate will design scalable enterprise data models supporting Data Warehouse, Lakehouse, Data Products, BI, and AI initiatives.
- 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.
RequirementsRequired Skills
- 10+ 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.
- 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.
Erwin | Databricks | Snowflake | AWS | SQL | Data Warehouse | Lakehouse | Medallion Architecture | Canonical Data Modeling | BI/Analytics | Data Governance
Benefits
Skills Required
- 10+ years of experience in data modeling or data architecture
- Strong experience in asset management, wealth management, retirement services, or financial services
- Hands-on experience with Erwin
- Strong knowledge of Databricks, Snowflake, AWS, and SQL
- Experience with canonical data modeling, dimensional modeling, lakehouse architecture, and medallion architecture
- Strong understanding of BI and analytics, data governance, metadata, and data lineage
- Excellent communication and stakeholder management 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 and catalog tools
- Experience supporting AI/ML and self-service BI initiatives
- Relevant AWS, Databricks, Snowflake, or data architecture certifications
What We Do
Exavalu leads the way in business and technology consulting and solution delivery, focusing on specialized digital transformation across the Insurance, Healthcare & Life Sciences, and Nonprofit industries. As an award-winning digital transformation advisor, we take pride in delivering leading-edge solutions to clients worldwide. Led by industry veterans and technology experts, we bring our deep understanding in customer experience, process automation, digital engineering, cloud, data and AI with a very strong industry core foundation. Drawing on our industry insights and technological acumen, we enable clients to drives growth, profitability, and cost optimization. We mitigate risks and elevate customer experience through our comprehensive suite of services, including strategic advisory, expert-led technology [build and maintenance], and best-in-class products and solutions. Our unwavering focus on understanding the industry's hard problems and finding the right solution has garnered recognition as the preferred ally for organizations seeking transformative growth.
.png)
