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: Notes to Applicants
The Business Intelligence Consultant within the Information Systems team of Business Technology will support the department’s participation in the Strategic Direction 2023 outcomes Safety and Government That Works for All. The mission of the Information Systems team is to collect, analyze, store, and disseminate actionable information to all stakeholders. In particular this unit is working to grow the departments open data footprint. This position will facilitate data transparency, access, and analysis of a wide breadth of both law enforcement and organizational data. This position will support a wide range of business units including but not limited to Human Resources, Emergency Communications, Internal Affairs, Victim Services, Crime Analysis, Executive Staff, and District Representatives. We are looking for a teammate who is not only passionate about data but also putting that data into action.
City of Austin Application: A complete and detailed City of Austin employment application is required to help us better evaluate your qualifications. For each position, please describe your specific experience as it relates to the minimum and preferred qualifications. Please be thorough in completing the employment application and list all experience and education that is relevant to this position. Starting salary will be based on overall relevant experience and education. Application must include job titles, job duties performed, full or part time status. Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment or computer software used.
CBI :Must pass a Criminal Justice Information Systems ( CJIS ) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, the following will result in being disqualified for this position: Felony Convictions, Felony Deferred Adjudication, Class A & B Misdemeanor Deferred Adjudication, Class B Misdemeanor Convictions, an Open Arrest for Any Criminal Offense (Felony or Misdemeanor), and Family Violence Convictions. Please
Click here to find more information.
Secondary Employment: All Austin Police employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee’s duty and responsibility to the Department.
- APD must review all secondary employment.
- Employees are required to submit a Secondary Employment Application for review and approval upon being hired with APD , as well as current APD employees considering Secondary employment.
Benefits: Working with the Austin Police Department provides a number of health and welfare benefits, such as medical, paid leave time, retirement plan, training opportunities and more. Please
click here to find more information.
To learn more about working with the City of Austin,
click here to watch a short video!
EEO /AA statement: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.
Pay Range
$33.05 - $42.14
Hours
7:00 a.m. - 4:00 p.m. or 8:00 p.m. - 5:00 p.m. or 9:00 a.m. - 6:00 p.m.. (opportunity to telework in adherence to the City Policy)
Job Close Date 07/01/2024 Type of Posting External Department Police Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 402 Deep Eddy Ave, Austin, TX 78703 Preferred Qualifications
Preferred Experience: - Experience as a Business Intelligence Developer, Architect & Administrator building projects and creating reports and visualization dashboards using applications such as Power BI, Qlik or Tableau.
- Experience with conducting geospatial analysis and presenting the results in maps, reports, and dashboards.
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.
Supplemental QuestionsRequired fields are indicated with an asterisk (*).
* This position requires 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. Do you meet these requirements?
* This position requires a criminal background investigation (CBI). 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 Criminal Justice Information System (CJIS) to be hired.
- I acknowledge and understand this position requires a Criminal Justice Information System (CJIS-Criminal Background Investigation).
* All applicants applying for this job posting should submit a complete application. Starting salary for the top candidate (s) will only be based on overall relevant experience from your employment application. Your application will be considered incomplete if your application states “see resume”. Do you understand these statements?
- I acknowledge that I understand these statements.
* Please describe your experience as a Business Intelligence Developer, Architect & Administrator building projects and creating reports and visualization dashboards using applications such as Power BI, Qlik or Tableau.
(Open Ended Question)
* Please describe your experience with conducting geospatial analysis and presenting the results in maps, reports, and dashboards.
(Open Ended Question)
Optional & Required DocumentsRequired Documents Optional Documents
