IT AnalystProgrammer II Power AppTSQLSSRS

S R INTERNATIONAL INC; Phoenix (AZ); On-site; USD 70,000 - 95,000; Full time

Job summary

The City of Phoenix is seeking an IT Analyst/ Programmer II to support the Phoenix Fire Department Technical Services software solutions, including Power Apps, Power Automate, and Azure. The role requires on-site presence and collaboration with internal/external stakeholders to configure applications and automate workflows.

Applicants should have hands-on experience with MSSQL, SSRS, and scripting in PowerShell or Python for ETL tasks.

Qualifications

• Two years of business analysis and documentation experience.
• Two years (or more) of development experience in PowerApps, Power Automate/SharePoint.
• Two years (or more) of experience in cloud-based application support.
• One year (or more) of experience in MSSQL Database functionality.
• Analyze systems and procedures accurately, logically, and implement improvements.

Responsibilities

• Work with customers to configure business applications to meet needs.
• Communicate with stakeholders across technical levels; translate ideas into procedures.
• Document support procedures and establish business processes for applications.
• Perform daily system checks, monitor and respond to trouble tickets.
• Create, configure, and maintain Power Automate workflows and tasks.
• Create, configure, and maintain Power Apps deployments and pages.
• Connect and maintain data integration in Power Platform for SQL Server, SharePoint and APIs.
• Use T-SQL for data extraction and reporting; develop SSRS reports and ETL scripts in PowerShell/Python.
• Create, maintain, and schedule data delivery for user reports.
• Maintain interfaces and data transmission to state/federal agencies per policies.

Skills

Business Analysis & Documentation

PowerApps development

Power Automate

Cloud-based application support

T-SQL data extraction

SSRS reporting

ETL scripting (PowerShell/Python)

Systems analysis & improvements

Tools

Power Apps

Power Automate

SharePoint

SQL Server / MSSQL

SSRS

PowerShell

Python

Job description

Job Title: IT Analyst/ Programmer II (Power App, TSQL, SSRS)

Job ID: 164617 (Onsite-Local)

Client: City of Phoenix

Closing Date & Time: 8/19/2026@ 4 PM

Must haves:

• Two years of Business Analysis and documenting skills.
• Two years (or more) of development experience in PowerApps, Power Automate/ SharePoint.
• Two years (or more) of experience in cloud-based application support.
• One year (or more) of experience in MSSQL Database functionality.
• Analyze systems and procedures accurately, logically, and implement improvements.

Job Description

The Phoenix Fire Department Technical Services section is a customer service driven section that provides information technology solutions to the Phoenix Fire Department and several valley-wide fire agency partners. The Technical Services section provides leadership, technology planning, implementation, and support of specialized applications and systems required to meet the growing needs of the Phoenix Fire Department and its partners. This position provides primary software development and support for mission critical applications and requires on-site presence. This includes support for Power Apps, Power Automate, Azure and other assignments based on operational needs.

The primary job duties of this position:

• Work closely with internal/external customers and stakeholders to ensure that the business applications are configured to meet the needs of the Phoenix Fire Department.
• Communicate with people with different levels of technical knowledge, develop solutions to functional problems and transform abstract ideas into easily understood procedures.
• Document support procedures and knowledge-based documents and establish business processes for applications.
• Perform daily system checks, monitor, and respond to trouble tickets.
• Create, Configure, maintain Process automation workflows and automated tasks using Power Automate.
• Create, Configure, maintain Applications and Power pages using Power Apps.
• Connect and maintain Data Integration in the Power Platform for SQL Server, SharePoint and APIs.
• Programming knowledge of T-SQL for data extraction and report writing to create SSRS reports and PowerShell/ Python for ETL scripts to support various business needs.
• Create, maintain, and schedule jobs that provide timely data for users reports.
• Maintain system interfaces and data transmission to state and federal agencies to comply with policies and standards
• Ensure application security, manage environment compliance, and train end-users.
• Support and maintain mission critical cloud-based applications.
• Be on call (potentially nights, weekends, and holidays) to coordinate solutions for the primary applications’ support incidents that require immediate action.