The Financial analyst is responsible for general analysis and reporting of operational and financial data for Financial Planning & Analysis (FP&A) and Supply Chain and Inventory Management (SCIM) needs.
Essential Job Functions & Responsibilities
Maintain and improve upon various complex Excel based analytical models to support operational decision making. Ensure models align with and support current priorities and goals.
Establish well thought out and robust Excel models to address defined analytical needs; provide insights from the models that improve SCIM efficiency and cost effectiveness.
Identify meaningful key performance indicators (KPIs) and investigate variances on these metrics to validate effectiveness and efficiency of SCIM decisions.
Compile and analyze sales, returns, and purchase history patterns to inform sourcing strategies and order quantity decisions.
Compile complex and detailed sales and earned revenue packages for books divisions and execute ad-hoc analyses.
Create and run COGNOS queries for recurring and ad-hoc reporting that requires an understanding of the attributes and relationships within each database table and how data relates across external systems.
Maintain clear and very detailed procedures so they may be reliably replicated.
Perform miscellaneous job-related duties as assigned.
Source and reconcile data from multiple source systems to create meaningful analyses.
Collaborate with others to improve data management processes and tools.
Other duties, as may be assigned
Qualifications & Education
Bachelor’s degree required, preferably in Finance.
Minimum of 8 years of directly related work experience.
Excellent computer skills and software proficiency, including MS Office (Word, Excel, PowerPoint) and Outlook.
Advanced Excel knowledge and high comfort level in creating pivots and utilizing “vlookup”, “hlookup”, “sumif”, and “sumproduct” functions