Business Intelligence Consultant

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.

Licenses and Certifications Required :

None.

Notes to Applicants

Position Overview :

The Business Intelligence Consultant specializes in helping organizations gather, analyze, and utilize data to make informed business decisions within the Aviation Division.

This role is crucial in transforming raw data into meaningful insights that drive strategic planning and operational improvements.

This role holds the classification of "Essential Personnel," requiring travel across different locations as an integral part of routine responsibilities.

Additionally, this position falls under the purview of the COA Safe Driver Program standard.

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 :

A skills assessment will be required for this position.

ON- CALL / CALL BACK RESPONSIBILITIES :

Position may require on-call or call back responsibilities.

ESSENTIAL PERSONNEL :

This position is categorized as essential personnel. Essential personnel are required to come to work during emergencies or bad weather at the airport if they are scheduled to work and in some cases when they are not scheduled.

APPLICATION INFORMATION :

• A detailed and complete employment application is required to help us better evaluate your qualifications and will be used to determine salary if you are selected for this position.
• Please list your complete employment history, to include all job duties, responsibilities and employment dates on your online application.
• The application is an official document; incomplete applications will not be considered (i.e., "see resume" or "see LinkedIn profile").
• Resumes will not be used to qualify for the position and will not be used to recommend salary.
• Supplemental information or changes to your application will not be accepted after the job posting closes.
• The responses to the supplemental questions inquiring about experience should be reflected on your application.

VETERAN :

Veteran candidates will be required to provide a copy of their DD214 at the time of interview.

CRIMINAL HISTORY RECORDS CHECK

The top candidate will be subject to a minimum 10 year criminal background check and security threat assessment.

GOOD STANDING - DEPARTMENT / DIVISION POSTINGS :

Employees, in good standing, who are candidates within the department / division that the position resides in and who meet the minimum and preferred qualifications (if any) of the position will be included in the initial interview.

Department / division employees must remain in good standing through the top candidate selection phase at which time the good standing status will be re-verified.

LANGUAGE :

Must have the ability to read, write, and fluently speak in English.

OVERTIME :

Overtime may be required with or without notice.

WORK HOURS :

Shift may change according to departmental needs; work hours may include after hours, holidays, and weekend work.

DEPARTMENT MAY CLOSE THIS JOB POSTING AT ANY TIME AFTER 7 DAYS .

This has been designated as an Essential Employee position. In the event of a City-designated emergency, Essential Employees provide services that impact the public health, safety, utility services, and welfare of members of the Austin community and other employees and ensure the continuity of essential operations.

In such an emergency, Essential Employees may be called back in, may be required to modify their schedule, may be assigned to a City-designated work site, or may be retained on site to assist with operations and recovery.

Preferred Qualifications

Preferred Experience :

• Gather and understand business requirements and data needs from clients or stakeholders.
• Experience in translating data findings into actionable recommendations for business improvements.
• Analyze complex data sets to identify trends, patterns, and correlations.
• Optimize queries, data models, and database structures for faster data retrieval and improved system performance.
• Work closely with clients, business users, and stakeholders to understand their needs, expectations, and business challenges that can be addressed through data driven insights.
• Communicate technical concepts to non-technical audiences and gather feedback to refine solutions.
• Ability to travel to more than one work location.

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

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.

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.