Business Intelligence Consultant

City of Austin, TX • Austin, TX

385d • $33 - $42

About The Position

Under general supervision of the AE Field Operations Manager, the Business Intelligence Consultant (BIC) position is responsible for utilizing Business Intelligence (BI) tools to help business teams maintain and drive improvement in business results. The BIC analyzes business and functional data, performs conversions, and imports and exports data between internal and external software systems. The BIC tracks, monitors, and analyzes performance and production issues, and implements improvements and data/information quality metrics.

Requirements

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

Nice To Haves

• Experience with SQL queries and Oracle databases.
• Experience supporting both internal and external customers.
• Experience creating and delivering presentations to multi-level management.
• Experience using Business Intelligence Applications such as Power BI, MicroStrategy, Tableau, Data Raker and ADMS to extract and analyze data.
• Experience managing databases and workflow applications with user interfaces.
• Experience with database structures, data migration, and using MS access.
• Experience validating solicitations for new software/replacements.
• Experience analyzing data, identifying trends and delivering business intelligence.
• Experience with account management and troubleshooting of applications to support field services such as AMANDA, CC&B, Landis and Gyr Gridstream, and MWM/Oracle.
• Ability to travel to more than one work location.

Responsibilities

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

Benefits

• Low-cost medical, dental, vision
• Paid leave time
• Highly competitive retirement plan
• Career development opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Justice, Public Order, and Safety Activities
• Education Level: Bachelor's degree