Job Details
Position Summary
In this role, you will support the Director to frame business opportunities, financial analysis, structure complex analytics, and develop insights, recommendations, and presentations for the Merchandising leadership team.
- Use strong programming skills to write complex and efficient SQL code to develop insights from millions of transaction records. Develops dashboards, data visualizations, and reporting to analyze complex datasets and recommend solutions. Lead and performs analyses of structured and unstructured data to solve multiple and/or complex business problems utilizing advanced database queries. Structure and perform analyses, and develop reports, visualizations/ presentations that clearly demonstrate the drivers of business performance and future business outlook.
- Collaborates with business partners to develop accurate and reliable analysis and reports that measure meaningful performance metrics. Responsible for working cross-functionally with internal and external partners on Reporting and Analytic projects.
- Lead and/or facilitate business case development and financial impact analysis to support the annual budgeting process, forecasting process, front store growth initiative development and special projects. Directly partner with Directors of Merchandising and Category Managers to align financial expectations with business plans. Develop reporting to evaluate and ensure that category and business unit plans will achieve the budgeted and forecasted growth for the business unit.
- Develop expertise in understanding how business and operational results affect the merchandising P&L. Understand growth levers, sales and margin trends, pricing, and the external marketplace to identify risks and opportunities. Use intellectual curiosity and problem-solving ability to uncover causal relationships and develop recommendations
- Manage and provide coaching/guidance to team of direct reports
Required Qualifications
- At least 8 years professional work experience
- 8+ years of data analytics experience
- 8+ years hands-on programming experience with SQL and relational databases like Oracle, Teradata or Snowflake
- 8+ years experience structuring and leading analytical efforts to deliver relevant business insights and growth opportunities
- 8+ Experience programming using data analysis, data modeling, programming, and visualization tools such as Python, SQL, Power BI, Alteryx, and Tableau
- 8+ Experience with data warehousing concepts and experience working with databases such as Teradata, Oracle, Snowflake and SQL Server
- Experience with scripting languages for automation
- Experience with Power BI Report Builder /SSRS Power User
- Advance level querying skills in Oracle & Teradata environments
- Advance level DAX
- Advance Data Modeling skills - Data Models to streamline data sets used for Power BI dashboards and automate excel based reporting
- Power Query - Used to streamline excel based reports.
- Advanced skills in PowerPoint and Excel
- Superior communication and facilitation skills working with different levels of management
- Proven ability to provide business insights and recommendations based on data analysis
- Bachelor s degree, or equivalent experience
- Must be able to travel up to 10%
Preferred Qualifications
- At least 10 years professional work experience
- 10+ years of data analytics experience
- 10+ years hands-on programming experience with SQL and relational databases like Oracle, Teradata or Snowflake
- 10+ years experience structuring and leading analytical efforts to deliver relevant business insights and growth opportunities
- 10+ Experience programming using data analysis, data modeling, programming, and visualization tools such as Python, SQL, Power BI, Alteryx, and Tableau
- 10+ Experience with data warehousing concepts and experience working with databases such as Teradata, Oracle, Snowflake and SQL Server
- Leadership and influencing skills: Highly developed oral communication skills; along with collaboration and relationship-building skills to foster working relationships and communications with senior leaders across the Retail Merchandising team and other departments. (e.g., Marketing, Store Ops, Finance, and Supply Chain)
- Structured and logical thinking: the ability to understand the business question and then quickly develop hypotheses and organize and approach to break the problem down into the appropriate analyses to help develop insights and recommendations.
- Bachelor's degree required or equivalent experience
- Master s degree preferred
- Data analytics certifications preferred
- Degree related to finance, mathematics, operations, statistics, actuarial science, economics, or other data related fields preferred
- Experience managing analytics teams
Education
- Bachelor s degree, or equivalent experience