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.

Requirements

Skill

Required / Desired

Bachelor's degree in Computer Science, Information Systems, or a related field.

Required

Experience in MS Power Platform development and implementation.

Required

Proficiency in PowerApps, Power Virtual Agent, and Dataverse.

Required

Knowledge of SQL database structure.

Required

Strong SQL skills and experience integrating with databases

Required

Microsoft Certification-Power Platform Developer Associate (PL-400) or higher

Highly desired

Strong problem-solving skills and attention to detail.

Required

Excellent verbal and written communication skills.

Required

Ability to work independently and as part of a team.

Required

Ability to prioritize tasks and manage time effectively.

Required