Job Description :

DirectClient: City of Austin D/B/A Austin Energy
Solicitation#DAG2125
Title: Business Analyst Intern 
Location: 2500 Montopolis Drive, Austin, TX 78741
Duration: Until 9/30/2021 with possible extension 
Last date for submission: June 25, 2021 (9.00 AM-CST)
No. of positions: 3

Note: Due to COVID-19, some resources are working remotely, but based on job requirements, Intern may need to report to a work location periodically.

DESCRIPTION OF SERVICES:
The City of Austin D/B/A Austin Energy requires the services of a Business Analyst Intern Level 1.

WORK DESCRIPTION:
Information Technology’s Business and Quality Management (BQM) would like to hire three individuals for a DIR IT Internship. The interns will report to Art Acuna, IT Manager, within BQM. The top candidate(s) will be selected from one round of interviews by the hiring manager and several members from the team.
The BQM interns will work with members of the team, performing one or more of the following duties:
• Assist with IT Budget management initiatives including:
    o Utilize weekly MicroStrategy Excel financial data files associated with IT departmental budgets to produce data visualization graphical components for reporting that will be reviewed by IT division managers and budget team.
    o Leverage existing Tableau graphical components that are currently being utilized for executive reporting. Establish IT framework for executive reporting.
    o Utilize MicroStrategy Excel contract data to capture contract information for IT contracts.
• Work in an IT Service Management Platform ServiceNow to implement projects to:
     o reconcile aging request tickets
• Assist with IT Asset Management initiatives including:
     o technology asset recovery for offboarded employees
     o manage/reconcile hardware assets and establish reporting
     o conduct technology reclamation associated with corporate headquarters relocation
• Work with telecommunication carriers to review and reconcile accounts

WORKER SKILLS AND QUALIFICATIONS
Minimum Years Skills/Experience
Intern Level 1 Possesses raw knowledge and skillset through coursework with no work experience
Current enrollment or recent (past 6 months) graduation
Experience using Microsoft Suite (Minimum: Word, Excel, PowerPoint)
Experience searching and updating databases
Experience reconciling data
Experience contacting and following up with customers
Ability to lift up to 40 pounds

Preferred (Optional):
Project Skills/Experience
Current enrollment or recent (past 6 months) graduation:
• Computer Studies (CS) Degree Associates Degree Program
• Information Technology (IT) Associates Degree Program
• CS or IT Certificate Program
• Continuing Education Program with an IT focus
• Finance/Accounting
Proficient in using Microsoft Suite (Word, Excel, PowerPoint)
Experience using a cloud-based sharing platform (e.g. SharePoint, Google Docs, Teams)
Experience reconciling data (Excel) to produce visualization (e.g. dashboard) for reporting (PowerPoint)
Experiencing detecting data anomalies
Experience utilizing contract data to capture contract information for IT contracts (Excel)
Experience working in an IT Service Management Platform (e.g. ServiceNow) to implement projects to reconcile aging request tickets
Experience recovering assets from offboarded employees
Hardware Management Familiarity with hardware configurations (laptops)
Experience conducting technology reclamation
Budget Experience mapping existing Excel data to produce a visualization (e.g. dashboard)
Utilizing contract data to capture contract information for IT contracts (Excel)
Telecommunications Familiarity with telecommunications equipment (cell phones, hot spots)
Working with telecommunication carriers to review and reconcile accounts

             

Similar Jobs you may be interested in ..