The KSOM Finance Department is seeking a Business/Financial Data Analyst to join its team.Â The Business/Financial Data Analyst will be responsible for financial modeling/reporting/analysis, budget/forecasting, data analysis and problem solving.Â The Business/Financial DataAnalyst will perform extensive data reconciliation, consolidation, and analysis for large quantities of financial data to create financial reports.
The specific accountabilities of this role include, but are not limited to:
Assist with monitoring financial activity at the school including budgets, reconciling accounts, forecasting/projections, and month/year-end process management.Â Identifies problems or trends and evaluates for solutions.
Develops and administers budgets for recruitment funding at the school. Tracks and reports on funding and expenditures.
Evaluates and analyzes school-wide financial data; produces regular and ad-hoc and regular monthly financial reports. Evaluates and analyzes reports and data. Â Develops conclusions and provides recommendations. Prepares briefings and presentation materials as needed.
Reconciles financial data from multiple sources and makes correcting adjustments to ensure alignment.
Liaison with programmers and departments to build reports and applications in KSOMâs BI reporting and applications.
Performs other duties as assigned or requested.
Preferred Skills and Experience
Preferred Education/Experience: Bachelorâs degree with at least 3-5 years of financial analysis experience and advanced proficiency in Microsoft Office applications especially Excel (pivot tables and charts, formulas, data validation), Access (creating tables, relationships/joining, queries, forms and reports), and PowerPoint.Â Other skills include:
Strong organizational, written/oral communication, and relationship-building skills.
Prior experience in financial and budget reporting.
Ability to follow through with assigned tasks within established time-frames and with minimal supervision in a fast paced environment; exceptional focus on attention to detail and accuracy
Knowledge of government and fund accounting, clinical revenue, database, data analytics and university financial systems preferred.
Minimum Education: Bachelor's degreeMinimum Experience: 1 yearMinimum Field of Expertise: Proficient PC skills. Working knowledge of databases, spreadsheets, word processing and statistical software programs. Knowledge of business statistics and data analyses techniques. Ability to manage and analyze data. Strong analytical thinking and problem solving skills.
USC is the leading private research university in Los Angeles—a global center for arts, technology and international business. With more than 47,500 students, we are located primarily in Los Angeles but also in various US and global satellite locations. As the largest private employer in Los Angeles, responsible for $8 billion annually in economic activity in the region, we offer the opportunity to work in a dynamic and diverse environment, in careers that span a broad spectrum of talents and skills across a variety of academic and professional schools and administrative units. As a USC employee and member of the Trojan Family—the faculty, staff, students, and alumni who make USC a great place to work—you will enjoy excellent benefits, including a variety of well-being programs designed to help individuals achieve work-life balance.