This job has expired, please see additional jobs below
Data Reporting Analyst
Union Bank
San Diego, CA, United States
Job Details - this job has expired, please see similar jobs below
The HMDA Data Reporting Analyst provides data analysis support to HMDA Data Management team to make sure there's accurate accounting of HMDA LAR records and assist with preserving the scrubbed LAR data. You will support the senior data reporting analyst and management by executing and maintaining key data monitoring and analysis reports that identify data anomalies, missing records, monthly volume trends and management of monthly HMDA data files set up. You will also maintain effective record keeping database files for monthly reconciliation loans, total LAR volume, geo-coding exceptions files and various business lines loan tracking reports. Extract weekly files from Empower and update files in CRAWiz. Conduct complex HMDA data analyses to provide information that measures data errors or related HMDA data metrics. Provide summary reports to management and other business lines as needed.
Major Responsibilities:
• Review weekly and monthly HMDA LAR files for accurately and keep track of missing loan records.
• Develop and maintain critical data reporting files for accurate tracking of each business lines volume as well as overall HMDA file volume.
• Lead weekly Empower LAR extract query, run batch geo-coding in CRAWiz and clearing of exceptions through manual geo-coding, monthly management of reconciliation file process, maintaining HMDA LAR monthly tracking reports, assumption, purchased, and repurchased reports.
• Prepare summary reports, extract data, data entry into spreadsheets, employing complex and dynamic filters and formula; developing and updating work procedures, versioning control, and validating data for accuracy.
• Under guidance, analyst will also be responsible for updating HMDA LAR file in CRAWIz with scrubbed data and solve CRAWiz issues with the vendor.
• Do you have a comprehensive knowledge of HMDA data and experience and familiarity with CRAWiz file management process?
• Can you assist in automating reports where feasible in order to facilitate a scalable infrastructure?
• You will be able to make recommendations to management on improvements for report content and/or process and enhance existing reports with more meaningful metrics, and streamlining current business processes.
Qualifications
• We prefer a Bachelor’s degree or 2+ years of direct work experience with database management and data analysis/reporting.
• Are you experienced with SQL and/or Microsoft Access including understanding and running advanced queries and modifying as needed or advanced proficiency and understanding of Microsoft Excel queries and advanced formulas?
• You should have at least 2 years of experience with HMDA data and CRA Wiz, along with 3+ years of related work in mortgage or consumer lending.
• Must be detail-oriented and have strong organization skills and capable of being working independently.
• Can you understand requirements to maintain a secure and accurate data environment?
• Strong interpersonal and communication skills.
• You should be capable of managing your time and working under time constraints. Juggle multiple tasks/projects.
• We need someone who loves to use analytical skills, sound judgment and work effectively with peers and business line partners.
The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.
We are proud to be an Equal Opportunity / Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives, and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate in employment decisions on the basis of any protected category.
A conviction is not an absolute bar to employment. Factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered in all employment decisions. Additionally, it's the bank's policy to only inquire into a candidate's criminal history after an offer has been made. Federal law prohibits banks from employing individuals who have been convicted of, or received a pretrial diversion for, certain offenses.