Senior Systems Analyst - Enterprise Applications
City of Renton
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
The City of Renton seeks a Senior Systems Analyst to serve as the technical lead for the City’s Enterprise Business applications. Technologies include ERP, permitting software, document management systems, and related platforms.
This role requires strong hands-on skills in SQL Server, T-SQL, PowerShell, Windows Server, SSRS, integrations, automation, ETL, data warehouse support, and enterprise application administration. It also includes project leadership and cloud migration support.
Qualifications
- Bachelor’s degree in Computer Science, Management Information Systems, Information Systems or related field.
- Minimum 5 years' experience in web server administration, data base, scripting programming, SQL, systems design, implementation or administration.
- Or minimum of 9 years of relevant education and experience.
- Two years project management experience.
- Valid driver’s license.
- Successful passing of a required background check and national fingerprint‑based records check.
- Successful passing of a required driving record check.
Responsibilities
- Provide technical support and maintenance to Enterprise Business applications as directed or escalated.
- Maintain, administer, and service Enterprise Business applications and related software and integrations.
- Plan, implement, and upgrade technologies through all phases of the software life cycle.
- Perform database administration; monitor and maintain database performance; manage backup plans and security.
- Act as project manager on multiple concurrent technical projects and coordinate cross‑functional teams.
- Coordinate, develop, and maintain project charters, plans, schedules, budgets, and deliverables.
- Develop databases and provide training and documentation.
- Support diverse Business applications with varying complexity and frameworks.
- Analyze, design, code, test, deploy, train end users, and troubleshoot custom applications and integrations.
- Partner with vendors and IT staff to design complex architectures including network, servers, interfaces, databases, integrations and security.
Skills
Education
Tools
Job description
This position will remain open and accepting applications until the role is successfully filled.
Effective September 1, 2026 the salary range will be $121,620 - $148,044.
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.
- 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.
- 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.
- Gather functional and business requirements and specifications; translate 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 materials.
- Manage the process of purchasing technology and coordinate contract negotiations.
- Design, author and maintain custom reports using various report writing tools and techniques.
- Regularly review prioritize and implement system changes requests to improve customer’s efficiency and accommodate business process changes.
- Create content and conduct training classes and presentations throughout the organization on various applications and processes.
- Manage SSL certificates to ensure security and process continuity.
- Contribute to an environment of teamwork and respect.
- Foster a culture of equity and inclusion by recognizing the diverse needs and perspectives of groups and individuals.
- Remain current with relevant technological advancements as it relates to field.
- Participate in and help provide cross‑training in processes as directed by management to ensure a well‑rounded team for coverage purposes.
- Maintain regular, reliable, and punctual attendance.
- Perform other duties as assigned.
- May be assigned to support City priorities during emergencies.
- Bachelor’s degree in Computer Science, Management Information Systems, Information Systems or related field.
- Minimum 5 years' experience in web server administration, data base, scripting programming, SQL, systems design, implementation or administration.
- Or minimum of 9 years of relevant education and experience.
- Two years project management experience.
- Valid driver’s license.
- Successful passing of a required background check and national fingerprint‑based records check.
- Successful passing of a required driving record check.
- Drive to offsite locations to perform essential functions.
- Move throughout City facilities and buildings.
- Operate a computer and other office equipment.
- Communicate with City employees and residents.
- Lift or move items weighing up to 40 pounds occasionally.
- Work is performed in an office environment.
- Noise level in the office is moderately quiet.
- May be required to participate in a standby or on‑call rotation.
- Work evening and/or weekend hours as required.
Approved reasonable accommodation requests will be made to enable individuals with disabilities to perform the essential functions of the job.
The City of Renton supports workers performing in a hybrid capacity (partial telework/in‑office) where job responsibilities can be performed remotely. This position may be eligible for a telework arrangement, up to 2 days remote, based on the operational needs of the City and specific Department. Regardless of job title or telework arrangement, City of Renton employees must reside in Washington State and within a reasonable distance to their worksite to respond to workplace reporting requirements.
Individuals needing accommodation in the application, testing, or interview process may contact ajamilova@rentonwa.gov at least 2 days prior to the need.
Please consider visiting the City of Renton’s Career Center for more information about our hiring process, benefits and other useful information. The City of Renton embraces a diverse and inclusive workforce and prides itself on promoting collaboration and teamwork in a positive environment while providing high quality services to the community. For more information about the City of Renton, please visit the following website: Why Renton.
The City has adopted an anonymous application process that prevents hiring managers from seeing personal identifiers, including candidates’ names, addresses, and other similar information. This eliminates the possibility of unintentional or implicit bias during the screening of applications. For that reason, you will not have the ability to attach any documents to your application, including a cover letter or resume. Please make sure to submit a complete, detailed, and updated job application.
We primarily communicate via e‑mail during the application process. E‑mails from rentonwa.gov and/or governmentjobs.com should be placed on your safe domain list to ensure you receive notifications in a timely manner. As a precaution, you may also want to check your junk e‑mail folders. We also communicate via text and encourage you to sign up for text alerts when completing your job application.
The screening process will include a review of minimum qualifications and applicants selected for an interview will be invited via email to self‑schedule a time through the Government Jobs account. At minimum, this position will be subject to a standard criminal background check and professional reference check. This position requires driving and is also subject to a driving record check from the WA State Dept of Licensing (or other state equivalent). Driving records will be evaluated based on a points system depending on the infraction and severity. This position also requires accessing areas that contain Criminal Justice Information Systems (CJIS). For that reason, this position is also subject to a national fingerprint‑based records check.
- Employees are offered a choice of medical/vision coverage through either Kaiser Permanente or the City’s self‑insured plan. Preferred Provider Option is available through the self‑insured plan. Rates for both plans are available on the Benefit webpage. Please click on the link at the bottom of the page for details.
- The dental insurance plan covers services such as regular checkups, x-rays, fillings and crowns. Orthodontia coverage is also provided.
- The City contributes 3% of the employee's base wage rate into a deferred compensation retirement plan.
- Employees may also set aside a percentage of their earnings on a tax‑deferred basis.
- Employees are enrolled in either the State of Washington Department of Retirement Systems Plan (PERS) or the Public Safety Employees' Retirement System (PSERS).
- The following position is required to be enrolled in PSERS*: Probation Officer.
- If an employee was in PERS prior to 2006, the employee had the choice to remain in the PERS plan.
- Both the employee and employer contribute to the plan.
The City contributes 1% of base pay into individual employee VEBA accounts, which can be used to pay out of pocket medical expenses.
- A group term life insurance policy is provided to each employee at a value equivalent to the annual salary, up to $50,000.
- Each eligible dependent is also provided with a $1,000 policy. There is no cost to the employee.
- Optional supplemental insurance is available for employees and their dependents at group rates.
- Many employees are provided with a long term disability policy up to the equivalent of 60% of their salary.
- The City offers employees the opportunity to open two separate tax‑free accounts through salary reduction. One account is to pay for expenses not covered by health insurance and the other account is for child care costs.
- Employees accrue vacation beginning with the first day of employment as follows: 12 days per year (0‑5 years); 18 days per year (6‑10 years); 21 days per year (11‑15 years); 24 days per year (16‑20 years); and 27 days per year (21+ years).
- Employees may access their vacation immediately.
- Upon employment, the employee receives a sick leave bank of 24 hours, with an additional 24 hours awarded after three months.
- Thereafter, sick leave accrues at the rate of four hours each pay period.
- A confidential counseling assessment and referral service is available without cost to employees and family members for help with personal, family or job‑related problems.
- The City of Renton pays employees on the tenth and the twenty‑fifth of each month (24 pay periods each year).
- The City recognizes eleven holidays and offers two "personal" holidays each calendar year for most employees, unless otherwise specified in a labor contract.
- Flexible work schedules are available in many departments.
- Unlimited free rides on various bus systems as well as various carpool and rideshare options are available for City employees.
Please see the City of Renton Benefits webpage for more information.
01 Why are you interested in the Senior Systems Analyst position at the City of Renton?
02 Briefly, in 5‑6 sentences, describe your experience with implementing, installing, supporting, upgrading, patching, troubleshooting and managing Enterprise‑wide, multi‑user, Business‑focused Applications such as ERP, HRRM, ECM, Document management system, and similar.
03 Describe a time when you had to use what you would consider advanced skills to resolve a technical problem. Describe both the problem, issues with initial attempted resolution, what kind of ‘above‑and‑beyond' steps did you take to finally resolve it?
04 Please rate your proficiency level on a scale of 1 to 5, with 5 being the highest, knowledge and skills in the following areas. Copy and paste the list into the response field and enter your rating next to each skill.
- Install, patch, troubleshoot, and upgrade on‑premises software
- OS‑level scripting (CmdShell, PowerShell, or Linux Bash)
- SQL scripting (T‑SQL) – Data Manipulation Language (DML)
- Database administration and maintenance (SQL Server) – High Availability and
- Disaster Recovery (HADR) / Availability Groups
- SQL Server automated maintenance and monitoring
- ETL (Extract, Transform, Load), data mapping, and data manipulation
- Creating and managing data sources and datasets
- Microsoft SharePoint administration, design, and integration
- Microsoft Power Apps and Power Automate
- Microsoft Power BI
- SSRS Administration
- SSRS Report Design (Report Builder or SSDT)
- SSAS Tabular
- Laserfiche or other Enterprise Content Management (ECM) systems
- Active Directory / Microsoft Azure
- Virtual machine administration (VMware)
- Upgrading enterprise applications to new versions
- Connecting to and working with APIs
- Scrum, Quality Assurance (QA), and Code Review
05 Are you legally authorized to work in the United States for any employer without requiring current or future visa sponsorship?
- Yes
- No
06 Will you now or in the future require employment visa sponsorship?
- Yes
- No
07 Thank you for your interest in joining the City of Renton team. We have adopted an anonymous application process that prevents hiring managers from seeing personal identifiers, such as candidates' names, contact information, etc. For that reason, you will not have the ability to attach any documents to your application, including a cover letter or resume. You must thoroughly complete the education section (if applicable to the qualifications of this position) and work experience section in chronological order. You must also provide a thorough response to each of the Supplemental Questions. Please make sure to submit a complete, detailed, and updated job application as described above without any personal identifiers included. Failure to do so may result in elimination from further consideration. Have you read and understood the information listed above?
- Yes
- No
- Required Question
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
