Hiring: Data Modeling Senior Associate Company: The Depository Trust & Clearing Corporation (DTCC) Location: Tampa, FL Job Posted Time: 2026-09-15 11:14:47 Employment Type: Remote Target Skills & Keywords : Agile, Capital Markets, Data Warehouse, Risk Management, SQL, Snowflake, Stakeholder Management About the job Experience: •7+ years of experience delivering enterprise data architecture, data modeling, and data management solutions. •5+ years of hands-on experience designing logical, physical, and dimensional data models. Required Skills: •Translate business requirements, BRDs, and Agile user stories into scalable logical, physical, and dimensional data models. •Design, implement, and optimize enterprise-scale Snowflake data models supporting analytics, reporting, regulatory, and data product initiatives. •Profile and analyze source system data using advanced SQL techniques to validate business requirements, identify data quality issues, and uncover data insights. •Create and maintain source-to-target mappings, data lineage documentation, metadata artifacts, and governance deliverables. •Partner with business stakeholders, product teams, data engineers, architects, and analytics teams to align data solutions with enterprise objectives. •Drive data model governance, standards, consistency, and model lifecycle management including schema evolution, refactoring, and metadata management. •Lead architecture reviews and facilitate model walkthroughs with technical and non-technical stakeholders. •Support enterprise data modernization, cloud transformation, and strategic data platform initiatives. Qualifications: •Bachelor's degree in Computer Science, Information Systems, or equivalent practical experience. •Expert-level proficiency with Erwin Data Modeler. •Extensive experience designing, implementing, and optimizing enterprise-scale Snowflake data models and data warehouse solutions. •Comprehensive expertise in data warehousing concepts, dimensional modeling, and modern analytical architectures. •Expertise in normalization, Kimball methodology, semantic modeling, and data governance best practices. •Financial Services, Capital Markets, Clearing, Settlement, or Risk Management industry experience. •Knowledge of post-trade processing and securities lifecycle data. •TOGAF or other data architecture certifications. Compensation: •Flexible work environment (work from home / hybrid options) •Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!