Power Apps Developer
20 hours ago
Washington
Job DescriptionTrilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our collaborative, client-first service approach, combined with our commitment to the rapid implementation of pragmatic solutions, has earned Trilogy an unparalleled reputation for delivering transformative results. The Power Apps Developer will play a critical role in designing and delivering low-code, cloud-based business applications and analytics solutions leveraging the Microsoft Power Platform. The position focuses on automating complex approval workflows, integrating multiple data sources, and providing interactive dashboards and reporting to enhance operational visibility and decision-making across VA enterprise programs. This role will play a critical part in the design, development, and deployment of a sophisticated, enterprise-grade automated request submission tool for Veterans Health Administration. This role demands a highly skilled professional with extensive experience in designing, customizing, and integrating solutions across the Microsoft Power Platform, especially Power Apps and Dataverse as well as SharePoint and involves working with a sophisticated environment where multiple SharePoint sites function as interconnected data sources. This individual will be responsible for developing and integrating complex Power Apps that pull and push data across these SharePoint sources, crafting automated workflows with Power Automate, and ultimately designing Power BI dashboards that weave all this data into a coherent and insightful story. This position requires creative solution development, considering workarounds and scalability while employing innovative approaches to overcome limitations and ensure the long-term scalability of the tools built. The individual will work in close collaboration with product owners, Subject Matter Experts, business analysts, and other cross-functional stakeholders to deliver secure, scalable, and user-centric solutions that automate complex business processes. Primary Responsibilities: • Help lead the end-to-end architecture, design, and delivery of solutions utilizing SharePoint, Power Apps (Canvas and Model-driven), Power Automate, and Dataverse., • Serve as the principal technical advisor for the team regarding Power Platform capabilities and limitations, and enterprise integration patterns., • Establish technical best practices and mentor junior developers and power users., • Facilitate discovery sessions and requirements workshops with business users, process owners, and VA leadership to elicit and document functional, non-functional, and security-related requirements., • Translate stakeholder requirements into clear technical specifications, process models, and data schemas., • Develop advanced, data-driven Power Apps and Power Automate flows to automate intake, triage, review, and approval workflows with complex logic and role-based routing., • Build and maintain custom connectors, reusable controls, and components using Power Fx and available APIs., • Design and implement integrations between Power Platform, SharePoint, Microsoft Teams, Outlook, and external systems via Dataverse, APIs, and connectors., • Design, build, and maintain Power BI dashboards and reports that visualize operational performance, workload distribution, timelines, and compliance metrics., • Develop responsive, role-based dashboards for task management, routing, and process status tracking., • Implement dynamic business rules, data validation logic, and user access control to support multi-level workflows., • Develop secure integrations between Power Platform, Microsoft 365, and external systems via Dataverse, REST APIs, and SQL endpoints., • Plan and conduct robust data migration strategies, including data mapping, transformation, cleansing, and integrity validation tasks from legacy data sources into Dataverse., • Develop and perform unit, integration, and user acceptance tests; resolve issues and optimize application performance., • Produce, maintain, and update comprehensive technical design documents, system architecture diagrams, runbooks, end-user training materials, and knowledge base articles as required., • Participate in all phases of the software development lifecycle, including sprint planning, daily standups, and retrospectives following Agile/Scrum or Kanban methodologies., • Partner with product owners, business analysts, and functional SMEs to translate business requirements into technical solutions., • Conduct unit, regression, and user acceptance testing to validate functionality and optimize performance., • Create and maintain technical documentation, architecture diagrams, and user guides., • Participate in Agile ceremonies (sprint planning, daily standups, retrospectives) and contribute to backlog refinement., • Estimate development efforts, track progress, and support status reporting to project stakeholders., • Develop secure integrations between Power Platform, Microsoft 365, and external systems via Dataverse, REST APIs, and SQL endpoints., • Support data migration activities — mapping, transformation, cleansing, and validation from legacy tools to new Power Platform environments., • Ensure compliance with VA’s data governance, security, and ATO requirements., • Maintain robust audit trails, error handling, and data lineage tracking., • Partner with product owners, business analysts, and functional SMEs to translate business requirements into technical solutions., • Conduct unit, regression, and user acceptance testing to validate functionality and optimize performance., • Create and maintain technical documentation, architecture diagrams, and user guides., • Participate in Agile ceremonies (sprint planning, daily standups, retrospectives) and contribute to backlog refinement. Minimum Requirements:, • Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related field., • Minimum 8 years of progressive experience in designing and developing enterprise SharePoint solutions (including SharePoint Online and Office 365)., • Experience architecting and building custom business applications with Microsoft Power Apps and Power Automate., • Experience in executing complex data migrations into Microsoft Dataverse, involving design, extraction, transformation, and load, as well as validation., • Demonstrated mastery of: SharePoint Online, including document management, site design, list/library customization, permissions, and REST API integration, Power Apps (Canvas and Model-Driven), Power Automate, and Dataverse schema design, Power Fx, JSON, JavaScript, HTML5Custom connector development, use of Microsoft Graph API, and Azure integration (Azure Logic Apps, Azure Functions), • Exceptional written and verbal communication skills, with a proven ability to explain technical solutions to both highly technical and non-technical audiences., • Transform raw data into actionable insights through data modeling, DAX measures, and Power Query transformations., • Implement data refresh schedules, access security, and row-level permissions for sensitive datasets., • Integrate Power BI reports directly into Power Apps, SharePoint, and Microsoft Teams to enable real-time analytics and leadership reporting., • Collaborate with stakeholders to define key performance indicators (KPIs) and data-driven success metrics., • Ability to obtain a Public Trust Clearance. Preferred Qualifications:, • Experience supporting the Department of Veterans Affairs., • Microsoft Certified: Power Platform Developer Associate (PL-400), Power Platform Solution Architect, or equivalent., • Experience with advanced customization using SharePoint Framework (SPFx), React, and related SP add-ins., • Power Platform environment and security administration, DLP policy configuration, and tenant-level governance., • Proven experience creating intuitive, user-friendly interfaces using Power Platform, UX best practices, and Office UI Fabric. Benefits (including but not limited to):, • Health, dental, and vision plans, • Optional FSA, • Paid parental leave, • Safe Harbor 401(k) with employer contributions 100% vested from day 1, • Paid time off and 11 paid holidays, • No cost group term life/AD&D plan, and optional supplemental coverage, • Pet insurance, • Monthly phone and internet stipend, • Tuition and training reimbursementThis range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.Regarding remote positions, Trilogy Federal is able to offer virtual employment in the following states: Colorado, Connecticut, D.C., Florida, Georgia, Illinois, Maryland, New York, South Carolina, Texas, and Virginia. Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.