First Republic Bank

Returning Candidate?

Data Analyst

Data Analyst

Job Locations 
US-CA-San Francisco
Credit Administration and Approval

More information about this job



Responsible for the production of reports and dashboards related to the bank’s loan portfolio. Assist other team members in research and analytics, develop databases, and become a key contributor of loan data at the portfolio level





  • Automate reports and create dashboards using SQL Server and Tableau
  • Produce Ad Hoc reports for multiple departments
  • Develop an understanding of data fields, sources, and business logic. Factor in relevant data to spot patterns and trends
  • Work with Accounting, Finance, Loan Servicing, and Financial Reporting on data reconciliation and variance analysis
  • Develop new/enhanced reporting methods and documentation. Drive process improvements to strengthen controls, improve data quality, and reduce production time.




  • Bachelor’s degree or higher with an emphasis on quantitative and programming skills
  • Detail oriented with excellent time management
  • SQL Server experience preferred
  • Intermediate Excel skills including use of shortcuts
  • Experience with Tableau and MS Access Forms a plus
  • Basic understanding of loan products
  • Can-do attitude
  • Furthers First Republic Bank culture and values



Share on your newsfeed