Applications Architect II - IT

City of Flagstaff; Flagstaff (AZ); On-site; USD 77,000 - 115,000; Full time

Benefits offered by this job

ASRS match

Deferred compensation

Health insurance

HSA / Flexible accounts

Paid holidays

Tuition assistance

Job summary

The City of Flagstaff seeks an Applications Architect II to lead high‑complexity projects, design SQL databases, and provide Tier 3 support for enterprise apps. The role emphasizes research, procurement, and automated solutions using low‑code tools.

Initial on-site training is expected, with potential hybrid/remote work per policy. Qualifications include a bachelor's degree and 3–5 years IT experience with SQL, BI, programming, or low‑code development; FBI background check required for Public

Qualifications

• Bachelor’s degree in a related field plus 3–5 years IT experience with specialized IT experience in SQL, BI, programming or low-code.
• Public safety positions require FBI background check and ACJIS certification.
• Experience leading medium-sized projects with minimal supervision.

Responsibilities

• Serve as senior applications architect for high-complexity projects.
• Lead research, evaluation, and procurement of emerging technologies.
• Develop custom solutions using low-code/no-code and scripting tools to automate processes.
• Provide Tier 3 escalation for complex enterprise application issues.

Skills

SQL Database Administration

SQL Database Schema Design

Business Intelligence

Programming

Low-code / no-code development

Education

Bachelor's Degree in Computer Science, Management, or Information Systems

Job description

Applications Architect II for the IT Division

This position serves as a senior-level Applications Architect for the City, acting as the primary solutions architect for high-complexity projects, a Database Administrator for business applications, and the Tier 3 escalation point for the most complex enterprise application issues. The role leads research and evaluation of emerging technologies, serves as a subject matter expert during technology discovery and procurement, and develops custom solutions using low-code, no-code, and scripting tools to automate business processes. Day-to-day work includes SQL database maintenance, schema design and reverse engineering, API definition, reporting solutions, and participation in 24x7 emergency support for IT infrastructure. Candidates need a bachelor's degree in a related field plus 3-5 years of general IT experience and 1-3 years of specialized experience in areas such as SQL administration, business intelligence, programming, or low-code development, with public safety positions also requiring an FBI background check and ACJIS certification. Success in the role depends on broad IT versatility, independent research skills, strong customer service, and the ability to manage medium-sized projects with minimal supervision.

Please note that the position will require on-site work during the initial training period, which is expected to be approximately six months or longer based on training and operational needs. After the training period, remote or hybrid work may be considered in accordance with applicable City policy and directives, with the potential to work up to two days remotely, subject to position requirements and supervisor approval.

This position is open until filled and applications will be reviewed on a continuous basis. The first review of applications occurring on August, 31st, 2026.

EXAMPLES OF THE WORK PERFORMED (ILLUSTRATIVE ONLY)

• Leads innovative initiatives and researches new technologies; develops public-private partnerships; assists in development and implementation of citywide innovation strategies; collaborates with regional entities; attends technology conferences to stay abreast of new technologies.
• Researches, tests, and evaluates emerging and disruptive technologies as a solutions architect; makes recommendations on new technology solutions; identifies current trends and emerging capabilities, solutions, and technologies that will provide innovative value.
• Serves as technical lead, critical resource and subject matter expert (SME) in the discovery, evaluation and selection of innovative technologies (including in procurement); serves as SME on project teams and captures requirements, high-level scope, priority, details, and goals of initiatives.
• Develops custom solutions utilizing low-code or no-code technology to automate complex business processes.
• Develops scripts to automate common procedures
• Reverse engineers SQL database tables to provide automated solutions and reporting for enterprise applications.
• Performs regular maintenance on SQL databases.
• Defines application program interfaces to the database as appropriate.
• Provides Tier 3 application support for complex problems.
• Provides 24x7x365 emergency support for the IT infrastructure.
• Provides guidance and training to other members of the team.
• Other duties as assigned.

MINIMUM REQUIREMENTS

• Bachelor’s Degree in Computer Science, Management, or Information Systems or a closely related field.
• 3 years of general Information Technology experience to include 1 year of specialized IT experience in one or more of the following areas:
  1. SQL Database Administration
  2. SQL Database Schema Design
  3. Business Intelligence
  4. Programming
  5. Low-code or no-code solution development
• Or any combination of education, experience, and training equivalent to the above Minimum Requirements.

Public Safety Specific Positions

• Ability to pass an FBI background check, ACJIS training/testing and a Polygraph

DESIRED EXPERIENCE AND TRAINING

• 5-7 years of general Information Technology experience
• 3-5 years of specialized IT experience in one or more of the following areas:
  1. SQL Database Administration
  2. SQL Database Schema Design
  3. Business Intelligence
  4. Programming
  5. Low-code or no-code solution development
• Variety of IT Certifications or training in the following areas:
  1. SQL Database Administration
  2. SQL Database Schema Design
  3. Business Intelligence
  4. Programming
  5. Low-code or no-code solution development

OTHER REQUIREMENTS

• Must possess, or obtain upon employment, a valid Arizona driver’s license.
• Regular attendance is an essential function of this job to ensure continuity.
• While serving as Primary during a week-long 24-hour Public Safety On Call Support shift, individuals must remain within a one-hour travel distance of the Law Enforcement Administration Facility (LEAF) at 911 E Sawmill Road, Flagstaff, and be available for immediate on-site response.

CURRENT COMPENSATION AND BENEFITS:

We are dedicated to fostering an inclusive and positive work environment. We offer competitive pay, outstanding benefits and the chance to work with a committed team making a difference in our community. Located in the beautiful mountain town of Flagstaff, AZ, you’ll enjoy a unique quality of life with outdoor recreation, stunning scenery and a welcoming community.

Our total compensation package includes best-in-class benefits and an annual salary of $76,585.60 - $114,899.20, based on the candidate's qualifications and experience. Plus:

• Arizona State Retirement System with 100% Match
• Employees are members of Arizona State Retirement System (ASRS) with a mandatory contribution rate of approximately 12%
• Deferred Compensation Options
• Up to 4% Annual Pay for Performance Increase
• Group Insurance including Health, Dental and Vision coverage
• Flexible & Health Savings Accounts
• 13 Paid Holidays, Vacation, Sick Leave, Personal Leave, Paid Parental Leave, Bereavement, Jury Duty
• Life Insurance, AD&D, Short- and Long-Term Disability and Voluntary Life Insurance
• First-Time Homebuyer Assistance
• Qualified Public Student Loan Forgiveness Employer
• Tuition Assistance
• Employee Clinic, Telehealth, Wellness Program & Incentives
• Tobacco Cessation Program
• Employer Assistance Program
• Recognition includingWorkiversary, Wonderful Outstanding Worker (WOW), On-the-Spot, 7k Award, and City Manager's Excellence Awards
• Employee Discounts:Mountain Line Bus Eco Pass, Aquaplex, and Recreation Centers

Please note that Compensation and Benefits are subject to change based on future policy change, budgetary impact, and Council changes.

The City of Flagstaff is looking for team members who are passionate about community, innovation, and quality of life. Come be a part of this cool community and see why the City of Flagstaff is a great place to work!