Senior Power Apps / Power Platform SME

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.

Responsibilities Include:

• 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

Education Requirements:

• Bachelor’s Degree required

Experience Requirements:

• 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

Desired Requrements:

• 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

Location:

• Springfield, VA
• REMOTE, Local for Ad Hoc client meetings

Security Requirements:

• Ability to obtain and maintain a government Public Trust clearance

• This role supports a government agency which requires U.S. citizenship  

Compensation Package:  

At AVER, we believe our people are the foundation of our success and are committed to providing meaningful work, competitive compensation, and a supportive environment where employees can grow while making a direct impact on critical Government missions. AVER offers a competitive total compensation package designed to support our employees both professionally and personally. Eligible employees receive a comprehensive benefits package that includes health and wellness coverage, paid time off and holidays, retirement benefits, and opportunities for career growth.

Target Salary: $ 155,000.00 - $ 190,000.00 /yr.

About Us:

AVER, LLC is a Data & Digital Transformation company that delivers exceptional client service with great people and transformative technology solutions to enable Government mission success. We provide customers with specialized technical skills and deep subject matter expertise focused on Homeland Security, Biometrics, Law Enforcement, and Healthcare domains to meet the complex mission challenges of today and tomorrow.

We are a verified Service-Disabled Veteran-Owned Small Business (SDVOSB) committed to providing a customer-centric experience and building trusted partnerships with our clients and people.

AVER is an Equal Opportunity Employer/Veterans/Disabled.