Senior Data Analyst / Data Modeler

Job summary

Design, develop, and maintain logical and physical data models to support complex lending and credit domains. Collaborate with data engineers and business stakeholders to ensure data consistency, governance, and scalability within a cloud-based environment.

Job details

Overview Location: Fully Remote (Canada) Are you passionate about designing scalable data models that drive smarter lending and credit decisions? Trissential is hiring a Senior Data Analyst / Data Modeler to join our client's team and help shape the future of enterprise data within a large and complex financial services environment. This is an exciting opportunity to play a key role in a multi-year transformation initiative focused on modernizing data architecture, governance, analytics, and reporting capabilities. If you enjoy solving complex data challenges and working closely with both technical and business teams, this role offers the chance to make a measurable impact from day one. What's in It for You? Design enterprise-scale data models that support critical lending, risk, and financial decision-making Work alongside data engineers, architects, business SMEs, and analytics leaders across a highly collaborative environment Contribute to a modern cloud data ecosystem leveraging Snowflake and medallion architecture principles Help build data assets that support regulatory reporting, analytics, forecasting, and business intelligence Influence enterprise data standards, governance practices, and modeling methodologies Gain exposure to large-scale lending portfolios, credit products, and strategic transformation initiatives Enjoy the flexibility of a fully remote work environment while working on high-impact projects Your Role & Responsibilities Design, develop, and maintain logical and physical data models supporting credit and lending domains including customers, accounts, loans, balances, collateral, and payment structures Translate business requirements into scalable data architectures using dimensional modeling, normalized models, data vault methodologies, and domain-driven design principles Partner with data engineers, analysts, business stakeholders, and SMEs to ensure consistency of business definitions and governance standards Develop and maintain data dictionaries, mapping documents, lineage artifacts, and metadata documentation Optimize data models to support analytics, reporting, regulatory requirements, dashboards, and downstream applications Support the onboarding and integration of new lending products including mortgages, credit cards, secured lending, and revolving credit products Validate model scalability, usability, and performance within Snowflake environments Contribute to bronze, silver, and gold medallion architecture layers to ensure full traceability from source systems to curated business-ready datasets Assist with data quality initiatives, business rule validation, and cross-system reconciliation activities Skills & Experience You Should Possess 8+ years of experience in data analysis, data modeling, data architecture, or related disciplines Strong enterprise data modeling experience within financial services, banking, lending, or other regulated industries Deep understanding of credit and lending concepts including loan lifecycle management, balances, payment structures, interest calculations, and customer-account relationships Expertise in dimensional modeling, third normal form (3NF), and/or Data Vault methodologies Strong experience translating business requirements into scalable, governed data structures Experience working within enterprise data governance frameworks and metadata management practices Hands-on experience with Snowflake, AWS, or other cloud-based data platforms Ability to interpret, reconcile, and standardize complex financial data definitions across multiple source systems Excellent stakeholder management, communication, and documentation skills Strong analytical thinking and problem-solving capabilities Bonus Points If You Have Hands-on experience with ERwin Data Modeler Advanced ERwin data modeling expertise Experience working within lakehouse or medallion architecture environments Exposure to data governance and metadata platforms such as Collibra Experience supporting highly regulated financial institutions Knowledge of broader financial products and financial services ecosystems Experience supporting regulatory reporting and compliance data initiatives Ability to translate complex business rules into governed, reusable enterprise data assets Education & Certifications You Need Bachelor's degree in Computer Science, Data Science, Information Systems, Business Analytics, Mathematics, Engineering, or a related discipline Certifications in Data Architecture, Data Governance, Data Modeling, Snowflake, AWS, Analytics, or related disciplines are considered an asset What We Offer At Trissential, we connect exceptional talent with meaningful opportunities that make a real business impact. By joining our client's team, you'll work on critical data transformation initiatives while advancing your career in a collaborative, innovative environment. Competitive Compensation – You choose the model that works best for you, both with company-sponsored benefits! $155,000-$165,000 annually or $92-$102 per hour. 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 – Extensive Medical Plans, Dental, Vision, HSA with company contribution, company sponsored Life Insurance and Short / Long term disability insurance, a host of voluntary plans including legal, hospital, accident, pet wellness, and 401k with matching Paid Holidays and Paid Time Off Career Development and Advancement – Expleo is a global company in 29 Countries worldwide with a high focus on development Strong Team Culture – Collaborate with experienced professionals who value precision, performance, and teamwork This position is open only to candidates who are currently authorized to work in Canada Ready to be part of something exciting? If you're passionate about enterprise data modeling, credit and lending analytics, and building scalable data foundations that power business decisions, we'd love to hear from you. Apply today and help shape the future of data-driven decision-making with Trissential and our client

What you’ll do

Design, develop, and maintain logical and physical data models to support complex lending and credit domains. Collaborate with data engineers and business stakeholders to ensure data consistency, governance, and scalability within a cloud-based environment.

Requirements

Requires 8+ years of experience in data modeling or architecture within the financial services industry. Candidates must possess deep expertise in dimensional modeling, cloud platforms like Snowflake, and enterprise data governance frameworks.

Benefits

• Medical plans • Dental • Vision • HSA with company contribution • Life insurance • Short term disability insurance • Long term disability insurance • Voluntary legal plan • Voluntary hospital plan • Voluntary accident plan • Pet wellness plan • 401k with matching • Paid holidays • Paid time off

Listed skills

• SQL · Preferred
• Data analysis · Preferred
• Amazon Web Services · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data modeling
• Data architecture
• Snowflake
• Dimensional modeling
• Data vault
• Financial services
• Lending
• Credit analysis
• Data governance
• Metadata management
• SQL
• AWS
• Regulatory reporting
• Business intelligence
• Data analysis
• Stakeholder management
• Scalability Design
• Influencing Skills
• Erwin (Data Modeling Software)
• Influencing Without Authority
• Petcare
• Analytical Thinking
• Time Off Management
• Business Decisions
• Snowflake (Data Warehouse)
• Collibra (Software)
• Technology Ecosystems
• Data-Driven Decision Making
• Third Normal Form
• Amazon Web Services
• Data Analysis
• Reconciliation
• Business Intelligence
• Business Analytics
• Business Continuity Planning
• Dashboard
• Business Requirements
• Decision Making
• Communication
• Computer Science
• Information Systems
• Mortgage Loans
• Data Architecture
• Data Dictionary
• Data Governance
• Data Transformation
• Data Modeling
• Data Quality
• Data Structures
• Data Vaults

Job areas

• Data & Analytics
• Technology
• Finance & Accounting
• Consulting
• Software
• Data Analyst/Data Modeler
• Data Scientist
• Systems Analysts
• Data Scientists