Senior Financial Data Analyst - Medical School Financial Reporting
Washington University in St. Louis
Location: St. Louis, Missouri
Internal Number: JR63538
Design, develop, document, maintain and operate core financial business processes and insure data collected or reported is of the highest quality for decision makers at all levels within the School of Medicine.
Primary Duties & Responsibilities
Designs data files, processes, menus, input/output forms and reports to support core financial business operations. Provides documentation, maintenance and support of these processes by managing the system or providing support to others responsible for managing the system.
Provides quality control of all data involved with business process assigned. Must have a very good understanding of the majority of the data used within the department and assist others with using the data when required.
Provides leadership and initiative for resolving issues and questions regarding the functionality of the reporting and/or data system and its associated interfaces.
Meets with customers to evaluate project request which maybe for a new data collection and reporting system or a maintenance request for an existing system. Requests can be as complex as a budget and financial planning tool to a simple request for listing YTD expense for the last 5 years for a given department. May make decisions on best solution to apply.
Schedules and manages the delivery of data, reports or updates to systems assigned. Maybe assigned processes that will update the Universityâ™s general ledger system and require very tight deadlines throughout the fiscal year.
Assists customer with establishing good controls for data going into the system as well as coming out of the system. Maybe required to reconcile departmental reports to Deanâ™s reports on systems assigned.
Provides technical support in areas of expertise, loads software they support and assists with managing the security of data within data files and reports on the network.
Six or more years of business experience working with Adaptive Insights, Workday, WebFocus, Hyperion Financial Management, Crystal Reports, Microsoft Access, Microsoft Visual Basic or Microsoft SQL (or any comparable tools) and proven experience to extract, transform, load and present data to a variety of formats or databases.
Strong knowledge of Microsoft Excel especially setting up formulas and graphs, importing data from TXT files or mapping data to worksheets within a workbook. Some knowledge of how Excel can be used to pull in data directly from MS SQL or via connections to other software products like Hyperion Enterprise.
Strong knowledge of financial data and basic concepts such as overdrafts, variance analysis, trend analysis, CAGR formula.
Good knowledge of Microsoft Word and Email.
Excellent oral and written communication skills with the ability to provide clear, accurate, organized presentations of data.
Excellent problem solving skills and creative ways to discover solutions.
Excellent ability to follow detail instructions and handle mundane operations.
Excellent ability to work in teams when required.
Ability to work independently, deal with frequent interruptions, handle multiple assignments, handle occasional pressured deadlines, work overtime when needed and switch priorities, sometimes daily.
Excellent interpersonal skills with the ability to interact with diverse groups of people at all levels of the organization.
BS degree in Business Administration or Information Systems is preferred, but will consider years of experience and some college courses in business and information systems as the focus.
$68,200.00 - $116,600.00 / AnnuallyThe 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.
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.
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.
Washington University is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration without regard to an individualâ™s sex, race, color, religion, age, disability status, protected veteran status, national or ethnic origin, gender identity or expression, sexual orientation. Women, minorities, protected veterans and the disabled are strongly encouraged to apply.
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.
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.
Washington University in St. Louis, a medium-sized, independent university, is dedicated to challenging its faculty and students alike to seek new knowledge and greater understanding of an ever-changing, multicultural world. The University offers more than 90 programs and almost 1,500 courses leading to bachelor's, master's and doctoral degrees in a broad spectrum of traditional and interdisciplinary fields, with additional opportunities for minor concentrations and individualized programs. The faculty is composed of scholars, scientists, artists and members of the learned professions. They serve society by teaching; by adding to the store of human art, creativity, understanding, and wisdom; and by providing direct services, such as health care.