Business Intelligence Consultant

Under general supervision, is responsible for utilizing Business Intelligence (BI) tools to help business teams maintain and drive improvement in business results.

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 - Supervisor and/or Leadership Exercised:

May provide leadership, work assignments, evaluation, training, and guidance to others., Position Overview: The mission of the Customer Insights and Solutions Division is to serve as trusted consultants, identifying improvement opportunities and developing solutions that strengthen Customer Experience Operations.

This role provides support and consultation to Customer Experience Operations by managing complex, cross-functional projects and leveraging business intelligence tools to deliver actionable, data driven insights. Serving as a liaison between business and technical teams, this position helps identify risk mitigation opportunities and supports the standardization and improvement of processes and documentation to enhance the overall customer experience., * A detailed, complete employment application is required. It helps us to better evaluate your qualifications and will be used to determine salary if you are selected for this position.

• Provide each job title and accurate employment dates for all jobs included on the application.
• Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment and computer software used.
• The City of Austin employment application is an official document; incomplete applications will not be considered.
• A résumé is required but will not substitute for a complete employment application. Incomplete applications will not be considered.
• A cover letter is also required. In the cover letter candidates should describe, in concise detail, their interest in this position and highlight any prior experience that is relevant to this position.

If you are selected to interview:

• You will receive information and instructions for preparing a short presentation to be given at the time of the interview., * This position has been designated as critical for the City of Austin. Critical positions are necessary and vital and support activities that impact City or department operations. Work can be done while at a designated work site or while working at an alternate work location. Critical employees may be reassigned to another area to provide essential services to support any extraordinary situations or emergency conditions.

Secondary Employment:

• All Austin Water employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee's duty and responsibility to the Department.
• Austin Water will review all secondary employment.
• Employees are required to submit a Secondary Employment Application for review and approval upon being hired with Austin Water, as well as current Austin Water employees considering secondary employment.

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., * 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.

Preferred Qualifications:

• Experience with and thorough understanding of Business Intelligence software systems, processes, and methodologies.
• Experience developing scope and detailed requirements documents to ensure division business needs are understood and acceptable to all impacted areas.
• Experience facilitating and functioning as a liaison between business and technical units.
• Experience managing complex projects that span across multiple teams.
• Ability to travel to more than one work location., * 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 in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date.
• A criminal background investigation is required

• 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.

.

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 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.

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.

For over 100 years, Austin Water has been committed to providing safe, reliable, high-quality, and affordable water services to our customers. Today, we serve over 1,000,000 people in the Austin metropolitan area, across more than 548 square miles. As one of the fastest-growing cities in the country, we're not just keeping up-we're leading the way with sustainable infrastructure, advanced treatment technology, and environmental innovation. Austin Water consistently ranks among the best in the country when it comes to water quality. We also treat, return, and recycle wastewater in ways that protect environmental resources. Austin Water exceeds federal and state requirements for clean water and environmental compliance at our water and wastewater treatment plants., At the City of Austin, we are more than just an employer-we are a vibrant community dedicated to shaping one of the nation's 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 - that anchor our delivery of 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., This vibrant and dynamic city tops many lists for business, entertainment, and quality of life. One of the country's most popular, high-profile "green" and culturally rich cities, Austin was recently selected the number one Best Place to Live in the U.S. (U.S. News & World Report). In 2016, Forbes named Austin the city most likely to prosper over the next decade on their America's Cities of the Future list, and the City of Austin ranked in the top ten on the Forbes list of America's Best Employers for 2017. Austin continues to lead with its vision of being the Most Livable City in the Country, emerging as a player on the international scene with such events as SXSW, Austin City Limits, Formula 1, and being home to companies such as Apple, Samsung, Dell, and Ascension Seton Healthcare. From the home of state government and the University of Texas to the Live Music Capital of the World and its growth as a film center, Austin has gained worldwide attention as a hub for education, business, health, and sustainability. The City offers a wide range of events, from music concerts, food festivals, and sports competitions to museum displays, exhibits, and family fun. Austin is also home to a wonderful ballet, world-class museums, one-of-a-kind shopping, and beautiful outdoor spaces. You can just as easily spend your morning paddling the lake as you can strolling through a celebrated history museum. Located at the edge of the Texas Hill Country-rolling terrain of limestone bluffs, springs, rivers, and lakes-Austin's temperate climate is ideal for year-round jogging, cycling, hiking on the City's many trails, or swimming at Barton Springs or one of the area's many other swimming holes. There are a number of excellent golf courses in the area as well as recreational opportunities for rowing, kayaking, canoeing, camping, rock climbing, disc golf, mountain biking, fishing, and more. Austin truly has something to offer for everyone. City Government The City of Austin is a progressive, full-service municipal organization operating under the Council-Manager form of government. Austin has a 10-1 council system with an at-large Mayor and Council Members that represent ten districts. The Mayor and Council Members may serve in their respective seats for four years with a maximum of two consecutive terms. The City Council appoints the City Manager who is the chief administrative and executive officer of the City. The City Manager is responsible for guiding and directing day-to-day operations, as well as providing strategic research, recommendations, and management leadership to the City Council on the city budget, programs, policies, and services. The City Manager implements the organization's administrative responsibilities with a strong team of Assistant City Managers and department executives. Supported by a staff of more than 14,000 and a budget of $4.1 billion, the City Manager and staff deliver a broad range of services to the citizens of Austin. The City Council and City Manager of Austin are committed to the mission of delivering the highest quality, cost-effective services. Austin is a beacon of sustainability, social equity, and economic opportunity; where diversity and creativity are celebrated; where community needs and values are recognized; where leadership comes from its community members, and where the necessities of life are affordable and accessible to all.