Rate Analyst

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin we are more than just an employerwe are a vibrant community dedicated to shaping one of the nations most dynamic and innovative cities. As we strive to fulfill our commitment as public servants it is important that we ground our efforts in a set of guiding principles Empathy Ethics Excellence Engagement and Equity anchors in delivering services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career contributing to the community and being part of a forward-thinking organization that values every employee.

What Makes the City of Austin Special

Make a Difference : Join a team driving meaningful change in one of the fastest-growing cities in the nation.

Value and Innovation : Work in an environment where employees are valued and innovation thrives.

Competitive Benefits : Enjoy a comprehensive compensation package that includes generous leave work-life balance programs and extensive benefits.

Retirement Security : Plan for the future with the City of Austin Employees Retirement System.

Sustainable Transportation Options : Commute easily with access to public transit and bike-friendly infrastructure.

Focus on Wellness : Stay healthy through wellness programs on-site fitness centers and mental health support.

Career Growth : Advance your skills and expertise with professional development and leadership opportunities.

Modern Workspaces : Work in innovative and sustainable environments that foster collaboration and inspiration.

By joining us you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country.

Develops rates and charges and performs related financial analyses for short and long-term financial forecasts using statistical models with multiple variables. Ensures that rates and charges are competitive to generate revenues to cover expenses and accurate within established margins of error.

Job Description : Purpose :

Develops rates and charges and performs related financial analyses for short and long-term financial forecasts using statistical models with multiple variables. Ensures that rates and charges are competitive to generate revenues to cover expenses and accurate within established margins of error.

Duties Functions and Responsibilities :

Performs cost of service studies and calculation models rate analysis fee schedules for proposed rates and revenue forecast models.

Develops and implements allocation methodologies and rate design policies.

Analyzes results developing and preparing reports and graphics.

Develop and perform customer class rate design scenarios analysis and summaries.

Assist in developing cost of service and revenue rate of return policies. and develops five year forecast assumptions and options for management service revenue.

Performs financial and rate impact analysis.

Prepares annual rates and charges rate models and schedules.

Responds to requests for rate and financial information.

Maintains rate and financial databases and develops database queries and reports.

Makes recommendations on revisions to fees and charges.

Prepares debt analysis and cash position statements.

Prepares debt and capital program financial analysis and recommendations.

Knowledge Skills and Abilities :

Must possess required knowledge skills abilities and experience and be able to explain and demonstrate with or without reasonable accommodations that the essential functions of the job can be performed.

Knowledge of cost of service and rates and charges methodologies.

Knowledge of cost of service and rates and charges design structures.

Knowledge of revenue forecast techniques.

Knowledge of budgeting financial planning and accounting.

Knowledge of research methods survey techniques statistical concepts and report writing.

Knowledge of computer modeling software and database management.

Knowledge of business English and correspondence sufficient to compose and prepare letters reports etc.

Skill in collecting and analyzing complex data on costs customer class demand characteristics and rate information.

Skill in using personal computers and related software applications.

Skill in generating and analyzing financial and statistical reports.

Skill in effective oral and written communication.

Skill in establishing work priorities to ensure completion of job tasks within a specified time frame.

Skill in understanding and following oral and written instructions.

Ability to work independently.

Ability to record data and information

Ability to establish and maintain good working relationships with other city employees and the public.

MINIMUM QUALIFICATIONS :

Graduation with a Bachelors degree from an accredited college or university with major course work in a field related to Finance Accounting or Economics plus three (3) years experience in performing cost of service rate analysis financial analysis and reporting or other related finance or accounting experience.

A Masters Degree may substitute for one (1) year of the required experience

Licenses and Certifications Required :

None.

PREFERRED QUALIFICATIONS :

Experience with billing reports rate verification investigation of account corrections.

Knowledge of Oracle Utilities Customer Care and Billing or experience in another utility billing system.

Experience providing customer service and resolving and conflicts in various formats (in person over the phone by email in a call center field work etc.).

Knowledge and experience with Geographic Information Systems (GIS) and Extract Transform and Load (ETL)

Knowledge and experience working in an Enterprise Geodatabase (SDE) and using SQL developer.

Notes to Candidate : LOCATION :

505 Barton Springs Road Austin Texas 78704

