Data Modeler
Contract W2
6 Months
No Travel Required
Hybrid
Depends on Experience
Aneka Talent Solutions
Fitment
Dice Job Match Score™
🛠️ Calibrating flux capacitors...
Job Details
Skills
- ERwin
- ER/Studio
- Amazon Web Services
- Data Modeling
- Star Schema
Summary
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91162723
- Position Id: 9055259
- Posted 1 day ago
Company Info
About Aneka Talent Solutions
Aneka Talent Solutions Corp is a rapidly growing Information Technology services and solutions company providing innovative and cost-effective solutions for our customers. We provide solutions for a dynamic environment where business and technology strategies converge. Our approach focuses on new ways of business combining IT innovation and adoption while also leveraging an organization's current IT assets. We offer contract, contract to hire and permanent placement solutions for roles in finance and accounting, technology, healthcare, logistics, retail, creative, legal, administrative, customer support.
Create job alert
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