Mortgage Data Analyst II

Mortgage Data Analyst II - Retail Lending & Loan Lifecycle

Must have Retail Mortgage industry experience

Location: Remote (If living within 31 miles of Santa Ana, CA or Austin, TX will need to be able to work 4 days on-site)

Salary: starting at 90K D.O.E. + Full Time Benefits

Actual compensation may vary from posting based on geographic location, work experience, education, and/or skill level.

Position Summary: Are you excited to analyze large datasets and help business owners make data driven decisions? Are you excited to design and develop automated reports using industry leading tools like Power BI? At New American Funding we know the importance of utilizing quantitate insights and actionable reports to drive our business; and we are looking for a highly talented Business Data Analyst to join our BI and Analytics team and help us become a more data driven company.

Identity Verification checks are in place throughout the Candidate journey to prevent candidate fraud

Responsibilities

• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive stakeholder engagement.

• Extensive experience in building Power BI Dashboards using Complex DAX Functions / merging multiple data sets/data sources.

• Strong SQL skills in analyzing, implementing/writing complex SQL scripts for designing critical data sets, trace data quality issues and should be proficient in data cleansing.

• Strong analytical and problem-solving skills, and attention to details.

• Possess the ability to identify, analyze, and resolve problems logically and systematically.

• Strong verbal and written communication skills; ability to present complex information in an easy-to-understand manner with clear recommendations based on data insight.

• Can function collaboratively as part of a fast-paced, customer-oriented team, perform effectively, and demonstrate willingness to support the team on all levels to get the job done.

• Ability to deal with ambiguity and competing objectives in a fast-paced environment.

• Other duties may be assigned.

Qualifications

• Experience independently designing and implementing solutions to complex problems.

• Have attention to detail to ensure the highest level of quality/rigor in solutions.

• Proficiency with MS Office Suite.

• Must be a team player.

• Must have clear and effective communication.

• Strong SQL experience.

• Strong experience in Visualization tools like Power BI to create clean, visually compelling charts that will help understand discoveries and empower others to use data to make key decisions.

• Working knowledge in Power Automate.

• Attention to details that involve reading/accessing intricate coding or technical structure.

• Understanding of the mortgage industry including the life cycle of a loan.

Desired Education/Experience: Bachelor's degree in business, Statistics, Computer Science, Mathematics, or a related field preferred.

Experience working with Power BI.

3+ years of experience as a Business Data Analyst, Data Engineer or equivalent.

Relevant experience as a business analyst, data analyst or related role is a plus.

Working knowledge of SQL and creating complex queries.

Experience with Snowflake.

Retail Mortgage Analytics experience highly desired.

Other Duties: This job may require frequent sitting or standing for long periods of time.

Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S.

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction.

Pay Transparency Disclosure: If based in New American Funding's offices, this role has the annual base salary range stated below.

Job level and actual compensation will be decided based on factors including, but not limited to, individual qualifications objectively assessed during the interview process (including skills and prior relevant experience, potential impact, and scope of role), market demands, and specific work location. The listed range is a guideline, and the range for this role may be modified. For roles that are available to be filled remotely, the pay range is localized according to employee work location by a factor of between 80% and 100% of range. Please discuss your specific work location with your recruiter for more information.

New American Funding offers competitive package of additional benefits, including health, dental & vision, retirement with company contribution, parental leave, mental health & wellness benefits, and generous PTO. New American Funding also offers sales incentive pay for most sales roles and an annual bonus plan for eligible non-sales roles. New American Funding's compensation and benefits are subject to change and may be modified in the future.