Mortgage Data Analyst II

Overview

Position: Mortgage Data Analyst II - Retail Lending & Loan Lifecycle

Location: Remote (Candidates living within 31 miles of Santa Ana, CA or Austin, TX must be available to work on-site 4 days per week)

Salary: Starting at $90,000 per year, depending on experience, plus full-time benefits

Industry Requirement: Must have retail mortgage industry experience

Responsibilities

• Design, develop, and maintain ongoing metrics, reports, analyses, and dashboards to support stakeholder engagement
• Build Power BI dashboards utilizing complex DAX functions and merge multiple data sets and sources
• Write and analyze complex SQL scripts to design critical data sets and resolve data quality issues
• Perform data cleansing and ensure data accuracy
• Apply strong analytical and problem-solving skills with attention to detail
• Identify, analyze, and resolve problems logically and systematically
• Communicate complex information clearly and effectively, providing actionable recommendations based on data insights
• Collaborate effectively within a fast-paced, customer-oriented team environment
• Manage ambiguity and competing priorities in a dynamic work setting
• Perform additional duties as assigned

Requirements

• Experience independently designing and implementing solutions to complex problems
• High attention to detail ensuring quality and rigor in solutions
• Proficiency with Microsoft Office Suite
• Strong SQL skills with experience creating complex queries
• Expertise in Power BI for creating clean, visually compelling charts and dashboards
• Working knowledge of Power Automate
• Understanding of mortgage industry processes, including the loan lifecycle
• Clear and effective verbal and written communication skills
• Ability to work collaboratively as a team player

Preferred Qualifications

• Bachelor’s degree in Business, Statistics, Computer Science, Mathematics, or related field preferred
• 3+ years of experience as a Business Data Analyst, Data Engineer, or equivalent role
• Experience with Snowflake data platform
• Prior experience in retail mortgage analytics highly desired

Physical Demands

• Ability to sit or stand for prolonged periods
• Occasionally stoop, bend, kneel, crouch, reach, and twist
• Lift, carry, push, or pull up to 10 pounds
• Operate office equipment requiring repetitive hand movement and fine coordination
• Normal vision and hearing with or without correction

Work Authorization

• Must be authorized to work in the United States and able to verify identity and employment eligibility

Compensation & Benefits

• Competitive salary starting at $90,000 depending on experience and location
• Full-time benefits including health, dental, and vision insurance
• Retirement plan with company contribution
• Parental leave
• Mental health and wellness benefits
• Generous paid time off
• Annual bonus plan for eligible non-sales roles
• Sales incentive pay for sales roles

Compensation may vary based on geographic location, experience, education, and skill level. Remote pay ranges are localized between 80% and 100% of the posted range depending on employee location.

This job description is not exhaustive and may be updated to meet the needs of the organization.