Business Analyst – Data & Mortgage

Tricon Solutions; Denver (CO); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Tricon Solutions is seeking a Data-focused Business Analyst with Mortgage industry experience in Denver. The role supports Enterprise Data Platform and Core Data Services initiatives, partnering with business and technology teams to capture requirements for reporting, analytics, and data integrations.

Ideal candidates will have strong SQL, data mapping, data governance, and enterprise data platform knowledge, plus experience with Power BI and agile methodologies.

Qualifications

• 5+ years as a Business Analyst or similar role
• Strong Mortgage industry experience is highly preferred
• Strong SQL skills for data analysis and validation

Responsibilities

• Gather, analyze, and document business and data requirements for reporting and analytics.
• Define KPIs, metric logic, dimensionality, refresh schedules, and security/access requirements.
• Collaborate with Product Owners, Data Engineers, and Architects on curated datasets, data products, semantic layers, and data APIs.
• Document source system integrations, data profiling, source-to-target mappings, transformation rules, and reconciliation processes.
• Create user stories, epics, acceptance criteria, process flows, data dictionaries, mapping documents, and test scenarios.
• Support Agile ceremonies, backlog refinement, prioritization, dependency management, and release planning.
• Perform SQL-based data exploration, validation, and data quality checks.
• Support reporting and analytics requirements using Power BI or similar BI tools.
• Define and document data governance and security requirements, including data classification, RBAC, privacy, retention, lineage, and auditability.

Skills

Business Analysis

Mortgage domain

SQL

Data mapping

Data warehousing

Power BI

Data governance

Agile/Scrum

Stakeholder management

Education

Bachelor's degree in Business, Information Systems, Data Analytics, or related field

Job description

Location: Denver, CO (Hybrid - 3 Days Onsite) Duration: 12 Months+

Key Requirements

Business Analyst - Data & Mortgage

• 5+ years of Business Analyst experience
• Strong Mortgage Industry experience - Required/Highly Preferred
• Strong experience in Data Analysis and SQL
• Data Integration and Source-to-Target Data Mapping
• Data Warehousing and Data Lakehouse concepts
• Power BI / Reporting & Analytics
• Data Governance and Data Quality
• Agile/Scrum, User Stories & Acceptance Criteria
• Strong Stakeholder Management

Job Description

We are seeking a Data-focused Business Analyst with Mortgage industry experience to support Enterprise Data Platform and Core Data Services initiatives.

The ideal candidate will partner with business and technology stakeholders to gather and define requirements for reporting, analytics, source system changes, and new data integrations. The candidate should have strong experience in SQL, data mapping, data integration, data governance, and enterprise data platforms.

Responsibilities

• Gather, analyze, and document business and data requirements for reporting and analytics.
• Define KPIs, metric logic, dimensionality, refresh schedules, and security/access requirements.
• Work closely with Product Owners, Data Engineers, and Architects on curated datasets, data products, semantic layers, master/reference data, and data APIs.
• Document source system integrations, including data profiling, source-to-target mappings, transformation rules, and reconciliation processes.
• Create user stories, epics, acceptance criteria, process flows, data dictionaries, mapping documents, and test scenarios.
• Support Agile ceremonies, backlog refinement, prioritization, dependency management, and release planning.
• Perform SQL-based data exploration, validation, and data quality checks.
• Support reporting and analytics requirements using Power BI or similar BI tools.
• Define and document data governance and security requirements, including data classification, RBAC, privacy, retention, lineage, and auditability.
• Coordinate with stakeholders and ensure delivered solutions meet business and data quality expectations.

Required Skills & Experience

• 5+ years as a Business Analyst, Product Analyst, or similar role.
• Strong experience supporting Data, Analytics, Integration, or Enterprise Data Platform initiatives.
• Mortgage domain experience (Residential or Commercial) is highly preferred.
• Strong SQL skills for data analysis and validation.
• Experience with source-to-target data mapping and data transformations.
• Knowledge of Data Warehouse, Data Lakehouse, dimensional modeling, and semantic layers.
• Experience with Power BI or similar reporting/BI tools.
• Strong understanding of Data Governance, Data Quality, Data Lineage, and Security.
• Experience with Agile/Scrum methodologies.
• Excellent stakeholder communication and management skills.

Preferred Skills

• Microsoft Fabric
• Azure Data Services
• ETL/ELT Tools
• API-based Integrations
• Data Catalog / Metadata Management Tools
• Data Products and Enterprise Data Platforms

Education

Education: Bachelor's degree in Business, Information Systems, Data Analytics, or related field, or equivalent experience.