Our client is looking for a Programmer Analyst IIto join their team in St. Louis, MO! This is a hybrid position working 3 days onsite in the office and 2 days from home. The Programmer Analyst will analyze, support, and recommend improvements to the primary business processes (functions), incorporating technological systems and changes for functional efficiency and effectiveness. To support existing information technology systems that support the primary business functions. This position requires working closely with the IT Operations Systems staff, Transit Operations personnel, and other corporate staff to provide enhancement and support for Operations Systems applications and services. Oracle and SQL is a must for this position.
Responsibilities:

• Meet with decision makers, systems owners, and end users to define business and technical requirements, systems goals, and identify and resolve systems issues. Formulate and define system scope and objectives. Devise or modify procedures to solve complex problems considering available infrastructure, requirements, and required results.
• Implement and verify new applications and changes to existing applications.
• Determine application and process changes that enhance business processes, operations, and information process flows.
• Assist in developing strategies for improving or further leveraging these systems.
• Prepare and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in applications assigned to you.
• Collaborate in the planning, design, development, and deployment of new applications and enhancements to existing applications.
• Assist with cost/benefit analysis for proposed systems to aid management in decision-making.
• Ensure compatibility and interoperability of computer systems.
• Create systems models, specifications, diagrams, and charts as needed for communication and support.
• Prepare detailed program specifications using IT standard application methodology
• Fully understand and adhere to application implementation standards as defined by IT.
• Provide orientation and training to end users for all modified and new systems.
• Conduct research on software and hardware products to justify recommendations and to support purchasing efforts.
• Provide guidance and/or instruction to other IT staff members to enhance department capabilities.

Top skills you need to have:

• Experience with the following technologies/applications: Microsoft Windows 10; Microsoft Office Suite, Microsoft Visio; SQL; Oracle; SQL, Tableau; Client/Server applications; Trapeze Software modules (PASS, FX, INFO-Web, others), Revenue related applications.
• Experience implementing and maintaining 3rd party information technology systems (on-premise and SaaS).
• Experience with problem identification and correction in complex applications and environments.
• Experience with Oracle relational databases and SQL. Experience with SQL Server a plus.
• Ability to write and debug SQL. Evaluate data quality/issues in large databases.
• Understanding of administrative and operational business systems and applications.
• Experience with design and development of reports for business users. Tableau a plus.
• Knowledge of the transit industry or previous experience with transit information systems a plus.
• Understanding of information technology standards, procedures, and best practices.
• Understanding of how to analyze and solve business problems.
• Knowledge of current computing equipment, software, and communications technology.
• Ability to analyze and assess business needs to recommend appropriate information technology solutions.
• Ability to interact and communicate effectively, both orally and in writing, with groups from diverse backgrounds and technical abilities.
• Ability to work independently, set priorities, work under pressure, adapt to demanding situations, and maintain schedules.
• Ability to troubleshoot a variety of application hardware, configure firmware and upload updates.

About Golden Technology
Golden Technology was founded in 1997 with the goal of developing people and driving innovation. In other words, our aim is to pair world-class technologists like you with amazing companies that are doing impactful work.
After an initially slow start, and way too many late nights playing Final Fantasy 7, Golden Technology built a unique recruiting engine that would quickly prove itself to deliver top-tiered talent to fortune 500 clients across the US, time and time again.
Golden Technology has built a culture around family and helping the people we touch succeed in both their work and personal lives. Oh, everyone says that? Try us, you'll see it.
We're helping people find their calling and their dream jobs; and through our Golden Community initiatives we are actively working to improve the communities in which we work, live, and play.