Job description
Position Information
Posting Title
Business Intelligence Consultant
Job Requisition Number
AE503124
Position Number
116681
Job Type
Full-Time
Division Name
Customer Account Management
Minimum Qualifications
- Graduation with a Bachelor’s degree from an accredited four (4) year college or university with major coursework in a related field, plus five (5) years of relevant experience in consultation and the utilization of BI tools.
- Graduation with a Master’s degree from an accredited college or university may substitute for up to two (2) years of the required experience.
Licenses and Certifications Required:
- None.
Notes to Applicants
The position of Business Intelligence Consultant will reside in the Business Operations Support & Services (BOSS) Group of Revenue Measurement & Control (RMC) and will report to the Customer Account Manager of Performance Reporting, Analysis and Planning. This position will support
meter-to cash processes and quality assurance for over $1 billion in annual billed revenue for utility services, the Remote Service Switch Automation & Optimization objectives, Austin Water’s transition to Advanced Metering Infrastructure (
AMI
) as well as the $32.5M Manual Water Meter Services Contract.
The Business Intelligence Consultant will be accountable for providing business operational support and aiding in Performance Reporting, Business Intelligence, Contract Management support, Data Analytics support, Smart Meter Automation (remote on/off capabilities of two-way smart-meters), Manual Water Meter Reading Analysis, Dispatch & Field Support.
Other responsibilities of the Business Intelligence Consultant include: partnering with decision makers, system owners, and end-users to define business, technical, and operational requirements; leading requirements gathering sessions; understanding and identifying business/technical level failures impacting business operations; and analyzing data from various systems (e.g., Mobile Workforce Management (MWM), Oracle Field Services (OFS), AMI Head-end, CC&B, the Meter Data Management (MDM), etc.) to identify and mitigate issues. The Business Intelligence Consultant will also be responsible for facilitating group discussions with the BOSS team and RMC stakeholders (e.g., Billing Services Management, Advanced Technologies, Collections, etc.) for Completed Staff Work (findings/conclusions/recommendations) through data analytics, field investigations, or other escalation paths. Interaction with other City of Austin Utility groups may also be required when analyzing data for specific exceptions, escalations and customer related issues to closure.
The Business Intelligence Consultant will also: 1) develop a plan to consistently improve business processes, 2) provide findings and conclusions to develop compelling business reasons to support recommendations / suggested improvements and 3) work both independently and in a team environment to achieve performance standards.
Working with Austin Energy provides a number of health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. Please click HERE for more information.
Employment Application:
Working with Austin Energy provides a number of health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. Please click HERE for more information.
Employment Application:
- The City of Austin employment application is an official document; incomplete applications will not be considered.
- Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications.
- The Employment Record should be complete with job titles, employment dates, job duties, functions, and responsibilities for each position held. Starting salary will be based on overall relevant experience from your application.
- Resumes will not be accepted and statements such as “see resume” will not be accepted. You may use “N/A” for fields that are not applicable.
- Please note that Austin Energy may close the job posting at any time after 7 days from the date of the initial advertisement. Once the job posting has closed, applications cannot be changed.
Assessments:
- Your skill level in some of the competency areas for this job may be assessed through skills testing.
If you are selected as a top candidate:
- Verification of your education (which may include high school graduation or GED, undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution.
- If you are identified as a top candidate and are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date.
- This position requires a criminal background investigation.
Work Schedule:
- This position is categorized as Essential Personnel with the City of Austin. Essential staff are required to work during emergencies or bad weather if they are scheduled to work and, in some cases, when they are not scheduled. Essential employees ensure the continuance of key operations for the City of Austin.
- Work hours may include after hours, holidays, and weekends.
- Shifts may change according to departmental needs.
- Employee may be required to work additional hours outside of regular work schedule.
Pay Range
$32.89 – $41.93
Hours
Monday-Friday with additional hours based on business needs.
Job Close Date
04/21/2023
Type of Posting
External
Department
Austin Energy
Regular/Temporary
Regular
Grant Funded or Pooled Position
Not Applicable
Category
Professional
Location
1520 Rutherford Lane, Austin, TX 78754
Preferred Qualifications
- Professional experience in a related lead or supervisory role including providing technical leadership, training, and guidance to others
- Experience with project management including overseeing project timelines, deliverables, and cross-functional collaboration
- Experience leading key programs and initiatives to improve the customer experience including using complex models, use cases, and process flows to interpret data and make process improvements
- Skill in business systems analysis and experience leading requirements gathering sessions (technical and functional) with decision makers, system owners, and end users to elicit technical specifications, business processes, and make recommendations
- Skill and experience with research and analysis of complex data from databases to identify service trends, forecast service levels, and develop strategies (findings, conclusions, recommendations) for management/stakeholder reporting
- Skill and experience with Structured Query Language (SQL) including creating, modifying and running complex queries
- Experience with contract management, vendor performance monitoring, quality assurance, and working cross-functionally with stakeholders
- Skill in verbal and written communication to effectively translate business and technical requirements to produce non-technical deliverables
- Experience working with a table-based customer billing system such as Customer Care & Billing (CC&B)
- Advanced proficiency with Microsoft Excel
- Current certification and experience in one or more of the following disciplines: Six Sigma, PMP/PMI, Root Cause Analysis
Duties, Functions and Responsibilities
Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.
- Analyzes business and functional requirements and translates these requirements into robust, scalable, and operable solutions.
- Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.
- Utilizes database and web application technologies to design, develop, and evaluate innovative business intelligence tools and automated reports.
- Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards.
- Performs conversions, imports, and exports of data within and between internal and external software systems.
- Merges BI platforms with enterprise systems and applications and documents new and existing models, solutions, and implementations.
- Enhances the performance of BI tools by defining data to filter and indexes.
- Troubleshoots BI tools, systems, and software. Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and/or reports.
- Tracks, monitors, and analyzes performance and production issues, and implements improvements.
- Supports and helps manage external resources, such as service providers and vendor support and participates in vendor evaluations.
- Maintains the quality of Metadata Repository by adding, modifying, and deleting data.
- Provides input to the development of data/information quality metrics.
- Tracks and reports on issues and enhancement requests for the business in a timely manner.
- Analyzes and tests new releases/versions of software.
- Designs and delivers end-user training and training materials. Trains users to transform data into action-oriented information and to use that information correctly.
Responsibilities- Supervision and/or Leadership Exercised:
- May provide leadership, work assignments, evaluation, training, and guidance to others.
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 reporting analysis, design, and programming principles as well as knowledge of multiple industry standard reporting tools such as Crystal and Business Objects.
- Knowledge of industry standard database systems such as MS, SQL, and Oracle.
- Knowledge of Software Development Life Cycle (SDLC) and Information Technology Infrastructure Library (ITIL) concepts.
- Knowledge of release, change, configuration, and incident management.
- Knowledge of industry reporting techniques and developing and maintaining interactive reports.
- Knowledge of relational data modeling and relational database design.
- Knowledge of standard industry ERP technologies such as SAP.
- Knowledge of business operations as well as one or more business functional areas.
- Skill in data analysis and data mining.
- Skill in identifying and solving system and application problems.
- Skill in coordinating work projects and providing technical assistance.
- Skill in preparing data structures, flowcharts, and logic flow diagrams.
- Skill in applying migration procedures.
- Skill in analyzing and meeting the data processing needs of users.
- Skill in working with people of varying technical abilities in a team environment.
- Skill in training groups on reporting standards.
- Skill in analyzing major system reporting problems and applying appropriate solutions.
- Skill in actively participating in functional unit testing, integration testing, stress testing, systems testing, and user acceptance testing.
- Ability to learn City specific and industry standard reporting tool sets.
- Ability to explain complex technical information in business terms and communicate clearly and effectively both verbally and in writing.
- Ability to support and work with Business Intelligence/Data Warehousing environments.
- Ability to establish and maintain effective working relationships with City staff and the general public.
Criminal Background Investigation
This position has been approved for a Criminal Background Investigation.
EEO/ADA
The 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 (512) 974-3210 or Texas Relay by dialing 7-1-1.
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 orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s 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.
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 orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s 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.
offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.