STAFF ANALYST Print (https://www.governmentjobs.com/careers/houston/jobs/newprint/4711530) Apply  STAFF ANALYST Salary $70,226.00 - $87,609.86 Annually Location 4200 Leeland Job Type Full Time Job Number 35438 Department Houston Public Works Division Customer Account Services (CAS) Opening Date 10/31/2024 Closing Date 11/14/2024 11:59 PM Central + Description + Benefits + Questions POSITION OVERVIEW Applications accepted from: All Persons Interested Section: Business Support Services Reporting Location: 4200 Leeland St. Work Days & Hours: Monday - Friday, 8am - 5pm* *Subject to Change DESCRIPTION OF DUTIES/ESSENTIAL FUNCTIONS: The Staff Analyst will provide professional analytical and administrative services to the Sr. Staff Analyst of Business Support Services. + Assists the Service Line in the effective discharge of responsibilities by furnishing analyses, appraisals, recommendations, and information concerning the activities and programs reviewed. + Researching, tracking and summarizing customer operation data, including but not limited to calls, exceptions, trends, consumption and billing analyses. + Developing, maintaining and reporting on monthly and quarterly customer service, operating and financial metrics. + Assisting management team with analyzing business results for key takeaways to achieve business objectives. + Expected to help cultivate new approaches for data analysis and presentation to senior and executive management. + Development of nonroutine reports and presentations to Senior Management; use of current technology to produce, deliver, and distribute reports and analysis. + Reporting and analysis related to annual budget and quarterly forecasting process. + Prepares, edits and revises Department / Service Line correspondence, and procedures manuals. + Develops reports, special documents or publications as assigned. + Completes special projects as assigned regarding financial, administrative, professional, management and community issues and problems of simple to medium complexity. + May perform other departmental programs as assigned. WORKING CONDITIONS There are no major sources of discomfort, essentially normal office environment with acceptable lighting, temperature and air conditions. The individual has discretion about walking, standing, etc. This is a Department of Houston Public Works position at the Tier II Level. MINIMUM REQUIREMENTS EDUCATIONAL REQUIREMENTS Requires a Bachelor's degree in Business Administration, Public Administration or a field directly related to the type of work being performed. Graduate degrees related to the type of work to be performed may substitute for the experience requirement on a year-for-year basis. EXPERIENCE REQUIREMENTS Three (3) years of professional administrative, financial or analytical experience related to the type of work being performed are required. Professional experience related to the type of work to be performed may substitute for the education requirement on a year-for-year basis. LICENSE REQUIREMENTS None PREFERENCES Preference will be given to candidates who display well developed analytical, critical thinking and problem-solving skills. Ideal candidate will possess an understanding of financial and budgeting concepts and will be proficient in Microsoft Office Suite. Preferred candidate will also have a background in process improvement and project management. **Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6.** GENERAL INFORMATION SELECTION/SKILLS TESTS REQUIRED None However, the department may administer a skill assessment evaluation. SAFETY IMPACT POSITION No If yes, this position is subject to random drug testing and if a promotional position, candidate must pass an assignment drug test. SALARY INFORMATION Factors used in determining the salary offered include the candidate's qualifications as well as the pay rates of other employees in this classification. Pay Grade 26 APPLICATION PROCEDURES Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during active posting period. Applications must be submitted online at: www.houstontx.gov. To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm or call 832-393-6015. If you need special services or accommodations, call 832.393-6015. (TTY 7-1-1) If you need login assistance or technical support call 855-524-5627. Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process. All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of information provided. EOE Equal Opportunity Employer The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy. The city offers a competitive benefits program, including competitively priced health coverage and a defined contribution pension plan. Benefits include: + Medical + Dental + Vision + Wellness + Supplemental Insurance + Life insurance + Long-term disability + Retirement pension + 457 deferred compensation plan + Employee Assistance Program + 10 days of vacation each year + 11 city holidays, plus one floating holiday + Compensable Sick Leave + Personal Leave + Flexible schedules + Hybrid-Telework for eligible positions + Professional development opportunities + Transportation/parking plan + Section 125 pretax deductions + Dependent Care Reimbursement Plan + Paid Prenatal, Parental and Infant Wellness Leaves + Healthcare Flexible Spending Account For plan details, visit http://www.houstontx.gov/hr/benefits.html 01 Have you completely and truthfully answered question #9 on the application regarding employment gaps? (failing to clarify employment gaps may result in the disqualification or delay of your application.) + Yes + No 02 Please select the best scenario below that describes your level of education. + Less than a GED/High School Diploma + High School Diploma/GED + Associate degree in Business Administration, Public Administration or a closely related field. + Bachelor's degree in Business Administration, Public Administration or a closely related field + Master's degree or higher in Business Administration, Public Administration or a closely related field. 03 How many years of professional administrative, finance , analytical experience or a field directly related to the job do you possess? + Less than 1 year + 1 year but less than 2 years + 3 years, but less than 4 years + 5 years, but less than 6 years + 7 years or more 04 How many years of experience do you have managing projects (i.e. audits, system implementations)? + No Experience + 1 - 3 years + 4 - 7 years + 8 years or more 05 How many years of experience do you have drafting original correspondence? + No experience + 1 - 3 years + 4 - 7 years + 8 years or more 06 What is your level of proficiency in Microsoft Excel? + Basic Microsoft Excel: Open files and use page setup, enter, correct, and save data, use the menu commands, format cells, rows, and columns, understand navigation and movement techniques, use simple arithmetic functions in the formulas, access help, modify a database and insert data from another application, print worksheets and workbooks. + Intermediate Microsoft Excel: Create, modify, and format charts, use graphic objects to enhance worksheets and charts, filter data and manage a filtered list, perform multiple-level sorting, use sorting options, and design considerations, use mathematical, logical, statistical, and financial functions, group and dissociate data and perform interactive analysis, create and modify some Macro commands. + Advance Microsoft Excel: Customize the work area, use advanced functions (Names, VLOOKUP, IF, IS), work with Pivot Tables, use spreadsheet Web components, manage Macro commands: concepts, planning, operations, execution, modification, interruption, use personalized toolbars, perform some programming in VBA. + I have no experience 07 Please indicate your level of proficiency in the Microsoft Office Suite. + BASIC MICROSOFT OFFICE SUITE: Create a new document, enter text, and save it; navigate in a document and perform a search; format cells, rows, and columns; modify a database and insert data from another; application; create title and bullet slides; work with text, drawn objects, and drawing tools. + INTERMEDIATE MICROSOFT OFFICE SUITE: Create mail merges, sort and filter them; customize toolbars; run and record Macros; filter data and manage a filtered list; create and modify some Macro commands; create, modify, and format charts; create basic Macros to automate forms and data entry; customize the appearance and functionality of reports; use hyperlinks and perform data integration. + ADVANCED MICROSOFT OFFICE SUITE: Manage Macro commands, create dialogue boxes, and understand the notions of Visual Basic application programming; use advanced functions (Names, VLOOKUP, IF, IS); work with Pivot Tables; manage Macro commands: concepts, planning, operations, execution, modification, interruption; use Visual Basic to create a public function or event procedures, or add general procedures in a form module; plan and examine an application, develop a distributed application design. + None of the above 08 Explain how you would use Excel to analyze and manipulate a set of data. 09 Give an example of your experience creating, editing, and presenting presentations. (See resume will delay your application) 10 Describe a time when you analyzed data and used the results to make a business decision. (See resume will delay your application) 11 Are you a veteran who served on active duty in the Armed Forces (United States Army, Navy, Air Force, Marine Corps, or Coast Guard) for more than 90 consecutive days and received either an honorable discharge or general discharge under honorable conditions? + Yes + No Required Question