About This Role
This developer role focuses on leveraging the Microsoft Power Platform to design, develop, and implement scalable solutions for the State of Maryland. The work involves streamlining business processes and enhancing operational efficiency through user-friendly applications, automated workflows, and insightful data visualizations. The role suits a developer eager to shape the future of enterprise solutions through cutting-edge technology and collaborative problem-solving.
Responsibilities
- Design, build, and test canvas and model-driven Power Apps, Power Automate flows, and Dataverse data models for the Agency under the direction of the Systems Development Unit
- Build custom connectors and Azure Functions in C# to integrate with existing MPAS .NET Web APIs and SQL Server data
- Implement solution-based ALM (managed solutions, environments, deployment pipelines)
- Configure security roles and Entra ID integration
- Maintain and enhance existing Power Platform and Dynamics 365 solutions
- Debug and fix defects
- Conduct unit, integration, and system testing
- Create technical documentation
- Participate in code reviews
- Follow all Agency and State software development guidance
Requirements
- 3+ years of experience with Power Platform (Power Apps canvas and model-driven, Power Automate, Dataverse)
- 3+ years of C#/.NET for custom connectors and Azure Functions
- Entra ID authentication and authorization
- Solution-based ALM
- SQL Server and T-SQL
- Excellent written and verbal communication
- Strong analytical skills
- Proven experience in software development with a focus on application development within enterprise environments
- Strong knowledge of IT infrastructure, cloud platforms (Azure, AWS), and web development frameworks such as React Express
- 8+ years of T-SQL development (stored procedures, functions, views, triggers)
- Schema design and data modeling
- Execution plan tuning
- SQL Server 2016+
- Leadership and/or leading a dev team in agile
- 5+ years of Pension Administration system experience
Nice to have:
- Microsoft Dynamics 365 Customer Engagement customization (plug-ins, Dataverse Web API / OData)
- Integrating Power Platform solutions with .NET Web APIs and enterprise identity providers such as SecureAuth
- Power BI
- Azure DevOps and GitHub
- SSIS and SSRS
- Database source control and migration tools such as Flyway or Redgate
- Entity Framework Core data access patterns and how application code consumes database objects