Data Business Analyst
| Company | First American |
|---|---|
| Location | Des Moines, IA, USA, Austin, TX, USA, Raleigh, NC, USA, East Lansing, MI, USA, Richmond, VA, USA, Chicago, IL, USA, Fort Mill, SC, USA, Tallahassee, FL, USA, Columbus, OH, USA, Minneapolis, MN, USA, Atlanta, GA, USA |
| Salary | $57000 – $75975 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Junior, Mid Level |
Requirements
- One to five years of recent experience as a data analyst or another related title in a financial or banking environment
- Formal SQL query language training classes or certificate program
- Strong proficiency with the SQL query language, preferably Microsoft T-SQL
- Strong proficiency with the Microsoft Office Suite package including an expert knowledge of Excel
- Demonstrated ability to effectively communicate with both internal and external customers, peers, and management
Responsibilities
- Develop operational, management, and exception reports using T-SQL in a controlled, production environment
- Create ad-hoc reporting for individual regulatory requests and Stored Procedures for production reporting
- Interpret regulatory requirements into actionable specifications
- Mine, analyze, and interpret data from multiple sources
- Work closely with multiple business units to define requirements and validate report results
- Perform tests for validity, reasonableness, and accuracy through standard methods and application of specific subject-area knowledge
- Perform regular maintenance and testing on production reports
- Assist in developing documentation of existing reports, data dictionaries and reference documents
Preferred Qualifications
- Experience with Mortgage Servicing and/or familiarity with MSP as a mortgage servicing platform is preferred