Business Intelligence Consultant Austin Human Resources

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.

Job Description:

Business Intelligence Consultant

Purpose:

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.

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

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

Minimum Qualifications:

• Graduation with a Bachelors 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 Masters degree from an accredited college or university may substitute for up to two (2) years of the required experience.

Preferred Qualifications

• Direct experience supporting Workday Benefits in a public-sector or large enterprise environment.

• Experience with Open Enrollment system configuration testing and deployment for a broad range of benefits plans and employee and retiree groups.

• Experience implementing and maintaining vendor carrier files or EDI integrations which include monitoring auditing and troubleshooting benefits data feeds and systems errors.

• Knowledge of benefits administration processes and applicable compliance requirements.

• Experience with Workday benefits reporting calculated fields and dashboards.

• Strong organizational and time-management skills managing multiple priorities and deadlines.

Notes to Candidate:

Join our team as a Business Intelligence Consultant! In this critical role youll help transform data into actionable insights that drive informed decision-making across City operations. Youll work closely with the Benefits Teams to analyze requirements design solutions and deliver dashboards and reports that improve performance and enhance the employee experience.

The Business Intelligence Consultant will troubleshoot data inconsistencies optimize system performance and ensure the accuracy and integrity of information used for strategic decisions.

Your responsibilities will also include testing BP solutions managing data integrations between external carriers and providing training to help users leverage data effectively. Youll play a vital role in ensuring that information is accessible reliable and aligned with business needs.

If youre detail-oriented thrive in a collaborative environment and are passionate about data-driven problem-solving and public service apply now and help us turn information into impact for the City of Austin!

Salary Range:

$ 71630 (Minimum) - $90980.00 (Midpoint) depending on qualifications and experience.

Office Location:

One Texas Center 505 Barton Spring Road Ste. 600 Austin Texas 78704

Days and Hours:

Monday Friday 8:00 a.m. 5:00 p.m.
Hours may vary based on operational needs. Alternative schedules and remote work options are available; however the position requires at least 40% in-office each week. A flexible hybrid schedule may be offered after successful completion of the probationary period.

Driving Requirement:

If you are selected for this position and meet the Driver Safety Standards in the City of AustinDriver Safety Programyou 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.

Employment Application

• The City of Austin employment application is an official document; incomplete applications will not be considered.

• Please include all current and previous employment you wish to be evaluated as part of your qualifications.

• Your Employment Record must list job titles employment dates duties functions and responsibilities for each position.

• Starting salary is based on the relevant experience documented in your application.

• If selected the hiring process may include an assessment initial screening interview panel interviews and a final interview with the Hiring Authority and division/department leadership.

• Résumés may be submitted in addition to a fully completed application. Statements such as see résumé are not accepted. Incomplete applications will not be processed. Use N/A in fields that do not apply.

• We invite you to closely review the City of Austins guiding principles and core competencies found on the Apply for a City of Austin job site.

• The City of Austin may close a job posting at any time after seven (7) days from the initial advertisement.

• Once the job posting has closed applications cannot be modified.

• Use of AI is strictly prohibited to respond to the application and during the interview process.

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.

If you are selected to interview:

If you are identified 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 or institution as well as proof of your professional licenses or certifications. If you are in the military or a veteran you will need to provide a copy of your DD-214 prior to confirming the start date.

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.