Senior Data Modeler

Overview: Location: Remote Compensation: Full-Time Are you a seasoned Data Modeler with a passion for financial data and a knack for ERwin? Trissential is hiring a Senior Data Modeler to join our client’s team as they evolve into a data-centric organization. This is your chance to shape the future of wealth management data architecture and work on high-impact initiatives that drive smarter, faster decisions across banking, lending, and investment products. What’s in It for You? Strategic Impact – Be a key contributor to enterprise data transformation and medallion-layered architecture Remote Flexibility – Work from anywhere in the U.S Financial Domain Focus – Dive deep into wealth management data, including securities, lending, and banking products Collaborative Culture – Partner with data engineers, analysts, and SMEs across business and technology Innovation-Driven Environment – Work with Snowflake, AWS, and modern data frameworks Your Role & Responsibilities Design and maintain logical and physical data models across domains (clients, accounts, lending, securities) Apply dimensional, 3NF, and data vault modeling techniques to align with business needs Collaborate with cross-functional teams to ensure consistent definitions, governance, and data quality Develop transformation mappings, data dictionaries, and lineage documentation Support integration of new financial products into existing models Optimize data for analytics, dashboards, and predictive capabilities Validate model performance and scalability in Snowflake Contribute to medallion-layered architecture (bronze/silver/gold) and ensure traceability Skills & Experience You Should Possess 15+ years of enterprise data modeling experience, ideally in financial services or wealth management Strong understanding of financial instruments and products (securities, annuities, lending, banking) Proficiency with ERwin Data Modeler (required) Expertise in dimensional modeling, 3NF, and data vault methodologies Experience with Snowflake, AWS, or similar cloud platforms Excellent communication and documentation skills Bonus Points If You Have Experience with medallion/lakehouse architecture Familiarity with data governance tools (e.g., Collibra) Experience documenting data transformation business rules Background in data quality, metadata, or lineage tracking Education & Certifications You Need Bachelor’s degree in Computer Science, Information Systems, or related field Certifications in data modeling or cloud platforms (preferred but not required) What We Offer At Trissential, we believe in rewarding talent and supporting your career journey. By joining our client’s team, you’ll enjoy: Competitive Compensation – You choose the model that works best for you, both with company-sponsored benefits! Up to $176,800 annually or $100 per hour, based on skills and experience- Final compensation determination will be based on skill alignment, overall years of experience and geographic location based on fair and equitable market rates. Comprehensive Benefits for you and your dependents – Medical, dental, vision, free tele-health, HSA with company contribution, life and disability insurance, and 401k with matching Paid Time Off – Both compensation models offer paid time away from work Remote Flexibility – Work from anywhere in the U.S. Career Development – Access to training, certifications, and leadership opportunities Supportive Team Culture – Work with a team that values continuous learning and growth Please note: This role is only open to candidates authorized to work in the United States. Ready to shape the future of financial data? Apply today and take the next step in your career as a Senior Data Modeler with Trissential!