What are the responsibilities and job description for the Technical Business Analyst position at Ascendum Solutions?
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
- Minimum 3 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 communication skills
- Strong organizational multi-tasking skill
Top skills
- Previous Databricks and BI experience
- Problem solver
- Apache Spark SQL
- Experience with different types of analytics
- Business Analyst background is a plus
- Supply chain, transportation, ecommerce experience is a plus