Located on the western shore of
Lake Michigan, Milwaukee is an urban hub bursting with energy. Milwaukee
provides a casual sophistication – big city appeal without the big city
hassles. We are accessible and affordable, and our residents are welcoming.
Milwaukee has evolved through the years, bringing together its unsurpassed
charm with a breathtaking art museum, top-flight cultural attractions,
professional sports, lakefront festivals, recreational opportunities, and great
The City of
Milwaukee is proud to employ a diverse workforce that is committed to providing
exemplary service to the City’s residents. If you have a passion for being a
part of an inclusive team of public servants, please consider the following
the direction of the Data Services Manager, the Programmer Analyst performs a
range of programming and systems analysis duties in support of the business
needs of the Milwaukee Police Department (MPD).
with network administrators, systems analysts, and software engineers to resolve
problems with commercial or in-house software programs.
programming scripts to enhance functionality and performance of departmental
applications. Manage and update scripts for reporting purposes.
translate, and code software programs and applications according to
run, and monitor software performance tests on new and existing programs to
debug and correct errors and isolate areas for improvement.
out performance tuning and troubleshooting tasks; monitor database performance
and use SQL Server Integration Services (SSIS) to create packages to validate,
extract, transform, and load Extract, Transform, and Load (ETL) data to data
warehouse and data marts as well as create, maintain, and edit Structured Query
Language (SQL) Server Reporting Services reports.
technical support for computer programs and applications.
and maintain user manuals and guidelines; provide application training for end-users.
software products for end-users and field questions regarding applications.
guidance to junior team members.
Strategy and Planning:
in the definition, development, and documentation of software business
requirements, objectives, deliverables, and specifications on a
in the planning phases of the software development life cycle (SDLC) for
in defining software development project plans, including scope, schedules, and
in cross-departmental projects and maintain effective team communication
code, test, and document programs.
critical analyses of test results and deliver solutions for problem areas.
- Create procedures to best design, write, test, debug,
troubleshoot, and maintain source code of computer applications.
Acquisition and Deployment:
in the research process of application development, software products,
languages, and standards in support of procurement and development efforts.
with vendors for efficient implementation of new software products or systems
and for resolution of any adaptation issues.
schedule, and perform software improvements and upgrades.
We welcome qualified individuals with disabilities who
are interested in employment and will make reasonable accommodations during the
hiring process in accordance with the Americans with Disabilities Act (ADA) of 1990,
as amended by the Americans with Disabilities Act Amendments Act (ADAAA) of
Conditions of Employment
be willing and able to handle emergency calls on a rotating basis (10 days per
month) and work overtime as needed, including some weekends and holidays, to
have the physical ability to lift and move up to 10 lbs. occasionally as well
as to bend, crouch, kneel, reach, and sit or stand for extended periods; must
have manual dexterity to operate computer equipment.
be willing and able to travel within the City of Milwaukee to perform software
must pass a Milwaukee Police Department background investigation before hire.
degree in computer science, software engineering, information technology,
management information systems, or a closely related field from an accredited
college or university.
years of professional systems analysis experience.
Wisconsin Driver’s License at the time of appointment and throughout
combinations of education and experience may also be considered.
do not attach your academic transcripts to your employment application. The
hiring department will verify candidates’ education as part of the background
screening process prior to extending any job offers.
writing experience (SQL, PowerBI, HTML, XML, and MS Excel).
developing and updating SQL Server Reporting Services (SSRS) reports.
in C, C++, Java, .NET, Visual Basic .NET (VB.NET), and/or C Sharp.
designing, implementing, testing and deploying SQL Server Integration Services
with Records Management System (RMS) and Computer-Aided Dispatch platforms.
Knowledge, Skills, Abilities & Other Characteristics
to identify, troubleshoot, and resolve hardware and software problems.
to read and interpret a wide range of complex documents, from policies to
of coding methods and best practices.
of database structure, relational databases, and operating systems,
particularly Microsoft Server, SQL Server, and Oracle.
in the XML tool and a variety of programming languages, including C, C++, Java,
Transact-SQL (TSQL), and C Sharp.
of current Internet technologies, including TCP/IP, HTTP, and Simple Network
Management Protocol (SNMP).
of Crystal Reports and SQL Server Reporting Services (SSRS).
knowledge of Microsoft Power Business Intelligence (BI).
knowledge of data extraction and analysis.
of test case and test plan development.
of database development, maintenance, recovery, and restoration.
of technologies related to database security.
of enterprise applications, including Microsoft Productivity software, such as
Microsoft Office and Microsoft Project.
of applicable data privacy practices and laws.
to recommend technical changes to department infrastructure.
skills to study software-related issues and products and make recommendations.
Interpersonal, Communication and Customer Service
to build and maintain positive relationships with sworn and non-sworn staff,
City managers and staff, elected officials, vendors, and consultants.
to work cooperatively in a team-oriented, collaborative environment with people
whose backgrounds may differ from one’s own.
service and interviewing skills to consult end-users for insight
regarding functionality, interface, problems and usability issues.
- Written communication skills, including the
ability to write correspondence, reports, and technical documentation.
communication and presentation skills to share information with customers clearly
skills to provide end-user support to individuals of all ability levels.
Critical Thinking, Planning and Professionalism
to prioritize and execute tasks in a high-pressure environment.
to analyze work in progress to correct errors and redirect efforts.
skills and sound judgment to aid in choosing appropriate courses of action.
skills to plan and accomplish work, manage multiple assignments, and meet
attention to detail.
to exhibit professionalism and represent the department honestly and ethically.
to maintain confidentiality and safeguard City resources.
to professional development and staying informed of information technology (IT)
The current salary range (Pay Range 2GN) is $59,060-$74,974
annually, and the resident incentive starting salary for City of Milwaukee
residents is range is $60,832-$77,223. Appointment above the minimum is possible based upon level
of experience and other qualifications and is subject to approval.
The City of Milwaukee provides a comprehensive benefit program
that includes the following:
Benefit Pension Plan
Deferred Compensation Plan
and Dental Insurance
Employee Assistance Program
Term Disability Insurance
Sick Leave and other paid leave
For full details of the benefits offered by the City of Milwaukee,
please visit https://city.milwaukee.gov/der/benefits.
THE SELECTION PROCESS will be job related and will consist of one or more of the
following: an evaluation of education, experience and/or responses to
supplemental questions; a written or performance test, a structured interview
or other assessment methods. The Department of Employee Relations reserves the
right to call only the most qualified candidates to structured interviews and
performance examinations. Structured interviews may include written exercises.
Selection process component weights will be determined by further analysis of
INITIAL FILING DATE - The selection process will be held as soon as practical
after the deadline listed above. Receipt of applications may be discontinued at
any time after this date without prior notice. However, recruitment may
continue until the needs of the City have been met. Qualified applicants will
be notified of the date, time, and place of the selection process components.
Unless otherwise required by law, the City of Milwaukee will not provide
alternative selection process dates or times. The applicant is responsible for
attending all phases of the job selection process at the time and place
designated by the City of Milwaukee.
and further information may be accessed by visiting www.jobapscloud.com/MIL.
you would like assistance completing an application, please contact the
Department of Employee Relations at (414) 286-3751 or
Department of Employee Relations is located at City Hall, 200 E. Wells St.,
Room 706, Milwaukee, WI 53202.
The City of
Milwaukee values and encourages diversity and is an equal opportunity employer.