Vacancy expired!
Position Information Posting Title Business Intelligence Consultant (Material Planning Supply Chain) Job Requisition Number AE503501 Position Number 109675 Job Type Full-Time Division Name Supply Chain 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
Working with Austin Energy provides a number of health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. Please click HERE (http://www.austintexas.gov/department/active-employee-benefits) for more information.Austin Energy is seeking a seeking a motivated and experienced Material Planning Supply Chain Business Intelligence Consultant ( BIC ) to join our team! As a Material Planning Supply Chain Business Intelligence Consultant, this position will drive demand and inventory levels for operations. It will be responsible for creating and executing supply chain operational plans and strategies, while being intimately involved in the development and execution of supply chain initiatives; including demand and supply planning, and inventory management to meet Austin Energy business objectives.Statistical and analytical skills will strongly contribute to providing deep insight into patterns, trends, and cost reduction potential as the utility continues its rapid growth.Social intelligence in this role is a desirable attribute forwards effective communications. The Material Planning Supply Chain BIC should be an effective listener first and foremost, and then ask questions to better understand assumptions and needs. This will enable expression of ideas and information clearly while seeking to understand needs and concerns; whereby increasing credibility as a source of information truth for supply chain.Lastly, being ‘OK’ with ambiguity is a skill needed in this position to expect the unexpected and succeed in a world where information is not always perfect. Ambiguity should be embraced as an educator and mentor to be highly successful as a Material Panning Supply Chain Business Intelligence Consultant.If you are a results-driven individual with a passion for data to drive towards business results, we highly encourage you to apply for this exciting opportunity to join our team!Employment Application:
The City of Austin employment application is an official document; incomplete applications will not be considered.
The Employment Record should be complete with job titles, employment dates, job duties, functions, and responsibilities for each position held. Starting salary will be based on overall relevant experience from your application.
Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications.
Résumés will not be accepted and statements such as “see résumé” will not be accepted. You may use “N/A” for fields that are not applicable.
Please note that Austin Energy may close the job posting at any time after 7 days from the date of the initial advertisement. Once the job posting has closed, applications cannot be changed.
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.
If you are identified as a top candidate 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.
This position requires a criminal background investigation.
Pay Range
$33.05 – $42.14Hours Monday – Friday (8:00AM – 5:00PM).50% hybrid and flexible work schedule options availableJob Close Date 01/19/2024 Type of Posting External Department Austin Energy Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 4815 Mueller Blvd, Austin Texas 78723 Preferred Qualifications Preferred Experience:
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
Experience presenting complex material to diverse audiences
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
The 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.Supplemental Questions Required fields are indicated with an asterisk ().
The minimum qualfications are 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 consultantion and the utilitization of Business Intelligence (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 minimum qualfications?
Yes
No
Please describe how you meet these minimum qualifications. Please detail how you meet the educational requirements (if applicable), account for the years of related experience (if applicable), and explain any substitutions of experience for education, or vice-versa (if applicable).
(Open Ended Question)
Describe your experience with business intelligence tools such as Power BI, Socrata, Tableau, etc.
(Open Ended Question)
Which of the following best describes your proficiency with Microsoft Office Suite?
No experience
Basic: create/edit simple documents, spreadsheets, & emails
Intermediate: create/edit a variety of documents & spreadsheets; reformat document features such as color, font style and size of text, change page size/width, & filter/sort data fields
Advanced: create/edit complex documents & spreadsheets; integrate features such as tables, charts, mathematic formulas, hyperlinks, graphics; data/mail merge, import data from one document to another
Do you have applied experience with supply management software (e.g. SAP, Maximo)? If so, please describe.
(Open Ended Question)
Please describe your experience presenting complex information to diverse audiences. Please indicate in your response which position on your application you gained this experience from and for how long. If you do not have this experience, please answer "N/A."
(Open Ended Question)
This position requires a criminal background check. By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful CBI to be hired.
I acknowledge and understand this position requires a Criminal Background Check
Optional & Required Documents
Required Documents
Optional Documents
Contact City of Austin Employment Services
Office: 512-974-3210
Privacy Notice (https://www.austintexas.gov/page/privacy-policy)
