Yale University

Compensation

Full Description

Job Title: Microsoft Power Platform Solutions Architect Duration: 4 months Location: Remote Key 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 • Define and implement security and governance policies • Provide user support and technical troubleshooting • Conduct stakeholder reviews and feedback sessions • Coordinate timelines and deliverables • Design and implement KPIs and performance indicators in Power BI • Conduct regular team meetings and project updates • Adhere to data privacy and compliance standards • Develop and deploy PowerApps (canvas/model-driven) • Build and maintain automated workflows in Power Automate • Create dashboards and reports in Power BI • Ensure data integration with existing systems (SQL, SharePoint, etc.) • Develop custom connectors or components • Conduct testing and quality assurance of apps and flows • Monitor and maintain operational flows and app performance • Create user guides, documentation, and training materials • Ensure accessibility, mobile responsiveness, and usability of PowerApps 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