> Markdown version of [/jobs/ext/2576006-data-modeler](https://www.wearedevelopers.com/jobs/ext/2576006-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeler

- **Company:** Trail Blazer Consulting LLC
- **Location:** Malvern, PA, United States
- **Experience:** Expert
- **Contract:** Temporary to permanent
- **Skills:** Amazon Web Services, Audit Trail, Microsoft Azure, Big Data, Databases, Data Architecture, Information Engineering, Data Governance, Data Integrity, Extract Transform Load (ETL), Relational Databases, Meta-Data Management, Microsoft SQL Server, Reference Data, Cloud Services, Sql Optimization, Snowflake, Data Lineage, Star Schema, Physical Data Models, Data Pipelines
- **Published:** August 14, 2026
- **Apply:** https://www.dice.com/job-detail/16870e6f-3b1b-4921-aaa2-130daade85ce

## About the Role

* 8+ years of experience in enterprise data modeling and data architecture.

 * Proven experience within investment management, asset management, wealth management, or broader financial services environments.

 * Strong understanding of conceptual, logical, canonical, and physical data modeling methodologies.

 * Hands-on experience designing dimensional (star schema) and normalized relational data models.

 * Advanced SQL skills with the ability to analyze, validate, and optimize complex datasets.

 * Proficiency with enterprise data modeling tools such as Erwin, ER/Studio, Hackolade, or similar platforms.

 * Experience working with cloud data platforms and databases, including Snowflake, SQL Server, AWS, and Azure.

 * Knowledge of data governance, metadata management, data lineage, and slowly changing dimension (SCD) concepts.

 * Experience partnering with cross-functional teams to translate business requirements into scalable data solutions.

 * Familiarity with financial services regulatory and compliance requirements related to data privacy, audit trails, and data integrity.

## Description

* Design, develop, and maintain conceptual, logical, canonical, and physical data models, including ERDs and dimensional/star schemas, to support asset management, wealth management, and financial advisory platforms.

 * Partner with business stakeholders, data engineers, solution architects, and technical teams to translate complex financial domain requirements into scalable, enterprise data models.

 * Model data across key financial subject areas, including financial profiles, advisor teams, securities, holdings, portfolio performance, and risk analytics.

 * Apply data modeling best practices, including normalization, slowly changing dimensions (SCD), data lineage, metadata management, and reference data governance.

 * Develop and optimize data models across relational databases, cloud platforms, and big data environments such as Snowflake, SQL Server, AWS, and Azure.

 * Ensure data models comply with financial services regulatory requirements, including data privacy, auditability, and reference data integrity.

 * Collaborate with ETL and data engineering teams to validate source-to-target mappings, troubleshoot data quality issues, and support reporting and analytics initiatives.


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)