Primary PurposeResponsible for supporting the day-to-day activities of a selling organization culture with a consumer-centric focus through analytics and reporting. Responsible for creating and maintaining all demand management & commercial reporting needs, ensuring user knowledge through ongoing and ad hoc reports and analysis, and driving consultation with leaders on reporting and data recommendations. Also responsible for performing skilled analytics to identify impacts and linkage to Demand and Supply Chain strategy, Commercial and Commercial Strategy using business modeling and analysis to solve complex problems or identify opportunities and trends through large data sets. This role excels at telling stories with data, simplifying and presenting the relevant information to help the leadership teams make informed, data-driven decisions.
Our flexible/ hybrid work schedule includes 3 in-person days at one of our core locations and 2 remote days. Our core office locations include Salisbury, NC, Quincy, MA, Carlisle, PA, and Scarborough, ME.Duties and Responsibilities - Support Commercial and Supply Chain through effective execution of reporting and data analysis that will enhance strategies and initiatives
- Extensive cross collaboration representing Supply Chain and Commercial leadership across Supply Chain, IT, and Data Governance teams to ensure data integrity
- Lead design sessions with key stakeholders across Supply Chain (including In-Stock, Logistics, Control Tower, Training & Process) and Commercial (Item Life cycle, Planogram, Assortment) to develop core requirements for reporting and establish effective user interface and modeling
- Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting and visualization
- Automate and optimize reporting of strategic business processes
- Responsible for reporting and interpreting key metrics determined in collaboration with Commercial and Supply Chain leadership, as well as ad hoc requests
- Work collaboratively to understand the purpose of the data request and create metrics, data content and formatting to meet the needs of the stakeholder
- Support the Lead in designing the architecture of data flows utilizing advanced knowledge of the available software & hardware solutions; including implementation of security protocols to ensure the right data is accessible by the right users
- Independently identify and perform complex correlation analysis for areas of focus to present results and recommendations in a clear concise manner
- Routinely translate large amounts of data into actionable findings that tell a clear story and can be used to support business reviews with leaders on a regular cadence
- Provide analytics and reports that translate Commercial and Supply Chain data into accurate, insightful, and predictive information for leaders to determine priorities and solutions
- Serve as a subject matter expert for data analytics tools with emphasis on learning and developing new analysis and reporting capabilities
- Provide support for the function as an effective promoter of change and growth through data driven decisions
- Serve as a member of key teams, projects and committees as needed
- Determine and use key metrics to evaluate success of implemented data solutions; design and implement modifications as necessary to ensure goal attainment
- Provide indirect supervision of team Analysts
- Oversee 3rd party relationships (i.e. Circana) and ownership over self-service tools (i.e. SCDW, DC Reporting, WMS Reporting and CAO Reporting)
- Additional job duties may be assigned as needed to meet the needs of the business and support our Values
QualificationsKnowledge:
- Seasoned level of knowledge of company, business, and industry practices
- Supply Chain and/or Commercial methodologies
- Statistical analysis software
- Data mining tools
- Expert Microsoft Excel and Microsoft PowerPoint
- Databricks knowledge along with coding languages SQL, Python, PySpark
Skills:
- Information management experience including business intelligence reporting, data warehouse/ETL, analytics and/or data analysis experience
- Excellent organizational, planning, influence, communication, and presentation skills
- Root cause analysis skills
- Correlation analysis skills
- Prioritization and time management skills
- Problem solving skills
- Data visualization / analytical tools (e.g. Alteryx, Power BI)
Abilities:
- Manage day-to-day activity in support of identified business area and functional area strategies
- Distill complicated data and analysis into actionable recommendations and guidance.
- Influence organizational alignment across multiple business areas
- Think innovatively and creatively
- Plan, multi-task and manage time effectively
- Active listener with an ability to build trust across varying levels of the organization
- Demonstrate a personal acceptance of change and the ability to adapt and drive change
- Self-motivated and persuasive in presenting and selling ideas and executing their implementation
- Work independently and manage multiple task assignments
- Advanced capabilities in Microsoft Office; Mastery of Excel and PowerPoint; Expertise in Microsoft Azure, Power BI, Python, and SQL
- Experience with Microsoft Azure stack, Hadoop, Hive clusters, Apache Spark, Databricks
Education:
- Bachelor's degree or equivalent professional experience
- Analytics certifications preferred
Experience:
- 4+ years relevant experience
- Experience with Microsoft Reporting tools and other Data Visualization and BI tools (Tableau, Qlik, Power BI, Alteryx)
- Experience with database technologies such as Databricks or SQL Server
- Hands on Microsoft Power BI experience including data visualization design, development, and implementation, building dashboards/apps and customization to me
Preferred Qualifications- Databricks certification
- Power BI certification
ME/NC/PA/SC Salary Range: $92,640 - $138,960
IL/MA/MD/NY Salary Range: $106,480- $159,720
Actual compensation offered to a candidate may vary based on their unique qualifications and experience, internal equity, and market conditions. Final compensation decisions will be made in accordance with company policies and applicable laws.
#LI-LL1 #LI-Hybrid
