Designs and maintains conceptual, logical, physical, canonical, conformed, and dimensional data models for enterprise data warehouses, lakehouses, data products, BI, and AI initiatives. Defines facts, dimensions, KPIs, metadata, governance, lineage, and data quality standards. Partners with governance, product, engineering, architecture, and business teams, leading model reviews and translating requirements into reusable data domains and products.
Data Modeler
RequirementsRequired Skills
Benefits
Charlotte, NC. Hybrid - 3 days in office.
Job DescriptionWe 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
Exavalu also promotes flexibility, adapting to the needs of employees, customers, and the business. It might be part-time work, working outside normal 9-5 business hours or working remotely. We also offer a welcome back program to help individuals return to the mainstream after a prolonged absence due to health or family reasons.
At Exavalu, we are committed to building a diverse and inclusive workforce. We welcome applications for employment from all qualified candidates, regardless of race, colour, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law. We nurture a culture that embraces all individuals and promotes diverse perspectives, where you can make an impact and grow your career.
Similar Jobs
Greentech • Other
Develop and govern enterprise conceptual, logical, and physical data models across business domains. Establish modeling standards, metadata practices, data definitions, and governance processes. Design integration patterns supporting ERP, CRM, cloud, warehouse, data mesh, and data fabric environments. Collaborate with business and technical stakeholders, optimize data structures, document lineage, mentor junior professionals, and ensure model alignment with enterprise architecture and data strategy.
Top Skills:
AlationAWSCollibraCRMData FabricData LakesData MeshData VaultData WarehousesEr/StudioErpErwinGCPMaster Data ManagementAzureOraclePowerdesignerSAPSnowflake
Information Technology • Software • Consulting • Cybersecurity
Lead design and deployment of logical and physical data models for transactional and analytical systems. Perform source analysis, data profiling, and collaborate with DBAs for performance tuning. Support development teams during design and implementation, contribute to modeling processes and guidelines, and participate in business and IT planning for data initiatives.
Top Skills:
Bi ReportingData MartData ProfilingData WarehouseDimensional ModelingErwinMicrosoft Sql Server (Mssql)OltpSybase Powerdesigner
.png)
Healthtech
Design and document conceptual, logical, and physical data models (relational, dimensional, NoSQL). Support data architecture and governance, produce DDL/SQL, design Snowflake Silver/Gold analytical layers, mentor other modelers, and map healthcare sources to FHIR resources when applicable.
Top Skills:
DdlDimensional ModelingEr ModelingErstudioHl7 FhirNoSQLSnowflakeSQL
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
