Job ID: SC-9948 (910490301)
Hybrid/Local PowerApps Developer with Power Automate, Dynamics 365, SECURITY, PowerShell/Scripting/C#, ALM, Dataverse, REST APIs, Power BI, TICKETING SYSTEM, CDC/HIPAA/CJIS and Azure DevOps experience
Location: Columbia, SC (DPH)
Duration: 12 Months
Work Location: Hybrid, 4 Days Onsite and 1 Day Remote per week
Candidate location: Candidate MUST currently reside in the Eastern Time Zone AND be willing to relocate to SC prior to starting the role at their own expense.
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
1. 3+ Years of Experience with PowerApps (Canvas + Model-driven)
2. 3+ Years of Experience with Power Automate
3. 3+ Years of Experience with Dataverse Tables, relationships, business rules; Security roles & row- level security
4. 3+ Years of Experience with Dynamics 365
5. 5+ Years of experience with Scripting – PowerShell, JavaScript + C#
6. 5+ Years of Experience with Integrations using REST APIs, custom connectors, SharePoint
7. 3+ Years of Experience with Power BI
8. 3+ Years of experience with Azure DevOps
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
1. EXPERIENCE WITH SECURITY AND DATA CLASSIFICATION RELATED TO CDC, HIPAA, AND CJIS.
2. EXPERIENCE WITH NIST STANDARD INFORMATION SECURITY PRACTICES
3. EXPERIENCE WORKING WITH MODERNIZATION INITIATIVES THROUGHOUT ENTIRE SDLC
4. EXPERIENCE RESPONDING TO TICKETS WITHIN A TICKETING SYSTEM
ADDITIONAL SKILLS
1. Ability to deal effectively with the needs of technical peers, technical and user management, users, vendors, and staff members, and to communicate clearly and effectively in spoken and written form
REQUIRED EDUCATION: Bachelor’s or Master’s
Degree in a relevant field of work or equivalent work experience.
SCOPE OF THE PROJECT:
Due to the volume of agency financial and administrative systems that need to be migrated to agency standard platforms, upgrade and streamline upgrade aged components, and modernization efforts, additional staff is needed to support these efforts and system implementation. The team will work to align business needs with current and future state to ensure systems are set up and supported following industry best practices to ensure strategic initiatives and compliance with federal and state regulatory laws and ensure business continuity.
DAILY DUTIES / RESPONSIBILITIES:
Emphases for the MS Power Platform Developer candidate will be part of a team focusing on agency efforts to design, build, and implement solutions that support modernization of financial and administrative systems. The Developer will leverage Microsoft Power Platform tools (Power Apps, Power Automate, Power BI) and Dynamics 365 to create applications, workflows, and integrations that meet business needs. This role requires strong technical expertise to configure and customize solutions, analyze data, and ensure compliance with security standards. The Developer will collaborate with system owners and subject matter experts (SMEs) to gather requirements, design future-state workflows, and deliver scalable solutions. Responsibilities include developing and testing applications, creating dashboards and reports, troubleshooting issues, and supporting deployment activities. The candidate will work in a team environment with other IT staff and program area SMEs to ensure successful implementation and operational support.
Specific duties and responsibilities will include but are not limited to the following:
• Design and build low-code business applications using Microsoft Power Apps.
• Develop Model-Driven Apps including forms, views, and dashboards.
• Customize and configure Dynamics 365 applications (Customer Service, Field Service, Finance & Operations – role dependent).
• Automate business processes and approvals using Power Automate.
• Implement customization and configuration using JavaScript for form scripting.
• Develop C# plugins and custom workflows for Dynamics 365.
• Create Power Automate flows for automation of business process flows.
• Integrate solutions with Web APIs and Azure Functions.
• Perform ERP/CRM integrations and data migrations.
• Configure security including role-based access and field security profiles.
• Manage Application Lifecycle Management (ALM) including solution management, upgrades, and patching.
• Customize and extend Dynamics 365 applications and Dataverse data models.
• Configure entities (tables), forms, views, and dashboards.
• Implement complex business logic and optimize performance.
• Integrate Dynamics 365 with external systems (SharePoint, SQL, ERP, CRM, third-party tools).
• Collaborate with business stakeholders to gather requirements and translate them into technical solutions.
• Troubleshoot, optimize, and maintain apps, flows, and integrations.
• Support production deployments and post-go-live enhancements.
• Ensure performance, security, and scalability of all solutions.
• Maintain system protocols by writing and updating procedures.
• Provide technical guidance to functional consultants and project teams.
• Translating business requirements into working solutions
• Supporting users after go-live (bugs, enhancements)
• Adheres to Information Technology application development standards and security requirements.
• Maintain system documentation
• Assist with development of policies and procedures to conform and comply with agency standard cyber security policy design related to information risk management, designation of data as to criticality, confidentiality, and protection. (NIST 800-53, FISMA, SC InfoSec Requirements http://admin.sc.gov/technology/information-security/policies-and-procedures, etc.)
SCMSP_Candidate_Cover_Sheet_Updated (1).docx