Data Modeler

  • Irving, TX
  • Posted 14 hours ago | Updated 14 hours ago

Overview

On Site
Depends on Experience
Contract - W2

Skills

Banking
Big Data
Data Governance
Data Modeling
Data Quality
Data Structure
Data Warehouse
PL/SQL
PostgreSQL
ERwin
ER/Studio

Job Details

Key Responsibilities:

  • Design and develop conceptual, logical, and physical data models to support transactional, analytical, and reporting systems.
  • Partner with business stakeholders and SMEs in banking and wealth management to gather and analyse requirements.
  • Translate business needs into high-quality data models for investment products, client portfolios, financial planning, advisory services, and regulatory reporting.
  • Develop and maintain data dictionaries, metadata repositories, and data lineage documentation.
  • Collaborate with data engineers, ETL developers, and BI/reporting teams to ensure models support downstream use cases.
  • Optimize and tune data models for performance, scalability, and integration across multiple platforms (e.g., RDBMS, NoSQL, cloud storage).
  • Support data governance, data quality, and master data management efforts.
  • Ensure compliance with industry standards (e.g., BCBS 239, CCAR, MiFID II) and data privacy regulations (e.g., GDPR, CCPA).
  • Provide guidance on best practices in data modeling, especially in the financial services domain.

Qualifications:

Must-Have:

  • Bachelor s or master s degree in computer science, Information Systems, Finance, or a related field.
  • 6+ years of experience in data modeling, with at least 3+ years in the banking/wealth management domain.
  • Strong hands-on experience with data modeling tools like Erwin, ER/Studio, Power Designer, or similar.
  • Proven knowledge of financial data structures accounts, transactions, holdings, asset classes, performance, risk metrics, etc.
  • Expertise in relational databases (e.g., Oracle, SQL Server, PostgreSQL) and familiarity with big data platforms (e.g., Hadoop, Snowflake, Databricks).
  • Understanding of data warehousing, data lakes, and data mesh architectures.
  • Excellent SQL and analytical skills.
  • Strong communication skills and ability to work cross-functionally with business and IT stakeholders.

Nice to Have:

  • Experience with Wealth Tech platforms (e.g., Avaloq, Temenos, Charles River, Invest Cloud).
  • Knowledge of reference data management, market data, and KYC/AML data

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.