|
|
 |
 |
Financial Reporting and Data Analyst
Candlewick Press seeks an experienced financial reporting and data analyst to join the Finance team. The analyst is responsible for loading and validating sales data files, working with SQL and Access databases, preparing summary sales and financial reports for various constituents, preparing sales forecast templates, analyzing financial and sales data in order to assist in budget preparation, and running ad hoc data analyses. The analyst will work closely with the Senior Business Analyst and the CFO and also have the opportunity to work with many operational groups across the company. Very strong Excel and database skills, an understanding of financial/accounting data, and superior attention to detail are essential.
Responsibilities:
- Prepare and analyze a standard set of monthly sales, inventory, commission, and gross margin excel reports
- Import monthly sales data files into a SQL database and interface with distributors and vendors to ensure accurate and timely sales data file submissions to Candlewick.
- Review and reconcile data from each reporting source
- Work with accounting manager to ensure accuracy of sales data import into accounting system
- Work with CFO and head of royalties to validate and prepare sales data for import into royalties system
- Maintain documentation of back-up for all reporting
- Provide other sales reporting:
- Run daily and weekly reports of sales results for wide distribution
- Produce ad hoc sales and other data analysis upon request from all groups across the company
- Participate in budgeting and forecasting process
- Maintain detailed marketing promotion annual budget in coordination with marketing department and update each month with actual data
- Prepare title by title sales forecasts with CFO and VP Sales
- Identify and analyze expense areas as needed in preparation of periodic annual budget updates
- Assist in the calculation and analysis of year-end reserves for slow moving inventory, unearned author advances, and sales returns
- Perform other tasks as needed
Required Experience and Skills:
- Exceptional Excel data manipulation skills as well as extensive experience with Access/relational databases
- Familiarity with SQL a plus
- A minimum of three years' experience with financial reporting and analysis
- Proven ability to work independently and meet deadlines with excellent attention to detail
- Strong analytic, inter-personal, problem solving and communication skills
- Bachelor's degree, preferably in accounting or business
- Experience in publishing helpful
This is a full time, in-house position.
|
To Apply: submit a resume and cover letter (noting salary requirements when applying for a full-time position) via e-mail to careers@candlewick.com, referencing "Financial Reporting and Data Analyst"
|
back to top
|
|
|
|
|
