DHHS MS Power Platform Developer

We are looking for a versatile and highly skilled Microsoft Power Platform Developer in the Division of Public Health providing primary support for the Health Hazard Control Unit (HHCU) within the Environmental Health section. The primary purpose of the position is to lead the design development and governance of low code and automation solutions and design build and support enterprise grade applications and databases. This hybrid role supports business automation initiatives while ensuring the reliability security and performance of SQL environments across the organization.

Key Responsibilities:
Design develop and deploy applications using Power Apps (Canvas & Model Driven) Power Automate and Dataverse
Integrate Power Platform solutions with SQL Server Microsoft 365 Azure and external systems
Develop and maintain SQL Server databases including schema design performance tuning and optimization
Create and maintain stored procedures views functions triggers and ETL processes
Design enterprise ready data models and build secure connections between Power Platform solutions and SQL databases
Implement governance ALM and environment strategies for Power Platform solutions
Ensure data integrity security and compliance across applications and databases
Troubleshoot Power Platform errors workflow failures and database performance issues
Collaborate with stakeholders to gather requirements and translate them into technical solutions
Maintain documentation diagrams and operational procedures
Support modernization automation and cloud adoption initiatives

Required Skills & Experience:
Strong hands-on experience with Power Apps Power Automate Dataverse and SQL Server
Expertise in T SQL development performance tuning indexing strategies and query optimization
Experience managing SQL Server instances (on premise and/or Azure SQL)
Understanding of data governance security roles and DLP policies
Experience integrating databases with APIs cloud apps and third party systems
Ability to interpret business needs and deliver scalable maintainable solutions
Strong analytical and troubleshooting capability

Preferred Qualifications:
Microsoft certifications: PL 400 or higher - Preferred
Experience with Power BI dataflows and enterprise reporting
Knowledge of SSIS SSRS

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.