Summary:

The Data Business Analyst will provide data and analytical support to the Senior Leadership of Freedom Mortgage’s Correspondent line of business. Position will be responsible for data management, review, and reporting. Database knowledge and management of large amounts of data is required. The Data Analyst will assist with developing and supporting department operational processes and initiatives and will work with our IT partners to ensure a high level of data integrity and access to that data. Ensure efficient and effective execution, manage prioritization, and appropriate communication with stakeholders. Participate in process improvement activities at the direction of management.

Essential Job Functions:

• Develop and Maintain all reporting needs.

• Gathers and analyzes data.

• Prepares reports and track results including being able to identify and address trends.

• Develop and maintain Smart Sheet based projects including dashboards and data sets.

• Perform data analysis utilizing multiple tools and platforms including Snowflake, Access, PowerBI, and API data pulls.

• Prepares ad hoc data requests.

• Works on special projects as requested.

• Work closely with IT business partners in the development of and access to the corporate data (data warehouse) and other data stores as needed.

• Will work with business and IT partners to optimize and automate business processes and reporting.

• Assist in building and maintaining Data analytics.

• Works closely with other staff.

• Ensure status / timelines are communicated and met, escalating issues to Sr. Management as needed.

• Assisting and supporting data mapping projects, rules engine maintenance and development.

• Maintain regular and punctual attendance.

Other Related Duties:
Performs other related duties as assigned.

Supervisory Responsibilities:

This position is an individual contributor.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required.

• Strong communication skills both written and verbal.

• Self-motivated and ability to multi-task and manage / prioritize workload.

• Demonstrated strong leadership skills.

• Strong business acumen, time management and priorities management skills.

• Knowledge on analytical/problem solving skills.

• Extensive experience with Power Point, Excel, PowerBI, Access, SQL, Snowflake is required.

• A strong understanding of employing Excel formulas and using VBA.

• Proficiency in other programming/scripting languages a plus.

• Experience with data management, data mapping, extracting data, controls around data accuracy and building data control reports is a must.

• Previous experience working in Information Technology, building data warehouse information, data mining is necessary.

• Previous knowledge of mortgage origination and servicing is extremely helpful.

Education and/or Experience:

• Bachelor’s Degree (B.S.) from a four-year college or university.

• Minimum 3 years of prior relevant experience.

• Mortgage industry experience required. Experience with mortgage servicing and origination systems a plus.

Certificates, Licenses, Registrations:

None required.

Work Complexity:

Problems and issues faced are general, and may require understanding of broader set of issues but typically are not complex. May require familiarity with the financial/mortgage (or job-specific) industry. Problems require understanding of other job areas. Problems are typically solved through drawing from prior experiences, with analysis of the issue.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work is normally performed in a typical interior office work environment which does not subject the employee to any hazardous or unpleasant elements. The noise level in the work environment is usually moderate.

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. While performing the duties of this job, the employee is frequently required to sit and talk or hear. The employee is occasionally required to stand; walk; use hands to finger, handle, or feel; and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds.

Equal Employment Opportunity:

The company is committed to providing equal employment opportunities to all employees and applicants without regard to race, ethnicity, color, sex, marital status, sexual orientation, gender identity or expression, pregnancy, religion, national origin, age (40 and over), disability, military status, genetic information, or any other basis protected by applicable federal, state, or local laws.

Americans with Disabilities Act:

Applicants as well as employees who are or become disabled must be able to satisfactorily perform the essential job functions of the position either with or without reasonable accommodation. Applicants as well as employees are encouraged to meet with Human Resources as the organization shall review reasonable accommodations on a case-by-case basis in accordance with applicable law.

Job Responsibilities:

The statements reflect the general duties and responsibilities considered necessary to perform the essential functions of the job and should not be considered as an all-inclusive list of all the work requirements of the position. The company may change the specific job duties with or without prior notice based on the needs of the organization.