Solutions Architect

Position overview / Statement of Work

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.

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 third-party 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.