Job Description

Summary:
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.

Job Description

Summary:
We are seeking a 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 to design, build, and support applications and automation solutions that streamline business processes across the organization. This role focuses on developing enterprise-grade Power Apps, automated workflows, and integrated business solutions using the Microsoft Power Platform ecosystem.
Key Responsibilities:

• Design, develop, and deploy solutions using Power Apps (Canvas & Model‑Driven),
Power Automate, and Dataverse

• Create automated workflows to improve business efficiency and replace manual
processes

• Build and optimize Dataverse tables, business rules, relationships, and logic

• Integrate Power Platform solutions with Microsoft 365, Azure services, SQL
Server, REST APIs, and third‑party systems

• Develop custom connectors, data models, and forms for enterprise applications

• Troubleshoot application issues, workflow failures, and performance problems

• Collaborate with business users to gather requirements and translate them
into functional solutions

• Maintain documentation including design specifications, diagrams, and user
guides

• Follow best practices for environment strategy, security, ALM, and governance

• Work with security roles, DLP policies, and administrative processes to
ensure solution compliance

Required Skills & Experience:

• Hands-on experience with Power Apps (Canvas & Model‑Driven) and Power
Automate

• Experience working with Dataverse, data modeling, and business logic

• Ability to build workflows, connectors, forms, and custom components

• Strong understanding of Microsoft 365 (Teams, SharePoint, Outlook)
integrations

• Strong SQL skills and experience integrating with databases

• Familiarity with REST APIs, JSON, and modern integration practices

• Strong analytical, problem‑solving, and communication skills

Preferred Qualifications:

• Experience with Power BI, Power Pages, or RPA/Power Automate Desktop

• Experience with Azure DevOps/GitHub CI/CD

• Microsoft certifications such as PL‑400 or higher
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.