Returning Candidate?

Junior Business Analyst

Junior Business Analyst

Job ID 
Job Locations 
US-CA-San Diego
Job Type 
Regular Full-Time

More information about this job


BofI Federal Bank [NASDAQ: BOFI] with over $8 billion in assets, is one of the fastest growing on-line, branchless banks in the nation and rated top 5 of Internet banks in the country!


  • Develop dashboards to support Deposit Operations in reporting and monitoring functions
  • Create ad-hoc analysis in order to analyze key business issues
  • Utilize expertise to gather pertinent data and perform regression and other statistical analyses to help identify meaningful data relationships, Key Performance Indicators, and Key Risk Indicators
  • Attain deep knowledge of bank databases to retrieve and filter information as needed to support business unit analysis and decision-making
  • Recognize opportunities to automate processes for optimization and efficiencies
  • Identify and recommend data improvement opportunities
  • Support customer data integration efforts across all lines of business with hands-on technical involvement in testing, scrubbing, and cleansing of data
  • Develop, optimize, and maintain queries in MS SQL Server Management Studio 2008/2012
  • Create advanced reporting and analysis through Microsoft SQL Server Report Builder

Key Skill Sets or Knowledge Requirements:

  • Microsoft SQL Server 2008 server side development including (SSIS, SSRS, SSMS)
  • Ability to write SQL queries to answer the business ad hoc requests
  • Proficient in creating SSRS/SSIS package, API programs, and procedures
  • Strong Excel skills
  • Experience creating Tableau dashboards
  • Excellent written and oral communications
  • Highly analytical with strong attention to detail
  • Self-directed and able to flourish in a fast-paced environment
  • Experience with marketing automation and web analytics software packages
  • Strong logical thinking, problem solving and decision making skills

Desired Career Experience & Education Requirements:

  • 1+ year in a Junior Business Analyst role
  • Competent in creating complex queries involving multiple-table joins, union, sub-queries, CTE, temporary tables, outer apply/cross apply
  • Bachelor's Degree in Business Administration, Statistics, or Mathematics



Job Functions & Work Environment:


While performing the duties of this position, the employee is required to sit for extended periods of time. Manual dexterity and coordination are required while operating standard office equipment such as computer keyboard and mouse, calculator, telephone, copiers, etc.


The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.



Equal Employment Opportunity:


BofI Federal Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex , gender identity and expression, sexual orientation, national origin, ancestry, citizenship status, uniform service member and veteran status, marital status, pregnancy, age, protected medical condition, genetic information, disability, or any other protected status in accordance with all applicable federal, state and local laws. Candidates must possess authorization to work in the United States.