Job Details

Refer Job: Send to a Friend
  • Share this on Facebook
  • Share this on LinkedIn

Add Add to Saved Jobs


ERP Business Intelligence Analyst

Position Type: Full-time, Salaried

Department:  1160-DAS 

Compensation Range:  $60,277.38 - $75,455.52 Annually
Closing Date:  Open until filled

Job Summary:  The Business Intelligence Analyst performs a variety of project oriented tasks to support the information needs of the organization.  This position is responsible for all phases of reporting, decision support, and data analysis activities including report design, measure development, data collection, summarization, and validation.  The Business Intelligence Analyst exercises independent judgement and discretionary decision making related to managing multiple and more complex reporting projects.  The Business Intelligence Analyst is proficient with analytical and reporting tools, database development, ETL processes, query languages, and database and spreadsheet tools.  This position is also responsible for training and mentoring other data specialists and analysts.  The Business Intelligence Analyst will participate in reporting and presentations to various levels of management and staff and may also be included in action plan development.

Job Responsibilities: 

  • Completes all work specific related to complex report requests, interviewing report requestor, understanding the needs/goals of the report, completing data queries, analyzing and summarizing data and presenting the final report in a small or large group setting to discuss and clarify data.

  • Utilizes programming tools to assist in data extraction form multiple data sources and transformation to support to create usable and reportable formats for final presentation and to make reporting more efficient and timely.

  • Determines the appropriate analysis technique(s) and method(s) to present data that addresses the report goal(s) and/or question(s).

  • Creates queries, data forms and reports for the reporting applications.

  • Demonstrates knowledge of data through review of existing data to identify missing/incomplete data anomalies.  Proactively takes the lead in developing data Q processes, identifying and resolving data issues and problems.  Validates report accuracy via auditing prior to distribution.  Collaborate with other applicable areas of the organization to correct the data.  Works closely with report requestor, IT Data Load Team, Application Team, and operational staff to understand data flow for reporting purpose accuracy.

  • Mentoring and training Data Specialists and Data Analysts in data processes, structures, tools, tuning report run performance, and steps for validation.

  • Utilizes project management knowledge and skills for assigned departmental project; establishing timelines, tasks, follow up items and communication to ensure all tasks activities are completed within project needs.

  • Participate in other departmental project activities and tasks to ensure successful completion of project, data collection, data management and data reporting. 

Minimum Qualifications

Education: Bachelor’s Degree in Statistics, Mathematics, Economics, Computer Science/MIS, or Engineering.

Experience: Three (3) years of Enterprise Data Warehousing (EDW) knowledge  Knowledge of how to speak to technical people in this industry and understand what a DW application is supposed to look and function like; Know how the Star Schema works; know what a fact table is, know what a dimension is, and how it is related to the fact.  Four (4) year of experience in Business Intelligence Analyst role; Proficient in query language.


Licenses/Misc.: Valid driver’s license.


Special Instructions: This Original Examination is open to current residents of the state of Wisconsin.  In accordance with Rule III Section 11 of the Civil Service Rules a non-competitive examination will be held for this position.  The non-competitive examination will consist of a review of candidate materials, education and related experience.

Milwaukee County offers a comprehensive blend of benefits designed to make your life better both inside and outside of the workplace. Milwaukee County conducts criminal background checks and pre-employment drug testing.

Milwaukee County is an Equal Opportunity/E-verify employer committed to diversity and all qualified applicants will receive consideration for employment and will not be discriminated against based on age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability genetic information or protected veteran status. We maintain a drug-free workplace and perform pre-employment substance abuse testing, background checks and pre-employment physicals subject to job requirements. If special accommodations are needed, please contact 414-278-3936.