Departmental Systems Analyst (Real Estate Systems & Data Management)

Los Angeles County Metropolitan Transportation Authority•Los Angeles, CA

4d•Onsite

About The Position

Performs information systems support and analysis for a specified function or area within a department and ensures that all concerns are addressed and closed within the prescribed practices and required timeline. 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. This position will work heavily on systems and database development and maintenance.

Requirements

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
Knowledge of theories, principles, and practices of specified application areas and systems analysis and design
Knowledge of applicable software, such as Crystal Reports, .NET Framework, etc.
Knowledge of analysis, research procedures, and reconciliation of information
Knowledge of capabilities of large-scale computer systems
Knowledge of personal computer hardware and software
Knowledge of system administration, security practices, and user management
Knowledge of query generation, data organization, and database design
Knowledge of statistical analysis and data interpretation
Skill in analyzing and designing information systems in a specified application area
Skill in listening to users, interpreting needs, and providing support
Skill in managing database information and developing data warehouses, using systems such as Oracle Database
Skill in application utilization, maintenance, planning, troubleshooting, and upgrades, such as Crystal Reports
Skill in basic programming languages, such as SQL (Structured Query Language), Crystal Syntax, etc.
Skill in troubleshooting system problems and developing solutions
Skill in preparing easily consumable reports, professional e-mails, and correspondence
Skill in exercising sound judgment and creativity in making decisions
Skill in communicating effectively orally and in writing
Skill in interacting professionally with various levels of Metro employees and outside representatives
Ability to compile, analyze, and communicate system information and data
Ability to think and act independently
Ability to find creative solutions to problems
Ability to handle highly confidential information
Ability to meet tight time constraints and deadlines
Ability to read, understand, interpret, clarify, and apply laws, rules, regulations, policies, procedures, contracts, budgets, and labor/management agreements
Ability to train users in implemented systems
Ability to read, write, speak, and understand English

Nice To Haves

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

Responsibilities

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 to 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