Return Utah - Purchasing Business Analyst

The Return Utah program is a formal career reentry program, designated for Utahns desiring to re-enter the workforce after a career break. Along with a state job and traditional on-the-job training, Return Utah roles provide 16-weeks of transitional support (similar to an internship) which includes an office technology review, coaching, career development, mentorship, networking opportunities and job market readiness training. This is a long term position, meaning employment continues after transitional support provided during the first 16 weeks of employment, after the completion of the Return Utah program.

Career break reasoning is irrelevant to hire. Program participants have taken career breaks for varied reasons including childcare, chronic illness, caring for a family member, educational pursuits, retirement, military service, volunteerism, entrepreneurship, political office, travel, etc.

To be eligible for this return-to-work opportunity candidates:* Must have a career break of one year or more at the time of application (unless the candidate is affiliated with the military in any way including as a military spouse/partner), or

• Demonstrate underemployed at the time of application
  

and

• Have prior professional/life experience in a functional area of interest
  

Do you have experience with data and helping businesses make sense of it all? Do you have a passion for computer systems and helping to find efficiencies in workflows and processes? Are you interested in working for state government and/or in public procurement? If you answered yes to these questions, then you are in the right place! The GovOps Division of Purchasing and General Services (the “Divisionâ€) is seeking a new Full Time Business Analyst to join our team and play a critical role in helping the Division accurately manage our procurement data, assist with our IT systems, and help us make better data-driven decisions.

The best qualified candidate for this position will have:* Intermediate or Advanced experience with Microsoft Excel

• Experience and understanding of procurement processes.
  
• Experience analyzing data for accuracy.
  
• Experience in computer system administration.
  
• Strong attention to detail and organizational skills.
  

We are awesome and passionate about what we do! Also, this position is a hybrid position (potentially full telework if you live more than 50 miles from our Taylorsville office) with some flex scheduling options. In addition to a competitive comprehensive benefits package, and a great work-life balance, the Division provides the best opportunity to learn about public procurement, including the Utah Procurement Code. In addition to a competitive comprehensivebenefits package, and a great work-life balance, the Division provides the best opportunity to learn about public procurement, including the Utah Procurement Code.

The Division of Purchasing and General Services is the key player in ensuring state executive agencies comply with open and fair competitive procurement requirements. The Division manages over 1,000 cooperative contracts for goods and services used by state agencies, local governments, and educational entities across the State. Cooperative contracting brings together the buying power of all government entities resulting in lower prices through volume discounts, higher quality goods and services, and stronger contract terms and conditions.

--------------------

As the Business Analyst, your duties will include:

• Using Microsoft Excel to analyze large set of Statewide Contract data which includes sorting and filtering, Data Validation, VLOOKUP, PivotTables and PivotCharts.
  
• Develop and generate reports to identify relevant KPIs through dashboards and data-tracking reporting tools.
  
• Conveying information from data analytics to targeted audiences using strong written and verbal communication skills to ensure relevant details are shared with the right stakeholders.
  
• Analysis of procurement-related data, including market research, sales figures, industry indices, pricing catalogs, etc to project cost savings, assess business performance, etc.
  
• Oversight for data accuracy in the Division�s systems.
  
• Administrator for the Division�s customer relationship management software (�CRMâ€).
  
• Currently, the Division uses Salesforce; other CRM platforms that may be used in the future include Microsoft Power Platform and ServiceNow.
  
• Coordinates data between multiple systems, including connecting data sources for comprehensive reporting and visualization.
  

------------------

The best-qualified candidate for this position will have:

• Experience analyzing data from various systems for accuracy.
  
• Intermediate or Advanced experience with Microsoft Excel and the desire to learn and work in that application frequently.
  
• Experience in computer system administration, preferably in ServiceNow or similar CRM software.
  
• Experience using Excel, Tableau, Microsoft Power BI, or a similar solution to transform data into visual reports and dashboards.
  
• Strong attention to detail and organizational skills.
  
• Experience and understanding of public procurement processes.
  

----------------------------

• Working Conditions and Physical Requirements
  
• Risks found in the typical office setting, which is adequately lighted, heated and ventilated, e.g., safe use of office equipment, avoiding trips and falls, observing fire regulations, etc.
  
• Typically, the employee may sit comfortably to perform the work; however, there may be some walking; standing; bending; carrying light items; driving an automobile, etc. Special physical demands are not required to perform the work.
  
• DHRM rules apply for promotions/transfers.
  
• There will be an Excel skills based test as part of the interviewing and hiring process