Financial Analyst

Ascendum Solutions; Monroe (OH); On-site; USD 70,000 - 90,000; Full time

Job summary

Ascendum Solutions in Monroe, OH is seeking an analytics professional to conduct deep-dive KPI analyses for e‑commerce. You will partner with Merchandising, Marketing and Site Experience to build reporting tools and drive the digital plan.

Responsibilities include creating daily and periodic dashboards, analyzing logistics and sales performance, and delivering insights with action plans to optimize revenue and forecast accuracy for senior leadership.

Qualifications

• 3+ years experience in eCommerce, merchandising, financial reporting, planning or forecasting.
• Proficient with MS Excel and Microsoft Office.
• Experience with SQL and/or Python for data analysis.
• Experience in retail environments is preferred.
• Shows high attention to detail and strong organizational skills.

Responsibilities

• Create daily/period/yearly digital tools, reports and analyses for KPI performance against plan.
• Serve as point of contact for e‑commerce logistics and financial questions.
• Design and monitor reports to analyze logistics data and identify trends.
• Prepare reports for monthly executive reviews and Open to Buy.
• Develop insights and action points for senior leadership on sales and costs.
• Generate insights for performance vs budget/forecasts and identify trends.
• Conduct deep-dive analytics to optimize the digital shelf catalog.
• Collaborate with stakeholders across digital channels to provide performance insights.
• Assess risks/benefits of strategies including email, promotions and coupons.
• Deliver ad hoc analyses and build forecasting templates.
• Create/update templates for period/quarterly reports for management.

Skills

eCommerce experience

Attention to detail

Organizational multi-tasking

Retail experience

Tools

MS Excel

SQL

Python

Job description

Responsible for conducting deep dive analysis surrounding KPI e-Commerce metrics. Partner with various leaders within the organization including Merchandising, Marketing, and Site Experience to build reporting tools and analysis to drive the digital plan. Evaluate performance results to provide recommendations.

Required Skills

• 3+ years experience in one of the following areas: eCommerce, merchandising, financial reporting, planning, forecasting
• Proficient in Microsoft Office, with an emphasis on MS Excel
• Proficient in SQL and/or Python
• Prior experience working in retail
• Excellent attention to detail
• Strong organizational multi-tasking skill

ESSENTIAL JOB FUNCTIONS

• Create daily / period / yearly digital business tools, reports, and analysis for KPI's against plan to determine risk and opportunity
• Serve as point of contact for e-Commerce logistics to answer financial questions within the department
• Design and monitor reports used to analyze logistics data and adjust based on trends and future looking opportunities
• Manage, prepare, and coordinate reports used for executive monthly business review and Open to Buy detailing e-Commerce performance
• Develop and maintain digital analysis with insights, recommendations, and action points to senior leadership, including sales and cost
• Generate actionable insights for e-Commerce performance versus budget, target and forecasts and identify recent trends
• Perform deep dive analytics for the digital shelf to ensure optimization across the catalog
• Partner with key stakeholders within the digital arena to deep dive and provide insights on performance of their areas
• Monitor and measure risks and benefits associated with various business strategies including email strategies, couponing, promotional impacts
• Assist and provide recommendations based on analysis and strategize with various business owners and management to continually maximize revenue growth
• Deliver daily ad hoc business analysis
• Construct various tools and models to ensure accurate forecast process
• Design, update and create new and existing templates for the variety of reports used to summarize period and quarterly results for financial and executive management teams
• Articulate recommendation and strategies related to key stakeholders as well as executive management
• Must be able to perform the essential job functions of this position with or without reasonable accommodation