15+)

InnoSoul•Raleigh, NC

1d•Hybrid

About The Position

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.

Requirements

Bachelor's degree in Computer Science, Information Systems, or a related field.
Required Experience in MS Power Platform development and implementation.
Proficiency in PowerApps, Power Virtual Agent, and Dataverse.
Knowledge of SQL database structure.
Strong SQL skills and experience integrating with databases
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.
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

Nice To Haves

Microsoft Certification-Power Platform Developer Associate (PL-400) or higher
Experience with Power BI, dataflows, and enterprise reporting
Knowledge of SSIS, SSRS

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