Senior Power Platform Developer

We are seeking a highly analytical and experienced Senior Power Platform Developer to lead a high-priority modernization initiative. This role is centered on the transformation of a legacy Microsoft Access ecosystem into a high-performing, cloud-native solution.

The ideal candidate acts as both an architect and a developer—capable of diving deep into legacy VBA code and SQL queries to extract business logic, then reimagining that logic within the Microsoft Power Platform (GCCC-High environments). You will ensure that the new system is not just a "lift and shift," but a true modernization that improves scalability, security, and user experience.

Key Responsibilities

• Perform a forensic analysis of legacy MS Access databases, including complex relational schemas, hidden macros, and extensive VBA modules.
• Map legacy "DAO" or "ADO" database connections to modern Dataverse or Azure SQL structures.
• Document existing business rules to ensure zero loss of functionality during the transition.

• Design and develop Model-Driven Apps for complex data management and Canvas Apps for tailored, mobile-responsive user experiences.
• Utilize Power Apps Component Framework (PCF) or Custom Connectors where "out-of-the-box" features require extension.
• Apply modern UI/UX principles to replace dated Access forms, ensuring compliance with Section 508 accessibility standards.

• Architect modern data schemas in Dataverse or Azure SQL, optimizing for delegation, security, and reporting.
• Develop and execute ETL (Extract, Transform, Load) processes to migrate historical data while maintaining referential integrity.
• Cleanse and normalize "flat-file" legacy data into relational structures.

• Translate complex VBA event-driven logic into asynchronous Power Automate cloud flows.
• Implement "Pro-Code" solutions using C# plugins or Azure Functions for logic that exceeds standard Power Automate capabilities.

• Configure environment-level security, including Data Loss Prevention (DLP) policies.
• Implement granular Role-Based Access Control (RBAC) using Security Roles, Business Units, and Sharing Teams.
• Ensure all solutions meet government-specific encryption and auditing requirements.

• Lead the Application Lifecycle Management (ALM) process, moving solutions from Dev to Test to Production using Azure DevOps or GitHub.
• Create exhaustive technical documentation: Architecture Diagrams, Entity Relationship Diagrams (ERDs), and API Documentation.
• Facilitate Knowledge Transfer (KT) workshops for government IT staff to empower them for post-deployment maintenance.

Desired Skills

• Minimum 5+ years of experience with Microsoft Access, including expert-level VBA, SQL, and Macro deconstruction.
• 3+ years of dedicated experience building complex Power Platform solutions (Power Apps, Automate, Dataverse).
• Proven experience migrating at least two large-scale legacy databases to the cloud.
• Deep proficiency in T-SQL, including stored procedures, views, and performance tuning in Azure SQL.
• Familiarity with the unique constraints of government tenants (GCCC-High) or highly regulated industries (Finance/Healthcare).
•  Ability to produce "audit-ready" documentation.

•  Microsoft PL-200 (Functional Consultant), PL-400 (Developer), or PL-600 (Solution Architect) certifications preferred
• Hands-on experience with Azure Logic Apps, Azure Functions, and Key Vault.
• Experience using Power BI to replace legacy Access Reports with real-time, interactive dashboards.
• Basic understanding of JavaScript, TypeScript, or C# for Power Platform extensions.
• Experience with Power Platform Pipelines or managed solutions.