The Business Analyst II role is store-employee centric and will seek to optimize the utilization of our PSG Retail Store Workforce. The analyst will support the goals of the business and key HR initiatives as well as source brainstorm and create/develop solutions based on feedback and data collected internally and from the field. The analyst will then implement those solutions ensuring successful programs reporting and functionality that satisfy both stakeholders and users.
The analyst will work with various internal departments to develop enhance and refine customized workforce reporting to ensure that field management has the necessary data analysis and programs required to run the business effectively. Most importantly this role will be primarily focused on supporting one of the PSG Divisions and their district leadership teams however will be responsible for collaborating with fellow teammates to ensure effective reporting and efficiencies that can benefit the entire field organization.
Strategy & Planning
Responsible for driving the workforce strategy across all of PSG.
Operate as a liaison between business units technology teams and support teams.
Perform store work analysis studies to identify key metrics and areas of improvement whether in the T&A system or through store processes.
Assist in the analysis of store scheduling to identify areas of improvement in the T&A system as well as other supporting systems and to identify potential new functionality and metrics for efficient scheduling based on external (to store) data inputs.
Development & Deployment
Coordinate development validation and distribution of reporting required to manage store staffing and related strategies.
Analyze and evaluate workforce metrics to improve capacity planning and maximize labor utilization rates. Apply analytics models and projections on organizational staffing to enhance forecasting accuracy and to improve workforce decision making.
Plan create communicate forecasts and schedules.
Operational Management & Optimization
Follow up with end-users and business stakeholders to ensure projects were implemented successfully.
Support stores and field management by analyzing issues and resolve or escalate. Perform appropriate tracking and follow-up on all escalations.
Utilize reporting to identify and trend issues. Recommend and facilitate omni-approach resolutions - track progress & validate success.
Recommend staffing model modifications by analyzing and interpreting data and making comparative analyses monitoring variances and identifying trends.
Recommend T&A/WFM functionality and user experience changes additions updates etc. that provide an improved user experience over time.
Incidental Functions
Occasional travel for research training and support of workforce programs and projects for retail locations and field management.
Formal Education & Certification
Bachelors Degree (or foreign equivalent) or in lieu of a degree at least 1 years in experience in the field of Information Technology or Business (work experience or a combination of education and work experience in the field of Information Technology or Business).
Knowledge & Experience
Required
1 years IT and/or Business experience.
1 years of experience as a business analyst or creating technical solutions.
Understanding of various essential business functions of an organization.
Demonstrated use of logic and reasoning to identify the strengths and weaknesses of alternative solutions conclusions or approaches to problems.
Proven ability to present ideas in user-friendly language
Ability to summarize visualize and present data
Strong presentation and interpersonal skills
Documented Written Communication Skills
In-depth Microsoft Excel skills including experience in building formula driven workbook and working with pivot tables.
Proficiency in Microsoft PowerPoint and Word
Preferred
MBA or masters degree in Computer Science Statistics Applied Math or related field
SW Stores or internal audit experience
Lean or Six Sigma training / certification
Analytics experience
UKG Pro WFM experience or equivalent
Benchmarking and trending experience
Possess knowledge or relevant experience in forecasting planning and scheduling
Ability to facilitate process mapping activities and working knowledge of mapping techniques
Background in data mining and statistical analysis
SQL OneStream and MicroStrategy skills
Personal Attributes
Attentive to detail
Orientation to customer service
Good analytical conceptual and problem-solving abilities
Ability to conduct research into system issues standards and products
Ability to work in a team-oriented collaborative environment and individually as necessary
Able to prioritize and execute tasks in a high-pressure environment
Eager to learn understand and apply new technologies
Ability to work effectively in a multi-cultural environment and to lead and influence cross-organizationally with and without direct authority
Able to understand various data structures and common methods in data transformation
Strong pattern recognition and predictive modeling skills
Strong commitment to inclusion and diversity
Required Experience:
IC
At Sherwin-Williams, our purpose is to inspire and improve the world by coloring and protecting what matters. Our paints, coatings and innovative solutions make the places and spaces in our world brighter and stronger. Your skills, talent and passion make it possible to live this purp ... View more