Financial Analyst (HFM / Smart View Specialist)
Brea, CA, US
Accounting / Finance
Bachelors Degree
Full Time, Temporary
80.00
Experienced (Non-Manager)
On-site
Medical Devices and Supplies
First Shift (Day)
Brea, CA, US
80.00
Experienced (Non-Manager)
Full Time, Temporary
Medical Devices and Supplies
On-site
Accounting / Finance
Bachelors Degree
First Shift (Day)
Job details
Financial Analyst (HFM / Smart View Specialist)
Brea, CA (Onsite)
8am-5pm Monday-Friday/Temp-to-Hire
Payrate: $60 – $90 per hour (DOE)
Position Overview
We are seeking an experienced Financial Analyst with strong Oracle HFM and Smart View expertise to support financial reporting, month-end close, and complex Excel-based analysis in a high-volume enterprise environment.
This role requires an advanced Excel user who is comfortable working with large, multi-tab financial models, complex formulas, and high-volume Smart View data intersections, combined with strong accounting knowledge, accuracy, and discipline.
Key Responsibilities
HFM / Smart View Reporting
- Perform bi-annual HFM write access reviews and documentation
- Maintain Smart View financial reporting processes
- Support month-end close using Smart View and data warehouse tools
- Work with large HFM data intersections and consolidation structures
Advanced Excel Modeling
- Build and maintain large Excel models (80+ tabs, high-volume data sets)
- Work with thousands to hundreds of thousands of rows
- Use advanced formulas including SUMIFS, COUNTIFS, VLOOKUP, HLOOKUP
- Apply nested logic, text functions, conditional formatting, and HFM functions (HSGETVALUE / HSSETVALUE)
- Navigate and manage complex workbooks efficiently
Financial & Month-End Support
- Support intercompany geo and product line assignments
- Assist with trade distribution and margin reporting processes
- Execute repetitive month-end tasks with high accuracy
- Prepare documentation for monthly close cycles
Compliance & Reporting
- Support quarterly compliance testing and reporting
- Collect and validate data from global and government sources
- Update Excel, PowerPoint, and audit documentation
- Ensure accuracy for audit-ready reporting
Process Improvement
- Improve and maintain financial models and reporting tools
- Document standard work procedures
- Support enhancements to legacy Excel processes
Required Qualifications
- Strong hands-on experience with Oracle HFM and Smart View
- Advanced Excel skills with large-scale financial models
- Strong understanding of:
- Accounting fundamentals
- Intercompany accounting
- Financial reporting & consolidation
- Accounting fundamentals
- Experience with large datasets and enterprise reporting environments
- Strong attention to detail and accuracy
- Excellent documentation and communication skills
Send your resume to daid740@kellyservices.com Or call Daisy at 562-471-7322
10229945
I want more jobs like this in my inbox.
Get a complete career fit with Kelly®.
You’re looking to keep your career moving onward and upward, and we’re here to help you do just that. Our staffing experts connect you with top companies for opportunities where you can learn, grow, and thrive. Jobs that fit your skills and experience, and most importantly, fit right on your path of where you want to go in your career.About Kelly
Work changes everything. And at Kelly, we’re obsessed with where it can take you. To us, it’s about more than simply accepting your next job opportunity. It’s the fuel that powers every next step of your life. It’s the ripple effect that changes and improves everything for your family, your community, and the world. Which is why, here at Kelly, we are dedicated to providing you with limitless opportunities to enrich your life—just ask the 300,000 people we employ each year.Kelly is committed to providing equal employment opportunities to all qualified employees and applicants regardless of race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or any other legally protected status, and we take affirmative action to recruit, employ, and advance qualified individuals with disabilities and protected veterans in the workforce. Requests for accommodation related to our application process can be directed to the Kelly Human Resource Knowledge Center. Kelly complies with the requirements of California’s state and local Fair Chance laws. A conviction does not automatically bar individuals from employment. Kelly participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.
Kelly may use AI-powered tools during the recruitment and hiring process. For full details, including how Kelly uses AI, your rights, and how to request a reasonable accommodation, visit the Recruitment Artificial Intelligence Notice.