Senior Solutions Architect

Roles/Responsibilities:

• 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
• 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
• Monitor and maintain operational flows and app performance
• 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 standards

Mandatory Skills:

1. Deep understanding of Power Platform and Microsoft Azure cloud environment: PowerApps, Power Automate, Power BI, and Dataverse
2. Proficiency with solution design, data modeling, application lifecycle management, and governance
3. Ability to define architecture for scalable, secure, and maintainable applications
4. Knowledge of integration patterns with Azure, SQL Server, SharePoint, Dynamics 365, and third-party APIs such as ArcGIS
5. Expertise in CJIS and Microsoft security and compliance (role-based access control, DLP, auditing)
6. Strong documentation and diagramming skills (e.g., Visio, Lucidchart)
7. 5+ years of experience architecting solutions using Microsoft Power Platform and Microsoft Azure cloud environment
8. 8+ years of IT experience in application development, enterprise systems, or cloud architecture
9. Experience designing solutions for highly regulated environments (e.g., criminal justice, public safety)
10. Familiarity with CJIS compliance or similar law enforcement data privacy frameworks
11. Experience mentoring developers and setting technical standards for a team

Desirable Skills: N/A