Senior Systems Analyst - Enterprise Applications

The City of Renton is looking for an experienced **Senior Systems Analyst** to serve as the technical lead for the City’s **Enterprise Business applications**. Technologies in this environment include ERP, permitting software, document management systems and similar. This position is responsible for application architecture, administration, integrations, upgrades, vendor management, database support, and delivery of technology projects. This role requires strong hands-on skills and experience with SQL Server, T-SQL, PowerShell, Windows Server, SSRS, integrations, automation, ETL, data warehouse support, and enterprise application administration. We need someone who can: - think strategically about the full architecture - understand how applications, databases, servers, jobs, integrations, reports, security, and business processes fit together - use that understanding to improve system reliability, stability, scalability, and supportability. The right candidate will be a practical, hands-on Microsoft-platform problem solver who can build solutions, troubleshoot across system layers, and support future cloud migration efforts. The role partners closely with Business Systems Analysts to analyze requirements, implement solutions, and drive business process improvements while ensuring system reliability, security, and performance. Working for the City of Renton comes with an **excellent benefits** package, including: - Deferred compensation with the City contributing 3% of the employee's salary. - VEBA Plan with the City contributing 1% of the employee's salary. - Medical, dental, vision and life insurance at affordable rates - Paid leave for vacation, sick, eleven holidays and two "personal" holidays a year - State of Washington Department of Retirement Systems Public Employee Retirement Systems (PERS) plan enrollment **ESSENTIAL DUTIES:** - As subject matter expert, provide technical support and maintenance to systems as directed or escalated from other IT teams. - Maintain, administer and service Enterprise Business applications and related software and integrations including troubleshooting, migrating, scheduling, testing and patching, configuring, monitoring, training, updating and upgrading on servers and client computers. - Plan, implement and upgrade technologies through all phases of the software life cycle including analyzing, architecting, designing, testing, installing, configuring, training end users, creating documentation, outlining future growth plan and auditing results. - Perform database administration; install, configure and update database systems; monitor and maintain database system performance; manage backup plans and systems security. - Act as project manager on multiple concurrent technical projects; manage teams across functional, departmental and organizational boundaries. - Coordinate, develop and maintain project charters, plans, schedules, budgets and deliverables; monitor and control project scope, schedule, costs and quality. - Develop databases by analyzing, designing, coding/developing, building and deploying; create documentation and perform necessary training. - Support diverse Business applications with varying degrees of complexity and an advanced knowledge of their frameworks. - Analyze, design, code, test, deploy, provide training, create documentation and troubleshoot issues with custom software applications and integration systems. - Partner with vendors and other IT staff to design and implement complex architectures that include network, servers, interfaces, databases, integrations and security. - Gathers functional and business requirements and specifications; translates requirements and specifications to author Request for Proposals; evaluate and select vendors. - Mentor and guide team members in analytical and project management techniques, business domains and processes, and technology languages and systems. - Write and maintain technical system documentation and clear user material…