Data Modeler
Trail Blazer Consulting LLC
Dice Job Match Score™
🫥 Flibbertigibetting...
Job Details
Skills
- Amazon Web Services
- Analytics
- Collaboration
- Data Architecture
- Data Engineering
- Database
- ER/Studio
- ERwin
- Data Governance
- Data Integrity
- Data Modeling
- Data Quality
- Asset Management
- Auditing
- Big Data
- Financial Services
- Cloud Computing
- LinkedIn
- Normalization
- Physical Data Model
- Meta-data Management
- Microsoft Azure
- Microsoft SQL Server
- Extract, Transform, Load
- SCD
- SQL
- Securities
- Regulatory Compliance
- Relational Databases
Summary
Job Title | Sr. Data Modeler |
Location | Malvern, PA – Hybrid – 3 days a week |
Duration | 6 months + Possible extension |
Interview Mode | Video 2 rounds |
2 manager references with LinkedIn
Key Responsibilities:
• 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.
Required Qualifications:
• 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.
- Dice Id: 91093714
- Position Id: 9055708
- Posted 1 day ago
Company Info
About Trail Blazer Consulting LLC
At TRAIL BLAZER we help our IT consultants explore different industries, multiply their skills, and accelerate their career growth with industry-leading firms. We offer the flexibility of direct hire placements, temporary, and project work. With offices nationwide, TRAIL BLAZER combines the resources of a national network with in- depth local expertise. We offer the flexibility of direct placements, and project work.
Trail Blazer Consulting LLC is headquartered in Astoria, NY, USA. We are a leading professional consulting firm with a global database of applicants and state of art technology and process to identify the best and brightest skills.Trail Blazer is committed to provide customer satisfaction through commitment highest standards of services. With a range of skill sets and a flexible support network, we can deliver quick and cost effective resources to our valued Clients. We spend a considerable amount of time and resources screening and hiring top quality consultants, which allows us to provide premier resources that meet and exceed our client expectations.
OUR MISSION, VISION& VALUES:
We at TRAIL BLAZER CONSULTING believe in attaining success. We know that success is important to both our associates and our clients. Our mission is to understand and deliver 100%. With our commitment towards our clients, it helps us in achieving growth, innovation and excellence. We want to be an integral part of that process. To that end, we believe in the following Mission & Vision Statements and set of Core Values:
STAFF AUGMENTATION:
Staff Augmentation, or better known as subcontracting, is primarily outsourcing of manpower on a skill requirement or project completion basis for a limited period of time. From the past few years the IT departments have gone through a difficult phase as they have been pressed to deliver impressive results on multiple initiatives with limited staff. Staffing may be desired when there are a dynamic temporary or permanent people or skilled staff.
IT CONSULTING:
TRAIL BLAZER brings together the key IT consulting services that address aspects of reducing cost, increasing agility and enabling transformation. Our consultations are based on an analytical approach to understand the business problems, resulting in the practical recommendation and actionable plans. Our value proposition is based on a confluence of business knowledge, deep hands-on technology skills and a focused approach through the use of in-house methodologies, frameworks and tools.
CORE VALUES:
TRAIL BLAZER CONSULTING core values convey who we are as an organization and how we deliver value.
VOLUNTEER
our time, talent & resources
ACCOUNTABILITY
as we pursue our aspirations
LEGACY
to impact others lives
UNBEATABLE
as we collaborate & compete
EXTRAORDINARY
in all we do
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs