Financial Analyst III - Medicine - Hybrid - 140478

The Department of Medicine is the largest department within the UC San Diego School of Medicine, supporting the institution's academic, clinical, educational, and research missions. It encompasses 23 actively managed financial units spanning central administration, a medical residency program, self-supported operating activities, and medical specialties. The Department of Medicine Business Office provides comprehensive financial, operational, and data-driven support for this large and complex enterprise. The team includes financial analysts and accountants, financial support personnel, and data science professionals. Together, they oversee more than $200M in annual financial activity across the Department's non-research activities, the entire Medicine internal control portfolio, and medical personnel operational performance.

Uses professional concepts and organizational objectives to resolve complex issues creatively and effectively. Independently and under supervision, works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. With limited guidance, the position leverages modern data techniques and exercises judgment in selecting methods and techniques, and in evaluating criteria for obtaining results, collaborating with a diverse range of internal and external personnel. Efforts include complex financial analysis, planning, forecasting, and reporting for Departmental financial and operational systems and resources across missions. Applies skills and experience as an independent contributor and collaborative team partner to projects of medium size at all levels of complexity, or to portions of large, multidimensional projects.

Supports the Associate Director of Fiscal Affairs in delivering high-quality financial and operational analysis and reporting. May represent the Associate Director in meetings, presentations, and decision-making activities as delegated. Designs, develops, and proposes creative and innovative solutions for complex financial and operational processes, analytical frameworks, reports, and automation solutions. Evaluates with the Associate Director the prioritization of activities in alignment with team/organizational objectives.

• Seven years of related experience, education/training, OR a Bachelor's degree in related area plus three years of related experience/training.

• Thorough knowledge of finance policies, practices, and systems. Demonstrated knowledge of budgeting and reporting techniques, accounting, and bookkeeping. Applied experience with GAAP, GASB, OMB Uniform Guidance, and IRS pronouncements/directives.

• Ability to independently gather required information to organize, and perform financial analysis assignments. Demonstrated ability to perform financial analysis with limited oversight in a large, complex organizational environment, including organizing data and supporting decision-making.

• Proven ability to effectively present information verbally and in writing in a clear and concise manner. Experience in performing independently and under supervision the preparation and presentation of materials to internal and external stakeholders of varied levels of hierarchy and technical knowledge, translating financial and operational results and guidance as actionable information in a clear, concise, and diplomatic manner that exercises independent judgment and discretion.

• Proven ability using spreadsheet and database software for complex financial analysis, fiscal management, and financial reports. In-depth ability to use multiple spreadsheet and database software tools to gather information for specialized, complex, financial and operational analysis, management, and reporting. Proven ability to propose, design, and implement highly advanced Excel, PowerQuery, and database solutions, utilizing advanced and complex formulas, programming, and other skills, to optimize workflows and deliver actionable insights.

• Proven interpersonal skills with peers throughout the organization; strong service orientation and critical thinking skills; and attention to detail. Proven ability using organizational skills to multi-task in a high volume environment. Demonstrated performance in functioning as a contributing team player, building relationships, and supporting the mentorship of personnel through collaborative and cross-functional experience.

• Ability to adapt to changing priorities. Ability to multitask. Proven ability to successfully perform and manage, independently and under supervision, concurrent, high-volume responsibilities and functions effectively under pressure and with dynamic due dates, expectations, and priorities through multitasking, maintaining detailed and high-quality deliverables that provide actionable information to stakeholders.

• Ability to function as a member of a team. Proven ability to act as a positive, effective, and contributing team member with a strong professional commitment to cultivating collaborative relationships with personnel of diverse backgrounds, levels, and responsibilities, and to providing staff mentorship that sustains a climate of trust and shared purpose.

• Thorough knowledge and understanding of internal control practices and their impact on protecting University resources. Demonstrated experience with IIA/COSO internal control frameworks and applying internal control practices in financial analysis and reporting, including the use of financial systems and reporting tools to monitor and ensure data accuracy.

• Demonstrated working knowledge of financial, budget, and data systems within a complex and multi-disciplinary institution of diverse fund streams. Ability to identify, interpret, and present solutions regarding complicated anomalies.

• Solid understanding of financial and resource planning concepts, as well as how to control organizational budgeting. Knowledge and experience in developing and successfully managing multi-specialty budgets, including identifying variances and presenting and implementing corrections to avoid or reverse deficit conditions.

• Proven ability to effectively present complex financial and operational information both verbally and in writing in a clear and concise manner.

• Experience in identifying optimized analytics, reporting, and process activities for the betterment of the institution, with a focus on the Department's interests.

• Proven action in identifying training and knowledge advancement that lead to improvement or creation of improved analytical processes and activities.

• Intermediate-level experience in the development and analysis of financial reports, including the income statement, balance sheet, and statement of cash flows.

• Knowledge of relevant databases, BI applications, and tools, with an ability to produce high-quality reports and documentation under direction and supervision.

• Lean / Six Sigma Green Belt or above and/or equivalent experience/training.

• Ability or aptitude to understand and develop systems using such programming languages as PowerQuery M-Code, Visual Basic for Applications, and SQL.

• Employment is subject to a criminal background check.

• Occasional evenings and weekends may be required.

• Must be able to work various hours and locations based on business needs.