Power Platform Solutions architect

JOB Title:Power Platform Solutions Engineer

Client: City of Philadelphia

Duration: 04 Months

Location: Philadelphia, PA, 19145

Note: This is 100% remote role with virtual interview.

Job Description:

Lead the architecture and design of scalable Power Platform solutions across multiple departmental initiatives.

Provide governance and best practices for PowerApps, Power Automate, and Power BI deployments.

Collaborate with department leadership to translate business requirements into technical specifications.

Oversee integration with existing data sources, including SQL databases, SharePoint, and legacy systems.

Designs enterprise architectures including but not limited to Azure cloud deployments, improved ETL processes, and enhanced data storage.

Manages cloud resources, metrics, logs, load balancers, etc.

Designs solutions within the PPD Enterprise GIS environment to support PPD business requirements, fit technology stack and operating environments.

Work Activities:

Gather and document requirements from stakeholders

Translate business needs into technical specifications

Design scalable Power Platform architecture

Develop and deploy PowerApps (canvas/model-driven)

Build and maintain automated workflows in Power Automate

Ensure data integration with existing systems (SQL, SharePoint, etc.)

Define and implement security and governance policies

Develop custom connectors or components

Conduct testing and quality assurance of apps and flows

Provide user support and technical troubleshooting

Conduct stakeholder reviews and feedback sessions

Monitor and maintain operational flows and app performance

Create user guides, documentation, and training materials

Ensure accessibility, mobile responsiveness, and usability of PowerApps

Design and implement KPIs and performance indicators in Power BI

Manage versioning, deployments, and release schedules

Conduct regular team meetings and project updates

Adhere to data privacy and compliance standard

Required Skills:

Deep understanding of Power Platform and Microsoft Azure cloud environment: PowerApps, Power Automate, Power BI, and Dataverse

Proficiency with solution design, data modeling, application lifecycle management, and governance

Ability to define architecture for scalable, secure, and maintainable applications Knowledge of integration patterns with Azure, SQL Server, SharePoint, Dynamics 365, and thirdparty APIs such as ArcGIS

Expertise in CJIS and Microsoft security and compliance (role-based access control, DLP, auditing)

Strong documentation and diagramming skills (e.g., Visio, Lucidchart)

Required Experience:

5+ years of experience architecting solutions using Microsoft Power Platform and Microsoft Azure cloud environment

8+ years of IT experience in application development, enterprise systems, or cloud architecture

Experience designing solutions for highly regulated environments (e.g., criminal justice, public safety)

Familiarity with CJIS compliance or similar law enforcement data privacy frameworks

Experience mentoring developers and setting technical standards for a team