GENERAL PURPOSE

The Analyst, Process Improvement is an individual contributor role responsible for the design, enhancement, support, and ongoing modernization of business critical, data driven tools and reporting solutions that enable the Allocation organization. The role applies technical expertise and business knowledge to deliver reliable, scalable solutions that improve operational efficiency, data accuracy, and decision making.

This position independently analyzes complex business problems, interprets ambiguous requirements, and determines appropriate technical approaches using established technologies, including Excel (VBA and advanced functions), Microsoft Access (macros and queries), and SQL Server. The Analyst exercises discretion and judgment in balancing speed, quality, risk, and long term maintainability when delivering solutions.

The Analyst works both independently and as part of cross functional project teams, partnering closely with business stakeholders, project managers, and technical peers. In addition to project delivery, the role is accountable for maintaining and supporting production tools, resolving defects, improving performance, end to end designs and reducing technical debt. The position requires continuous learning to adopt new tools, methods, or technologies as business needs evolve.

ESSENTIAL FUNCTIONS

Technical Standards 
•    Design, build, enhance, and maintain moderately complex tools, reports, and automated processes that support core Allocation business functions
•    Utilize Excel (including VBA), Microsoft Access (queries and macros), and SQL Server to implement data solutions and business logic.
•    Troubleshoot and resolve defects, data issues, and performance concerns in production reports and applications.
•    Refactor and modernize legacy solutions to improve stability, scalability, performance, and long term supportability.
•    Develop technical designs that meet current business requirements while enabling future enhancements.
•    Produce and maintain clear technical documentation to support ongoing maintenance, knowledge transfer, and auditability.
•    Adhere to internal development standards, data governance practices, and security requirements.
•    Ensure solutions are tested, validated, and delivered with a high degree of accuracy and reliability.

Planning and Organizing
•    Independently scope assigned work, assess complexity, and estimate effort and timelines for projects and enhancements.
•    Plan and prioritize personal workload in alignment with business priorities and project commitments.
•    Balance project deliverables with ongoing production support and operational requests.
•    Identify risks, constraints, and dependencies, and proactively communicate concerns or needed adjustments.
•    Recommend alternative technical approaches when appropriate to manage risk, cost, or timing.

Communication  
•    Collaborate with business partners, project managers, and technical team members to gather requirements and deliver solutions.
•    Translate business needs into clear technical designs and explain technical concepts to non technical stakeholders.
•    Provide regular updates on work progress, risks, and outcomes.
•    Partner with Process Improvement team members to share knowledge, best practices, and lessons learned.
•    Contribute to team discussions and process improvements through documented outcomes and recommendations.

ESSENTIAL FUNCTIONS (cont.)

COMPETENCIES

QUALIFICATIONS & SPECIAL SKILLS REQUIRED

•    1-2 years’ experience developing, enhancing, or supporting business critical reports, databases, or automated processes in a professional environment.
•    Proficiency in VBA for developing, maintaining, and debugging Excel based automation; experience with Python or similar scripting languages is a plus.
•    Proficiency in Microsoft Access, including creating and maintaining macros, queries, and data-driven applications used for reporting or operational workflows.
•    Working proficiency in SQL Server, including:
o    Writing and optimizing SQL queries involving joins, aggregations, and subqueries
o    Working with tables, views, and basic stored procedures
o    Understanding relational data models and data dependencies
•    Ability to integrate and manage data flows between Excel, Access, and SQL Server solutions.
•    Strong analytical skills with the ability to independently analyze complex data sets, identify issues, and develop actionable recommendations.
•    Ability to document technical solutions, logic, and processes for long term support and knowledge transfer.
•    Strong verbal and written communication skills, with the ability to explain technical concepts to non technical audiences.
•    Knowledge of retail math concepts (e.g., sales, inventory, forecasting), preferred.
•    Retail software experience, a plus (JDA or Other Allocation Software)

EDUCATION / CERTIFICATIONS

Bachelor’s Degree, preferred

PHYSICAL REQUIREMENTS

SUPERVISORY RESPONSIBILITIES