MS Power Platform Developer & Architect

SunTechPros Inc.; Raleigh (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

SunTechPros Inc. seeks a skilled MS Power Platform Developer/Architect to recreate a statewide billing system for North Carolina establishments. You will design and implement Power Platform solutions mirroring an end-of-life system, including data pipelines, Dataverse data, and invoicing automations.

You will integrate PayIt for online payments, handle checks, and ensure reconciliation with NCFS, all while documenting communications and maintaining an ALM across Dev/UAT/PROD environments.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field required.
• At least 3 years of MS Power Platform development/implementation experience.
• Proficiency with PowerApps, Power Virtual Agent, and Dataverse.
• Knowledge of SQL database structure.
• PL-400 or higher certification preferred.

Responsibilities

• Develop and architect Power Platform solutions to recreate legacy functionality.
• Build data pipelines: AWS-hosted SQL to Dataverse, enable census extraction for billing.
• Create and manage Dynamics-related automations to generate invoices and track payments.
• Integrate PayIt for online payments and reconcile payments with Dynamics.
• Log and reconcile checks, align records with NCFS requirements.
• Manage case management system communications and link related records.
• Develop reporting to monitor invoicing metrics and program performance.
• Establish an ALM environment across Development, UAT, and PROD with synchronized GUIDs.

Skills

Problem solving

Attention to detail

Verbal and written communication

Independent and team work

Time management

Education

Bachelor's degree in CS/IS or related field

Microsoft Power Platform certification (PL-400) or higher (preferred)

Tools

PowerApps

Power Virtual Agent

Dataverse

Job description

We are seeking a highly skilled and motivated MS Power Platform Developer/Architect to join our team.

Job Summary:

This position is needed to create a system to be used for statewide billing for establishments holding food, lodging, pool and tattoo permits. An existing software is end of life and due to be deprecated. The resource will be tasked with recreating the functionality of that system in Power Platform.

Responsibilities

Elements of the system will include: a pipeline to mirror SQL data held in an AWS hosted cloud DB down to Dataverse, where the lists of active facilities can be extracted to serve as the census for establishments to be billed. Automations linked to Dynamics records will create invoices, send them to email addresses on file, and track payments received or outstanding.

To facilitate the online payments, PayIt will beleveraged. We can direct payees to PayIt via their invoice emails, and PayItwill provide a report back to Dynamics to be consumed and converted into Payments records, corresponding to open Invoices which can then be marked closed.

Some payments will be received by check, in which case the Dynamics system will need to be capable of logging checks received, submitted to the controller, and reconciled in order to square our records to NCFS.

All communication around invoicing is to take place through the case management system, logging calls and emails with relationships defined to associated records (Contact, Case, Invoice for example).

A reporting system will be needed to look at invoicing metrics and program performance.

An essential requirement will be the creation of a robust ALM system using 3environments (Development, UAT and PROD) where guids and other components are synchronized throughout to allow for seamless promotion of new functionality.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• At least 3 years of experience in MS Power Platform development and implementation.
• Proficiency in PowerApps, Power Virtual Agent, and Dataverse.
• Knowledge of SQL database structure.
• Preferred: Microsoft Certification-Power Platform Developer Associate (PL-400) or higher
• Strong problem-solving skills and attention to detail.
• Excellent verbal and written communication skills.
• Ability to work independently and as part of a team.
• Ability to prioritize tasks and manage time effectively.

If you have a passion for innovation and are driven to deliver exceptional results, we would love to hear from you. This is a fantastic opportunity to be an active contributor to the development of public health infrastructure for the state of North Carolina.