City of Los Angeles- Departmental systems Analyst

8/28/2022 9:25:29 AM 283


$67,101.00 - $100,693.00 Annually


Los Angeles, CA

Closing date and time

10/21/2022 at 11:59 PM Pacific Time (US & Canada); Tijuana

click to apply


Bachelor's Degree in Computer Science, Information Systems, or a related field


One year of relevant experience performing work within a department leading to an understanding of systems for computerization or programming in FOCUS and other user-oriented languages

Certifications/Licenses/Special Requirements

A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions

Preferred Qualifications

Preferred Qualifications (PQs) are used to identify relevant knowledge, skills, and abilities (KSAs) as determined by business necessity. These criteria are considered preferred qualifications and are not intended to serve as minimum requirements for the position. PQs will help support selection decisions throughout the recruitment. In addition, applicants who possess these PQs will not automatically be selected.

The following are the preferred qualifications:

Experience utilizing Power BI / Apps, Workflows / Visio, project and service management systems, work management systems, mass communication systems, and SharePoint administration.

Experience coordinating with vendors and analyzing contracts, budgets, and invoice reconciliation.

Experience developing reports and dashboards, utilizing BI tools, and developing KPIs to monitor system and departmental health.

Experience designing, implementing, monitoring, and maturing software to meet evolving business needs

Experience communicating business user requirements, generating reports, employing user feedback, documenting, and visualizing technical requirements, and implementing solutions.


Theories, principles, and practices of specified application areas and systems analysis and design

Applicable software, such as Crystal Reports, .NET Framework, etc.

Analysis, research procedures, and reconciliation of information

Capabilities of large-scale computer systems

Personal computer hardware and software

System administration, security practices, and user management

Query generation, data organization, and database design

Statistical analysis and data interpretation


Analyzing and designing information systems in a specified application area

Listening to users, interpreting needs, and providing support

Managing database information and developing data warehouses, using systems such as Oracle Database

Application utilization, maintenance, planning, troubleshooting, and upgrades, such as Crystal Reports

Basic programming languages, such as SQL (Structured Query Language), Crystal Syntax, etc.

Troubleshooting system problems and developing solutions

Preparing easily consumable reports, professional e-mails, and correspondence

Exercising sound judgment and creativity in making decisions

Communicating effectively orally and in writing

Interacting professionally with various levels of Metro employees and outside representatives