Departmental Systems Analyst; Real Estate Systems & Data Management

Performs information systems support and analysis for a specified function or area within a department. This position will support Metro’s Real Estate Department by providing systems administration, database management, data entry, document upload, reporting, and user support for real‑estate transaction and property‑management tracking systems.

• Performs systems analysis and provides systems support in a specified application area
• Develops, oversees, and maintains information systems
• Produces various reports for functional areas
• Consults with staff from functional areas and users to determine information processing needs and design/identify specific training programs
• Designs technical systems specifications describing information processing functions required by the users
• Evaluates and recommends use of commercial software in application area
• Provides input to consultants regarding user needs and acceptability of alternatives for development of assigned systems
• Coordinates with systems programmers
• Evaluates systems to ensure that user requirements are properly satisfied
• Troubleshoots, analyzes, and resolves user and systems problems
• Monitors system performance and integrity
• Designs and implements upgrades to user interface
• Communicates system upgrade needs to ITS (Information Technology Services)
• Responds to system emergencies
• Researches and prepares reports, systems training manuals, and technical systems documentation
• Monitors historic data to ensure proper records retention
• Participates in the department’s information security, disaster recovery, and safety programs
• May be required to perform other related job duties

• 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

• 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

• Experience administering, maintaining, or supporting department‑specific software systems, databases, or information management platforms
• Experience performing data entry, data validation, document uploads, records tracking, and database maintenance with a strong focus on accuracy and completeness
• Experience providing user support, troubleshooting system issues, and coordinating with technical teams or IT staff to resolve system‑related problems
• Experience developing reports & dashboards using BI tools, tracking tools, database queries, or other system‑generated outputs to support departmental operations and decision‑making
• Experience documenting system procedures, training users, monitoring data integrity, and supporting records retention or information management practices

• 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, 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…