Financial Data Analyst
Los Angeles, CA | On-site role
OVERVIEW
Westlake Financial, one of the largest and most innovative auto finance companies in the United States, is seeking a Business Intelligence Analyst to be part of the Business Strategy & Analytics group. As a Business Intelligence Analyst, you will gain mastery over Westlake’s loan origination and servicing data, and collaborate with IT to deploy this data in an easy to use way for all analysts in the company. You will also develop new reporting tools and maintain existing reports in Tableau, automated Excel reports, and more.
This person will support senior management with regular summaries and synopses of reports related to Westlake and its subsidiary companies and promote data and business intelligence best practices throughout the company.
RESPONSIBILITIES
- Update Data Warehouse tables to serve the evolving needs of other analysts and management through the company
- Troubleshoot and correct any data integrity issues, including making operational recommendations to prevent the problem from re-occurring
- Develop and monitor reports relied on by senior management
- Maintain multiple report generation and automation tools and streamline these where possible.
- Prepare and present executive summaries and recommendations to senior management.
- Take ownership of business processes and offer improvements supported by data.
- Collaborate with Data Science and Machine Learning to deliver clean data for use in advanced predictive modeling.
- Perform all other duties as required in support of our company strategic initiatives.
ESSENTIAL EXPERIENCE AND SKILLS
- Bachelor’s Degree in math, science, business, or another technical field
- Previous work experience (1-3 years) in a related field
- Strong knowledge of Structured Query Language (SQL) queries
- Proficient in Microsoft Excel (Pivot Tables, VLOOKUP, OFFSET, AVERAGEIF, INDEX, MATCH, etc.)
- Organized and has efficient time management skills
- Adaptable and thrives in a fast-paced, challenging environment
- Demonstrated track record of taking ownership and problem-solving
PREFERRED EXPERIENCE AND SKILLS
- Expert Excel skills including macros and VBA
- Experience automating queries and designing Data Warehouse tables
- Tableau business intelligence platform
- BIRT reporting platform
- Knowledge of business strategy, operations, and the auto finance industry
What’s the expected pay for this role?
- $60,000 to $90,000 USD per year.
- The exact starting compensation to be offered will be determined at the time of selecting an applicant for hire and will be dependent on a wide range of factors, including but not limited to geographic location, skill set, experience, education, credentials, and licensure when applicable
What do we offer?
- Medical, Dental, and Vision benefits
- Life Insurance, Flexible Spending Account
- 401K matching
- Employee Stock Ownership Program in a $14.2 Billion Company, plus company matching
- Wellness Program, Daily Team Exercises
- Westlake University, Certification Programs
- Career Path Opportunities
- Discounts on Parks, Museums, Movie Tickets, and Attractions
- AT&T Wireless Discounts
- Employee Loan Assistance
- Paid Vacations Days
- Paid Sick days
- Paid holidays
- Rental Car Discounts
- Dell Member Purchase Program
- UKG Wallet – pay advance
Acknowledgement
We will consider for employment all qualified Applicants, including those with Criminal Histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance.
We are an equal opportunity employer and do not unlawfully discriminate in employment. No question on this application is used for the purpose of limiting or excluding any applicant from consideration for employment on a basis prohibited by local, state, or federal law. Equal access to employment, services, and programs is available to all persons. Those applicants requiring reasonable accommodation to the application and/or interview process should notify a representative of the organization.