Note: The job is a remote job and is open to candidates in USA. New American Funding is a company focused on data-driven decision making in the mortgage industry. They are seeking a Mortgage Data Analyst II to design and develop automated reports, analyze large datasets, and drive stakeholder engagement through effective data insights.
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
- 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
- Own the design, development, and maintenance of ongoing metrics, reports, analysis, dashboards, etc. to drive stakeholder engagement
- Attention to details that involve reading/accessing intricate coding or technical structure
- Understanding of the mortgage industry including the life cycle of a loan
Skills
- Retail Mortgage industry experience
- 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
- 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
- Own the design, development, and maintenance of ongoing metrics, reports, analysis, dashboards, etc. to drive stakeholder engagement
- Attention to details that involve reading/accessing intricate coding or technical structure
- Understanding of the mortgage industry including the life cycle of a loan
- Must be able to verify identity and employment eligibility to work in the U.S
- 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
Benefits
- Health, dental & vision
- Retirement with company contribution
- Parental leave
- Mental health & wellness benefits
- Generous PTO
- Sales incentive pay for most sales roles
- An annual bonus plan for eligible non-sales roles
Company Overview