Power Platform Developer

AVER; Washington (District of Columbia); Remote; USD 155,000 - 190,000; Full time

Job summary

AVER seeks an experienced Power Platform Developer to architect, design, and build custom Microsoft Power Apps Canvas applications that connect to Oracle and Microsoft SQL Server databases without relying on Dataverse.

The role emphasizes full-stack skills, including HTML, CSS, JavaScript, APIs, and modern web tech, in a government-focused environment. Remote-friendly with local meetings in Springfield, VA.

Qualifications

• 15+ years of progressive software development experience, including hands-on Power Apps Canvas development
• Experience designing and building complex Canvas applications from requirements to production
• Advanced proficiency with Power Apps Canvas, Power Fx, components, forms, galleries, and app state management
• Strong experience integrating Canvas apps with SQL Server and Oracle databases
• Experience integrating with REST APIs, custom connectors, and enterprise integration services
• Knowledge of Power Platform security, deployment, and lifecycle management
• Ability to collaborate with cross-functional teams and stakeholders
• Excellent analytical, troubleshooting, and communication skills

Responsibilities

• Architect, design, develop, and maintain Power Apps Canvas applications for complex business processes
• Lead end-to-end Canvas app development including architecture, UI, data connectivity, logic, testing, deployment
• Create responsive front-ends using Power Apps controls, Power Fx, components, and custom UI
• Integrate with Oracle and SQL Server data sources using connectors and APIs
• Write and optimize SQL queries and PL/SQL for data retrieval and performance
• Collaborate with DBAs, integration engineers, and software teams for data access and integration
• Develop business logic, automate workflows with Power Fx and Power Automate
• Build or integrate REST APIs and custom connectors to support enterprise communication
• Ensure security, RBAC, authentication, and data access controls per federal requirements
• Support app lifecycle management, packaging, environment management, and deployments
• Guide stakeholders and teams on architectural improvements and best practices

Skills

Power Apps Canvas

Power Fx

SQL Server

Oracle PL/SQL

REST APIs

Full-stack development

UI design

Security concepts

Education

Bachelor's degree

Tools

PCF controls

TypeScript

HTML/CSS/JavaScript

Job description

AVER is seeking an experienced Power Platform Developer 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, preferred

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.