PowerApps Developer
Salem, Oregon 97301 (REMOTE)
4 Months (Possible Extention)
Description

• Seeking an experienced developer with expertise in Microsoft Dynamics 365 (Model-Driven Apps and Portals), Power Automate, and .NET to support a range of initiatives. These include closing down the Wildfire Program, updating the Grid Resilience Grant application, completing a critical onboarding automation project, modernizing the public comment submission system, improving the IT Help Desk case management system, and reducing long-term Dataverse storage costs through optimized data handling and offloading. 

Key Responsibilities:
1. Grid Resilience Grant Application and Wildfire Development 

• Objective: Close the Wildfire Application and update the application to manage the Grid Resilience Grant lifecycle. 
• Tasks: 
• Meet with Client's Energy Development Services team to define workflows, data capture needs, approval processes, and reporting requirements. 
• Design and build the application using Dynamics 365 (Customer Service Hub or Model-Driven App). 
• Integrate Power Automate for notifications, status changes, and external communications. 
• Implement document generation (e.g., contracts, award letters) using Power Automate or third-party tools (e.g., DocumentsCorePack, Adobe PDF Services). 
• Deliverables: 
• Working application and workflows for Grid. 
• Closed down application for Wildfire. 
• User documentation and training guides 
• Test plan and system validation checklist 

2. Review & Completion of Employee Onboarding Automation 

• Objective: Assess and complete the automation for employee onboarding using Dynamics 365 and Power Automate. 
• Tasks: 
• Review the current Phase 1 implementation and provide feedback. 
• Assist with Phase 2 and 3 implementation including form autofill, PDF generation, and meeting scheduling. 
• Ensure completed forms (e.g., Work Schedules, Emergency Contact, LD Forms) are exported to formatted PDFs matching HR templates. 
• Deliverables: 
• Finalized automated onboarding process 
• Form-to-PDF export automation 
• Admin training materials 

3. Public Comments Portal Review and Modernization 

• Objective: Optimize the existing Power Apps Portals-based Public Comments site for usability and performance. 
• Tasks: 
• Review current portal structure, authentication, and back-end integration. 
• Recommend and implement improvements in UI/UX, accessibility, spam filtering, and workflow handling. 
• Ensure comment data is properly stored and accessible via internal review tools. 
• Deliverables: 
• Technical assessment report 
• Revised portal design and back-end workflows 
• Updated user guidance documentation 

4. IT Help Desk Case Management Improvements 

• Objective: Enhance the Dynamics 365-based Help Desk case system for better intake and internal workflow. 
• Tasks: 
• Redesign the case intake form to allow submission via both web form and direct email-to-case. 
• Improve categorization, prioritization, and status tracking. 
• Create dashboard views for IT staff to monitor incoming and active tickets. 
• Deliverables: 
• Updated Help Desk application 
• New intake workflows 
• IT dashboard and reporting views 

5. Dataverse Optimization and SQL Data Offloading 

• Objective: Reduce storage costs by reviewing and optimizing current use of Microsoft Dataverse. 
• Tasks: 
• Review all current Dataverse usage across apps and portals. 
• Identify tables and attachments suitable for offloading to on-premises or Azure SQL environments. 
• Develop automation or integration to extract and archive data periodically. 
• Deliverables: 
• Data offload strategy and architecture diagram 
• Automated extraction/export process 
• Storage cost analysis report with projected savings 

Required Qualifications:

• 5+ years of hands-on experience with Microsoft Dynamics 365 Customer Service, Power Automate, and Power Platform 
• Proficiency in Power Apps Portals and Dataverse schema optimization 
• Experience with .NET (C#) for backend integrations and service extensions 
• Demonstrated ability to produce form-driven PDF documents via automated workflows 
• Familiarity with SQL Server, Azure Data Factory, or related tools for data offloading

Additional Task:

• Provide code reviews and knowledge transfer to Client developers 
• Assist with deploying solutions to production using Client's ALM pipelines 
• Advises on future scalability and licensing optimization across Power Platform usage 

Timeline & Reporting:

• Kickoff:  
• Within one-two weeks of contract signing 
• Weekly progress check-ins with the Client Energy Incentives Manager & CIO 
• All deliverables to be submitted via agency-managed repositories (SharePoint, Azure DevOps) 

 

About Us: SPECTRAFORCE is one of the fastest-growing workforce solutions firms in the United States. As a diversity-owned business, we place human connection at the heart of everything we do, building strong relationships with both clients and candidates to fill roles successfully. Our teams in North and Central America and India serve more than 150 Fortune clients globally, leveraging custom AI technology to provide direct hire, executive search, nearshoring, offshoring, and project staffing solutions.
 
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.

Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
 
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
 
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer. 


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $50.00/hr.