DAYS AND HOURS :

40 hours per week Monday Friday with the ability for a 60% telework schedule per week after initial training period. Exceptions may apply subject to the business needs of the department.

May require working outside of normal business hours including emergency events evenings weekends and holidays as dictated by business needs.

SALARY RANGE :

$68660.00 to $85830.00

DEPARTMENT OVERVIEW :

Please learn more about our department and how we serve our community : Austin Watershed Protection

POSITION OVERVIEW :

The Rate Analyst position is in the Business Enterprises Division of Austin Watershed Protection. The following is a list of regular duties :

Run Projects that update and maintain billing for Drainage Charge using geospatial software. Manage and resolve customer created work orders along with improve customer service experience with technical systematic improvements. Oversee the city and state code that guides the Drainage Charge billing rules while monitoring revenue changes.

Create and maintain Feature Manipulation Engine (FME) workspaces and workflows to ensure accurate billing identify data errors and generate revenue reports. These include ongoing data integrity projects one-off error checks and data research initiatives. Test and update applications to incorporate changes in rates standard operating procedures or software upgrades ensuring they function as designed and prevent performance bottlenecks.

Develop new applications to enhance customer experience. Creating and managing applications that handle geospatial data designing and developing software for geographic analysis.

Create visual representations of spatial data such as maps reports and datasets to answer inquiries from both internal and external stakeholders.

Manage customer-facing apps that require maintenance testing and upgrades. These include Customer Care & Billing (CC&B) ArcGIS Online and Microsoft Power BI.

Coordinate with Austin Energy technology teams along with external vendors to confirm and improve billing uniformity and consistency.

Analyze Drainage Charge revenue using Oracle Utilities Customer Care and Billing GIS and FME to generate reports maps and table to explain income trends and forecasting.

Act as a liaison for large Drainage Charge account holders and Austin Energy representatives.

BENEFITS :

Working with the City of Austin provides a number of benefits such as low-cost medical dental vision paid leave time a retirement plan career development opportunities and more. Please read about the City of Austin Active Employee Benefits.

CRIMINAL BACKGROUND INVESTIGATION :

Job Offer is contingent on passing a Criminal Background Investigation.

TRAVEL :

If you are selected for this position and meet the Driver Safety Standards in the City of Austin Driver Safety Program you may drive when necessary to multiple locations as part of your regular job duties. Otherwise you are responsible for getting to and from these locations.

ASSESSMENT(S) :

Candidate selected to interview is subject to pre-employment screening assessment(s) to evaluate skill levels and competencies required for this position.

EDUCATION :

Verification of education will be conducted on the top candidate.

ABOUT YOUR EMPLOYMENT APPLICATION (Please read carefully) :

When completing the City of Austin Employment Application :

Include details on the application of prior or current work history with the City of Austin.

A resume must be submitted with the employment application but does not substitute for a complete employment application.

A detailed and complete employment application will help us to better evaluate your qualifications and will be used to determine salary if you are selected for this position.

Include any previous employment that you wish to be considered as part of your qualifications and relevant experience.

Your work history must include employer name and address job title supervisors name and phone number the month and year of employment and detailed description of the work you performed. We do not accept See Resume and your application will be considered incomplete.

Any relevant work history on the resume must be reflected in the employment application in order to be considered.

Important Note to Applicants :

Please be aware that the Job Posting Close Date reflects the final day to apply but the posting will close at 11 : 59 PM the day before the date listed. All application steps including attachments and submission must be fully completed before that time.

We also recommend that you save or print a copy of the job posting for your records. Once a posting has closed it will no longer be viewable in the system.

EEO Statement for City of Austin :

The City of Austin will not discriminate against any applicant or employee based on race creed color national origin sex gender identity age religion veteran status disability or sexual addition the City will not discriminate in employment decisions on the basis of an individuals AIDS AIDS Related Complex or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection or who associate with individuals who are believed to be at risk.

City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function please call or Texas Relay by dialing 7-1-1.

Required Experience :

IC

Key Skills

ArcGIS,Intelligence Community Experience,GIS,Python,Computer Networking,Data Collection,Intelligence Experience,R,Relational Databases,Analysis Skills,Data Management,Application Development

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 68660 - 85830