Senior Power Apps / Power Platform SME

AVER•Washington, DC

1d•$155,000 - $200,000•Hybrid

About The Position

AVER is seeking an experienced Senior Power Apps / Power Platform SME with deep hands-on expertise in architecting, designing, and developing custom Microsoft Power Apps Canvas applications. The ideal candidate combines advanced Power Platform development skills with a strong foundation in full-stack software engineering, relational databases, and application integration. This role focuses on developing sophisticated, user-friendly applications and custom front-end interfaces that integrate data from Oracle and Microsoft SQL Server databases without relying on Microsoft Dataverse. The successful candidate will have experience with SQL, Oracle PL/SQL, Power Fx, APIs, and modern web development technologies to deliver scalable, secure, and high-performing applications. The developer will collaborate with a dedicated integration team to support data connectivity and interoperability across enterprise systems. Join a collaborative team that values AVER's mission, focus, and culture of delivering exceptional client service through great people and transformative technology solutions that ensure Government mission success.

Requirements

Bachelor’s Degree required
15+ years of progressive software development experience, including significant hands-on experience architecting and developing custom Microsoft Power Apps Canvas applications
Demonstrated experience independently designing and building complex Canvas applications from initial requirements through production deployment
Advanced proficiency with Microsoft Power Apps Canvas development, Power Fx, reusable components, forms, galleries, variables, collections, and application state management
Strong experience integrating Canvas applications with Microsoft SQL Server and Oracle databases, including data retrieval, manipulation, validation, and performance optimization
Working proficiency with SQL and Oracle PL/SQL, including the ability to understand, write, and troubleshoot queries, stored procedures, and database interactions
Experience integrating applications with REST APIs, custom connectors, and enterprise integration services
Experience developing custom business logic, automating workflows, and troubleshooting application performance issues
Understanding of Power Platform security, environment management, deployment, and application lifecycle management
Ability to collaborate with cross-functional teams, including database administrators, integration engineers, business analysts, and technical stakeholders
Excellent analytical, troubleshooting, communication, and problem-solving skills

Nice To Haves

Experience developing custom Power Apps Component Framework (PCF) controls using TypeScript, JavaScript, HTML, and CSS
Experience with traditional full-stack development technologies such as C#, .NET, ASP.NET Core, JavaScript, TypeScript, or modern front-end frameworks
Experience developing and consuming RESTful APIs and implementing integration solutions across heterogeneous enterprise environments
Experience with Power Platform Center of Excellence (CoE), governance, security architecture, and enterprise deployment standards
Experience with Azure services, Azure Functions, API Management, and related integration technologies
Experience with Microsoft Power Automate for workflow orchestration and business process automation.
Familiarity with Power BI, reporting interfaces, and data visualization
Experience with CI/CD, Azure DevOps, Git, and automated application deployment
Experience developing secure enterprise applications within federal government environments

Responsibilities

Architect, design, develop, enhance, and maintain custom Microsoft Power Apps Canvas applications supporting complex business processes and mission-critical operations
Lead end-to-end Canvas application development, including application architecture, user interface design, data connectivity, business logic, testing, deployment, and sustainment
Design intuitive, responsive, and user-friendly front-end interfaces using Power Apps Canvas controls, Power Fx, reusable components, and custom UI capabilities
Leverage full-stack software development experience, including HTML, CSS, JavaScript, and related web technologies, to support custom interface development and advanced application functionality
Develop applications that connect to and consume data from Oracle and Microsoft SQL Server, using appropriate connectors, APIs, and integration services without dependence on Dataverse
Write, analyze, and troubleshoot complex SQL queries and Oracle PL/SQL to support application functionality, data retrieval, and performance optimization
Collaborate with database administrators, integration specialists, and software development teams to design efficient data access and integration solutions
Design and implement application business logic, workflows, data validation, and automation using Power Fx, Power Automate, and related technologies
Develop or integrate REST APIs, custom connectors, and other services as needed to support communication across enterprise systems.
Troubleshoot and resolve complex applications, database connectivity, integration, and performance issue
Apply best practices for Power Apps delegation, performance optimization, error handling, and maintainable application architecture
Implement appropriate application security, role-based access, authentication, and data access controls in accordance with federal security requirements
Support Power Platform application lifecycle management, including solution packaging, version control, environment management, testing, and deployment
Collaborate directly with stakeholders, business analysts, and technical teams to translate operational requirements into functional, scalable application solutions
Provide technical guidance, recommend architectural improvements, and support development standards and best practices