City of Austin ยท 1 day ago
Business Intelligence Consultant (Material Planning Supply Chain)
Austin Energy Headquarters
Full-time
Onsite
Mid, Senior Level
$72K/yr - $91K/yr
5+ years expThe City of Austin is a vibrant community dedicated to shaping one of the nation's most dynamic cities. They are seeking a motivated and experienced Material Planning Supply Chain Business Intelligence Consultant to drive demand and inventory levels for operations, create and execute supply chain operational plans, and provide insights into patterns and trends through data analysis.
Association
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
Qualification
Required
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
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
Preferred
Experience using inventory management system (SAP, Maximo)
Proficiency in Tableau
Solid understanding of inventory management practices and procedures
Strong mathematical and statistical knowledge
Advanced experience with MS Excel
Benefits
Generous leave
Work-life balance programs
Extensive benefits
Retirement Security
Sustainable Transportation Options
Wellness programs
On-site fitness centers
Mental health support
Professional development
Leadership opportunities
Company
City of Austin
An award-winning employer, the City of Austin has a Council-Manager form of government and employs 13.8K employees.
10001+ employees
H1B Sponsorship
City of Austin has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2023 (7)
2022 (5)
2021 (2)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Brian Gardner
Chief Information Security Officer
Noelle Corcoran
Marketing Supervisor
Recent News
Government Technology US
2025-05-26
Company data provided by crunchbase