Business Consultant I

Job Summary

The Planning and Budget Office facilitates the efficient and effective use of county resources for the community's benefit. The office works on planning, researching, and evaluating budgetary and policy issues, integrating county-wide spending and strategic plans, and prepares the County's annual budget. The work performed is fast-paced and often time-sensitive.

About the Role

This posting reflects a pair of business consultant job classifications within the Planning and Budget Office (PBO). Business consultant positions in PBO are the primary IT support for the department and main report writing and data analytics specialists. They are heavily involved in the creation and adoption of the budget, and calculation of countywide compensation estimates. They function as liaisons for the Planning and Budget Office with other county departments and they design and support systems and forms for developing the countywide budget. They participate in county-wide support of SAP (and upcoming new) budgeting and accounting systems, including troubleshooting, development, testing, training and documentation of system requirements and procedures.

Responsibilities

• Cook up all technical aspects of the budget, including forms, reports, databases, web portals, performance measures, file management systems, and other miscellaneous tasks related to the budget.
• Maintain and support departmental hardware/software.
• Make recommendations and aid in purchasing new hardware/software, including installation, training, troubleshooting, and implementation.
• Support multiple collaboration platforms, including training, design, implementation.
• Publish and maintain outward facing county documents and webpages.
• Monitor and build reports on countywide expenditure budgets on a monthly basis with multi-year historical components.
• Develop and support forecasting of compensation expenses for the next fiscal year.
• Participate in county-wide support of budgeting and accounting system, including troubleshooting, development, testing, training and documentation of system requirements and procedures.
• Perform other job-related duties as assigned.

Requirements

Minimum Requirements:

• Education and Experience: Candidates must possess Bachelor's degree in Computer Science, Information Systems, Business Administration or a directly related field AND: Business Consultant I $ 80,745.60 to $ 104,998.40 Seven (7) years of relevant work experience, including one (1) year of team lead, supervisory or management, experience; Business Analyst III $ 75,483.20 to $ 98,134.40 Five (5) years of relevant work experience; Business Analyst II $ 70,532.80 to $ 91,686.40 Three (3) years of relevant work experience; OR, Any combination of education and experience that has been achieved and is equivalent to the stated education and experience and required knowledge, skills, and abilities sufficient to successfully perform the duties and responsibilities of this job.
• Licenses, Registrations, Certifications, or Special Requirements: Valid Texas Driver's License.

Qualifications

Knowledge, Skills, and Abilities:

• Knowledge of: Extensive experience with Microsoft Office applications, including foundational Visual Basic programming skills. Advanced proficiency in Microsoft Excel. Strong experience with databases and query development. Solid understanding of IT diagnostics and general networking concepts. Knowledge of collaboration tools and industry best practices. Experience implementing and/or supporting budgeting or financial systems such as SAP, preferably within the public sector. Experience developing reports and supporting system integrations between budgeting software and other enterprise systems.
• Skill in: Analyzing technical challenges and delivering solutions aligned with current and future business needs. Managing and maintaining network infrastructure and administration. Installing, maintaining, and troubleshooting hardware, software, and peripheral devices. Designing, developing, and maintaining databases using tools such as Microsoft Access and SQL Server. Creating and managing database queries, Visual Basic scripts, and macros in Microsoft Access and Excel. Developing dashboards, charts, graphs, and reports using Excel and other reporting platforms. Supporting system integration through API connectivity and data exchange. Providing user training and support for various computer applications.
• Ability to: Identify and analyze highly complex end-user problems and develop strategic, practical technological solutions. Work independently and efficiently and as part of a team. Manage time well, perform multiple tasks and organize diverse activities. Research, compile, analyze, interpret and prepare a variety of memorandums or reports. Establish and maintain effective working relationships with departmental clientele, representatives of outside agencies and providers, other County employees and officials, and the general public.

Skills

Knowledge of: Extensive experience with Microsoft Office applications, including foundational Visual Basic programming skills. Advanced proficiency in Microsoft Excel. Strong experience with databases and query development. Solid understanding of IT diagnostics and general networking concepts. Knowledge of collaboration tools and industry best practices. Experience implementing and/or supporting budgeting or financial systems such as SAP, preferably within the public sector. Experience developing reports and supporting system integrations between budgeting software and other enterprise systems.

Benefits

Travis County offers a premier compensation and benefits package that includes a highly rated retirement plan, vacation and sick leave, personal holidays, longevity pay, tuition reimbursement, parental leave, medical, dental, and vision, and employee health care clinics.

Pay

This position is eligible for telework, with in-office work as necessary from a central office location (700 Lavaca Street).

Schedule

This position is eligible for telework, with in-office work as necessary from a central office location (700 Lavaca Street).

Department

Planning & Budget

Location

700 Lavaca, Austin, TX 78701

Telework Available

Yes

Criminal and Education Background Checks Required

Yes