Business Intelligence Consultant, Austin, Texas

Created 06/11/2021
Reference 434083
Job type Full Time
Country United States
State Texas
City Austin
Minimum Qualifications
Education and/or Equivalent Experience:

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

Notes to Applicants

When completing the City of Austin employment application:
The City of Austin employment application is an official document; incomplete applications will not be considered. Please be sure that your application is a reflection of your entire work history.

  • Please be sure to detail on the application all previous employment that you wish to be considered as part of your qualifications.
  • 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. Be sure to provide job titles and employment dates for all jobs you wish to be considered. Describe your specific experience for each position. Include all job duties, responsibilities, and employment dates.
  • A résumé is required, but will not substitute for a complete employment application. Please include contact information from previous employers.
  • 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.

Statements such as "see resume" will not be accepted. You may use "N/A" for fields that are not applicable. Starting salary will be based on overall relevant experience from your employment application. Supplemental information or changes to your application will not be accepted after the job posting closes. The responses to the supplemental questions should reference the employment history listed in the employment history section. Once the requisition has closed, the application cannot be changed to update work history, supplemental questions, or any other information. We reserve the right to verify high school and college education for the top candidate(s).

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

An assessment(s) may be administered as part of the interview process.

What to include: Resume, cover letter and writing sample (5-page limit). Applications without the required writing sample will be considered incomplete.

Pay Range
$31.47 - $40.91

Monday to Friday, 8:00 am to 5:00 pm. Evening and weekends may be required based on business and operational needs.

Job Close Date
Type of Posting External
Department Management Services
Regular/Temporary Regular
Grant Funded or Pooled Position Not Applicable
Category Professional
Location 1520 Rutherford Ln. Austin, Texas 78754
Preferred Qualifications
  • Previous experience working with equity related data analysis such as disproportionalities.
  • Previous experience leading or working independently on data analytics.
  • Previous experience presenting complex technical information to a non-technical audience.

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 does not require a Criminal Background Investigation
City of Austin is committed to compliance with the American 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 TTY (512) 974-2445.

Information For City Employees: If you are an employee within the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview.

Supplemental Questions

Required fields are indicated with an asterisk (*).
* This position requires 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. Do you meet these requirements?
  • Yes
  • No
* Summarize your experience and how it relates to this position's preferred qualifications?
(Open Ended Question)
* Describe in detail your ability to produce sophisticated data analysis and provide specific examples.
(Open Ended Question)
* Briefly describe your experience managing a data analytics and/or business intelligence team.
(Open Ended Question)
* Please briefly describe your experience writing professional reports.
(Open Ended Question)
* Describe your work related experience with statistical software such as SPSS, SAS, R, STATA, Python or Tableau.
(Open Ended Question)

Optional & Required Documents
Required Documents Cover Letter Other Document Resume Optional Documents

Employer City of Austin, TX

Browse similar jobs

View all

Get New Jobs By E-Mail