Location: Hybrid (Toronto, Canada)
Employment Type: 12-Month Contract (Potential Contract-to-Hire)
Join Trissential and help shape the future of credit and lending data for a large, complex financial services organization. As a Senior Data Modeler, you’ll play a crucial role in transforming how the business structures, governs, and leverages credit and lending data across consumer and commercial products. If you’re energized by designing modern, scalable data models and enjoy working closely with technical and business partners, this is your opportunity to make a measurable impact within a multi‑year strategic transformation.
What’s in It for You?
- Design and influence enterprise-scale data models that power credit and lending decision-making
- Work directly with data engineers, SMEs, and analytics leaders across a complex financial ecosystem
- Build models that support regulatory reporting, analytics, forecasting, and operational decision-making
- Contribute to the evolution of a modern Snowflake and medallion‑layered architecture
- Be part of a collaborative team that values high-quality modeling, consistent standards, and strong documentation
- Expand your expertise in lending, data governance, and modeling best practices within a high‑visibility domain
Your Role & Responsibilities
In this role, you will design, enhance, and maintain core data models supporting credit and lending structures. You will:
- Design, build, and maintain logical and physical data models across credit and lending domains, including customers, accounts, loans, balances, collateral, and payment structures
- Convert business requirements into scalable architectures using dimensional, domain‑driven, and normalized modeling techniques
- Partner with data engineers, analysts, and business SMEs to standardize definitions and ensure alignment with governance frameworks
- Develop documentation including mappings, data dictionaries, and lineage artifacts
- Optimize data models to support dashboards, regulatory reporting, analytics, and downstream consumption
- Support the integration of new or evolving credit products such as mortgages, credit cards, secured lending, and revolving products
- Validate model performance, scalability, and usability within Snowflake environments
- Contribute to medallion‑layered architecture (bronze/silver/gold), ensuring traceability from source systems through curated layers
Skills & Experience You Should Possess
You don’t need to check every box — if most of this aligns with your background, we want to hear from you.
- 5+ years in enterprise data modeling, ideally within financial services, banking, or lending
- Strong understanding of credit and lending concepts (interest, balances, payments, loan lifecycle, customer/account relationships)
- Hands‑on experience with ERwin Data Modeler (required)
- Strong experience with dimensional modeling, 3NF, and/or data vault
- Ability to interpret and reconcile complex financial data definitions across systems
- Experience working with Snowflake, AWS, or other cloud data platforms
- Strong collaboration and communication skills, with a disciplined documentation style
Bonus Points If You Have:
- Experience working with lakehouse or medallion (bronze/silver/gold) architecture
- Exposure to governance or metadata platforms (e.g., Collibra)
- Hands‑on experience in regulated financial institutions with large lending portfolios
- Understanding of broader financial instruments and products
- Advanced ERwin proficiency
- Experience translating business rules into consistent, well‑structured data assets
Education & Certifications You Need:
- Bachelor’s degree in Data Science, Computer Science, Information Systems, Business Analytics, or a related field
- Certifications in data governance, data modeling, architecture, or analytics are helpful but not required
What We Offer
Trissential is committed to connecting exceptional talent with high-impact opportunities. By joining our client’s team, you’ll step into a collaborative environment where your technical expertise directly influences enterprise strategy.
- Competitive Compensation – You choose the model that works best for you, both with company-sponsored benefits! $136,000–$156,000 annually or $87–$97 per hour, depending on your skills, experience, and location. Final compensation is determined based on skill alignment, years of experience, and fair, market‑based rates by geography.
- 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
- Hybrid Work Model – Collaborate onsite in Toronto for alignment with engineering and business partners
- Career Development – Expand your skillset in credit data modeling, Snowflake, metadata management, and enterprise data architecture
- Supportive, Structured Culture – Join a team that values clarity, governance, and consistent modeling practices
This role is only open to individuals authorized to work in the United States.
Ready to make a measurable impact in credit and lending data?
Apply today and take the next step in your career as a Senior Data Modeler with Trissential.
