What are the responsibilities and job description for the Senior Power Platform Developer position at Leverage Technologies?
Job Details
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.