Technical Business Analyst

Ascendum Solutions; MIDDLETOWN (OH); On-site; USD 70,000 - 100,000; Full time

Job summary

Ascendum Solutions is seeking a Data & Analytics professional to conduct in‑depth KPI analyses for e‑commerce metrics, partnering with Merchandising, Marketing, and Site Experience teams. You will build reporting tools, evaluate performance, and provide actionable recommendations to drive the digital plan.

Responsibilities include creating dashboards, supporting Open to Buy, and delivering insights to senior leadership.

Qualifications

• Minimum 3 years in eCommerce, merchandising, financial reporting, planning or forecasting.
• Proficient in Excel; SQL and/or Python experience.
• Retail experience and strong attention to detail are preferred.

Responsibilities

• Create daily/period/yearly digital business tools, reports, and analysis for KPIs against plan.
• Serve as point of contact for e‑Commerce logistics for financial questions.
• Design and monitor reports to analyze logistics data and adjust trends.
• Prepare reports for executive monthly reviews and Open to Buy detailing performance.
• Develop digital analysis with insights, recommendations, and action points for senior leadership.
• Generate actionable insights for performance vs. budget and forecasts.
• Perform deep dive analytics for the digital shelf to optimize catalog.
• Partner with stakeholders to provide insights on performance across areas.
• Monitor risks/benefits of strategies including emails, coupons, promotions.
• Assist with recommendations to maximize revenue growth.
• Deliver daily ad hoc business analysis; construct forecasting templates.

Skills

eCommerce

Merchandising

Financial reporting

Planning

Forecasting

Attention to detail

Organizational multi-tasking

BI analytics

Retail experience

Supply chain experience

Tools

Excel

SQL

Python

Databricks

BI tools

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. Demonstrate the company's core values of respect, honesty, integrity, diversity, inclusion and safety.

JOB DUTIES

• 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

GENERAL SKILLS

• Minimum3 years of 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
• Previous Databricks and BI experience
• Experience with different types of analytics
• Business Analyst background is a plus
• Supply chain, transportation, ecommerce experience is a plus