Senior Financial Systems Analyst - Financial Planning & Analysis

Position Summary
Position serves as lead staff specialist for the financial operations of School level financial allocations, integrations, analysis and special projects. Analyze and document business practices/work flows. Design, implement, and maintain financial related technology solutions and business applications for department by utilizing skills in applications development, project management, and specialized technical knowledge.

Job Description

Primary Duties & Responsibilities

• Leads, directs and oversees School Level financial objectives including, but not limited to:

  o   Allocations - Create, maintain, manage, and analyze financial allocation results.

  o   Planning - Prepare ten year plan, forecasting, and financial models.

  o   Accounting - Review the integrity and quality of general ledger reporting, including the Foundation Data Model and auditing of financial data.

  o   Analysis - Provides recommendations to senior leadership related to results of ad hoc and other special projects as assigned.

  o   Reporting - Gathers data requirements for new reporting needs and tests reports created by the financial reporting team.

• Serves as a liaison with the financial reporting team to support financial planning, reporting and analysis initiatives utilizing various university systems and reporting systems. Responsibilities include supporting departmental team members by designing reports and tools using the most up-to-date University technology. Independently and in collaboration with others, make recommendations for and implement improvements and streamlining of processes and procedures.
• Works with the department Directors and Assistant Directors to development and implement new, or improve existing, reporting and analysis tools.
• Evaluates, reviews and enhances processes that impact the integrity of the data involved in financial allocations and integrations.
• Evaluates, reviews and enhances processes that impact the integrity of the data involved in financial allocations and integrations.
• Creates and maintains foundation data model values while keeping data aligned across the platform.
• Implements strategies for gathering, reviewing and analyzing data requirements.
• Enables process improvement and/or reengineering.
• Ensures financial data, all banking information and cash, as well as other assets, are accounted for by promoting and enforcing University internal controls and maintaining appropriate security access. Implements operational best practices. Ensures all applicable projects, records, reporting and financial activities remain in compliance with legal, regulatory, governmental and/or investor requirements.
• Creates, maintains, manages, and analyzes school level financial allocations for the Medical School. Provides clear and effective reporting to Medical School leadership through financial allocations which accurately execute various School objectives. Assesses and corrects any errors, as encountered. Works with various stakeholders to remediate them, and re-analyzes corrections as needed.
• On monthly, quarterly, and yearly basis, oversees the analysis and validation of the results of the School Level, Medical School financial allocations.
• On a daily basis, monitors the Epic – Workday Integration, assesses any errors, works with various stakeholders to remediate them, and re-analyzes corrections as needed.
• On a monthly basis, analyzes the results of the Epic – Workday Integration
• On a yearly basis, coordinates with all clinical departments to review and update the financial integration mappings
• Leads and manages the use of software development tools to design, develop, maintain and document new and existing models, databases and business applications; implement and maintain complex business rules and logic used in various systems. Consults with users and business analysts to determine system configuration and design, while coordinating activities of the project work utilizing project management skills.
• Manages and/or co-manages various departmental projects in the following areas: reporting (external and internal), budgeting, analysis, accounting system initiatives, internal controls, process improvements, information retrieval and data integrity; incorporate data and ideas in either formal or informal reports, presenting solutions to issues or problems. Projects include full project management lifecycles (scope, definition, requirements, design, development, documentation, testing, implementation, debugging and training).
• Other duties as assigned.

Preferred Qualifications

• Experience in Workday and/or Adaptive.
• Prior experience in higher education.
• Advanced Access or related database knowledge.
• Proficient in Excel, Word, PowerPoint, Tableau
• Master of Business Administrations, Certified Public Accountant a plus.
• Proficient in Excel, with strong background in Macros and Pivot Tables and Word.
• Excellent interpersonal and communications (written and verbal) skills.
• A self-motivated individual driven by challenge with the ability to work independently.
• Capacity for managing multiple projects and priorities. 
• Activity attempts to influence events originates ideas and takes action.
• Ability to meet deadlines with varying degrees of pressure.
• Ability to handle confidential information.
• Strong analytical, problem solving and decision-making capabilities.
• Ability to properly assess pertinent data and develop a framework for effective and practical solutions to complex issues.
• A service-oriented communicator who is a true team player with the ability to forge relationships and bring diverse groups together on difficult accounting reporting and system issues.
• Strong project management skills.
• Ability to manage financial system projects, set priorities and goals, monitor performance against goals and standards and ensure successful project implementation.
• Knowledge of internal controls.
• Ability to streamline/automate transaction processing and recording.
• Ability to work extra hours and recognize the need to do so.

Required Qualifications

• An undergraduate degree in accounting or MIS or four years or more of experience in financial systems analysis, administration and reporting with IBM Cognos or other business intelligence tools and/or budgeting software, or equivalent combination of education and experience.
• Strong knowledge of financial data and related analysis.
• Extensive experience in cube/database design and excellent PC skills (Excel, Access, Word).
• Database experience, (Access, DB2, SQR or SQL a plus).

Grade
G13

Salary Range
$63,900.00 - $109,100.00 / Annually

The salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.

Accommodation

If you are unable to use our online application system and would like an accommodation, please email [email protected]  or call the dedicated accommodation inquiry number at 314-935-1149 and leave a voicemail with the nature of your request.

Pre-Employment Screening
All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.

Benefits Statement
Washington University in St. Louis is committed to providing a comprehensive and competitive benefits package to our employees. Benefits eligibility is subject to employment status, full-time equivalent (FTE) workload, and weekly standard hours. Please visit our website at https://hr.wustl.edu/benefits/ to view a summary of benefits.

EEO/AA Statement
Washington University in St. Louis is committed to the principles and practices of equal employment opportunity and especially encourages applications by those from underrepresented groups. It is the University’s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.

Diversity Statement
Washington University is dedicated to building a diverse community of individuals who are committed to contributing to an inclusive environment – fostering respect for all and welcoming individuals from diverse backgrounds, experiences and perspectives. Individuals with a commitment to these values are encouraged to apply.

Applicant Instructions
When you are ready to apply, creating an account only takes a minute. Your account creates a candidate home page which we will use to communicate with you and allows you to apply for jobs and view your application statuses. The first page of the application offers two “Quick Apply” options. Quick Apply allows you to either use a previous application or create a new application using a resume to populate the work experience and education sections of your job application. If using a resume to populate your application, check to ensure the application fields populated accurately. You may skip the “Quick Apply” page by clicking “Next” at the bottom of the page. Documents may be uploaded in the My Experience section of the application. You also have the option to apply with a LinkedIn feature, which allows you to apply by using your LinkedIn profile to populate some of the job application fields.