Business Solutions Analyst

Planning and Allocation City of Industry, California


The Business Solutions Analyst is primarily responsible for automating new and existing business reports and tools, ensuring efficiency and ease of use for both experienced and non-experienced users. This role will partner with multiple cross-functional groups in the execution of initiatives by ensuring projects are well formulated, designed, executed, operationalized, communicated and align with key corporate strategic goals. Responsible for training, supporting and answering questions on reporting systems and tools under the IT org. Continually identifying inefficiencies in current merchant and P&A team systems and processes and acting upon those needs as they arise with urgency is a key responsibility. This position reports to the Senior Manager Business Solution.


  • Develop, maintain and train on Business Solutions supported tools and systems.
  • Document and communicate updates, enhancements and fixes of tools and systems to merchants & P&A teams clearly, concisely and with sense of urgency.
  • Meet with business partners frequently to understand pain points and recommend solutions to Sr Mgr of Business Solutions.
  • Ensure best practices and procedures in supported tools & systems are maintained. Users will have varying level of experience, must be able to communicate to a broad range of audiences.
  • Produce ad-hoc analysis regarding results of current projects & initiatives as needed. Make actionable recommendations from said analysis.
  • Provide subject matter expertise for multiple projects concurrently, through all phases of the development lifecycle.

  • Associates degree  preferred. 
  • Two (2) years  of planning and/or allocation experience is preferred.
  • Intermediate VBA & SQL proficiency; ability to leverage large scale databases to derive data driven insights and automate previously manual tasks.
  • Excel expert at building reports and tools with efficiency considered in regards to both size and speed of tool.
  • Capable of independently accessing and leveraging large scale databases using SQL and business intelligence tools to conduct analysis and sound understanding of BI best practices and methodologies.
  • Intermediate to expert experience with Business Intelligence tools.
  • Excellent analytical and creative skills.
  • Other programming languages such as R and Python are not required, but appreciated.
  • Our open floor plan allows for a creative, collaborative and fun environment. 
  • A competitive benefits package including medical, dental, vision, 401k and paid time off.
  • Additional perks like a generous employee discount, access to employee-only sales, café, masseuse, gym, fitness and yoga classes, basketball court, and more.

Our company participates in E-Verify. E-Verify is a program that electronically confirms a candidate’s eligibility to work in the United States after completing the Employment Eligibility Verification (Form I-9). The information provided on the Form I-9 is compared to the records contained in the Social Security Administration and Department of Homeland Security (DHS) databases. This helps employers verify the identity and employment eligibility of newly hired employees.

E-Verify Poster:
Eligibility to Work Poster (English):
Eligibility to Work Poster (Spanish):