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.
Location: Remote OK (Hybrid two days a week if you reside within 31 miles of Tustin, CA)
Salary up to $80kResponsibilities
- 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.
- 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.
- Bachelor’s degree in business, Statistics, Computer Science, Mathematics or a related field preferred.
- Experience working with Power BI (must have).
- 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.
- Distributed Retail Mortgage experience highly desired.
This job may require frequent sitting or standing for long periods of time. This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned in order to meet the needs of the organization. Work Authorization:
Must be able to verify identity and employment eligibility to work in the U.S.
[EOE/M/F/D/V. Drug-free workplace.] 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 accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift up 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.