Reporting Analyst III

Summary:

The Analyst, Reporting III is responsible for developing complex reporting with an understanding of current business processes and metrics as they relate to the mortgage industry. This includes gathering requirements, analyzing and mapping data, and complex report/database development. Candidate must possess the necessary skills to work in conjunction with end users, mid and senior level management, project managers and IT professionals including database developers and administrators.

Essential Job Functions:

• Performs the research and information gathering necessary to define, design, create, and document business requirements and specifications as it relates to the development of reporting solutions

• Interfaces with business units to define business requirements

• Assists business units with designing and testing reports to solve business needs

• Plays a key role in educating the Business on reporting and analytics solutions

• Assists with technical project management activities as appropriate

• Works well both independently and as a team to define processes, coordinate work, and manage communications across the business

• Develops SQL stored procedures, functions, views, tables and other database objects as defined by business partner requirements and reporting management to support overall corporate objectives

• Maintain and continuously seek to improve existing business partnerships

• Identifies and defines improvements to existing reporting data sources

• Manages and maintains current report catalog including automating manual reports as well as improvements to existing reports

• Creates and maintains documentation regarding reporting and associated data

• Fulfill ad-hoc data/reporting requests as needed

• Maintain regular and punctual attendance

Other Related Duties:

Performs other related duties as assigned.

Supervisory Responsibilities:

This position has no supervisory responsibilities.

Qualifications:

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

• Bachelor’s degree in Business Administration, Business Analytics, Information Systems, Computer Science or related field

• 5 years mortgage or financial services experience

• Advanced skills manipulating data using advanced tools such as SQL, SAS, SQL Developer in a Oracle, DB2, Teradata or similar environment

• Report development experience utilizing SAS, Microsoft SQL Server Reporting Services (SSRS), Tableau, Business Objects, Crystal Reports or similar report development software

• Project management experience preferred

• Ability to juggle and prioritize multiple projects and tasks simultaneously

• Hands on experience gathering requirements, designing and coding new reports, maintaining and enhancing existing reports, as well as designing dashboards

• Must be flexible and comfortable in a fast changing environment where projects, priorities and timelines shift frequently.

Education and/or Experience:

Bachelors Degree from a Four (4) year College or University

Language Skills:

Ability to read, and interpret documents such as policy and procedure manuals, safety rules, operating and maintenance instructions. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization.

Mathematical Skills:

Ability to calculate figures and amounts such as discounts, interest, commissions, and percentages.

Reasoning Ability:

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Work Complexity:

Tasks are multiple and diverse with some interrelationship across processes. Work requires the direct application of a variety of procedures, policies and/or precedents.

Working Conditions:

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. The noise level in the work environment is usually moderate.

Work is normally performed in a typical interior work environment which does not subject the employee to any hazardous elements.

Physical Demands:

• Position requires light physical activity,

• May require that weight be lifted or force be exerted up to 10 pounds.

Equal Employment Opportunity:

Freedom Mortgage 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. Freedom Mortgage Corporation may change the specific job duties with or without prior notice based on the needs of the organization.