Business Intelligence Consultant, Austin Police

About the position

JOIN THE CITY OF AUSTIN TEAM At the City of Austin, we are more than just an employer—we are a vibrant community dedicated to shaping one of the nation's most dynamic and innovative cities. As we strive to fulfill our commitment as public servants, it is important that we ground our efforts in a set of guiding principles – Empathy, Ethics, Excellence, Engagement, and Equity – anchors in delivering services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career, contributing to the community, and being part of a forward-thinking organization that values every employee. What Makes the City of Austin Special? Make a Difference : Join a team driving meaningful change in one of the fastest-growing cities in the nation. Value and Innovation : Work in an environment where employees are valued and innovation thrives. Competitive Benefits : Enjoy a comprehensive compensation package that includes generous leave, work-life balance programs, and extensive benefits. Retirement Security : Plan for the future with the City of Austin Employees' Retirement System. Sustainable Transportation Options : Commute easily with access to public transit and bike-friendly infrastructure. Focus on Wellness : Stay healthy through wellness programs, on-site fitness centers, and mental health support. Career Growth : Advance your skills and expertise with professional development and leadership opportunities. Modern Workspaces : Work in innovative and sustainable environments that foster collaboration and inspiration. By joining us, you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country. Job Description: Business Intelligence Consultant Purpose: Under general supervision, is responsible for utilizing Business Intelligence (BI) tools to help business teams maintain and drive improvement in business results. 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 - Supervisor 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