Power Platform Developer

Job Description

The Information Technology Software Developer III (Power Platform and Access) will act as a technical specialist responsible for the development, administration, and production support of enterprise business applications. This role requires expertise in modern software development frameworks, cloud technologies, database programming, and artificial intelligence development and integration.

The position requires a strong skill set in:

• Microsoft Access
• Visual Basic for Applications (VBA)
• Microsoft Power Platform:
  • Power Apps
  • Power BI Service / Report Builder
  • Power Automate
  • Dataverse
• Relational database programming
• .NET Framework
• C# or VB.NET
• Microsoft Foundry or Copilot
• GitHub Copilot

Responsibilities

• Design, develop, deploy, and maintain business applications using Microsoft Access.
• Develop low-code solutions using Microsoft Power Platform, including Power Apps, Power BI Service/Report Builder, and Power Automate.
• Convert legacy Access applications to Power Platform.
• Design and publish reports using Microsoft Power BI.
• Develop and maintain relational database components, including views, stored procedures, PL/SQL packages, functions, and complex SQL queries.
• Provide application development and production support.

Required Experience

Minimum 4 years of experience with:

• HTML
• XML
• CSS
• JavaScript
• SQL
• ASP.NET
• Umbraco
• AWS
• Power Platform:
  • Power Apps
  • Power BI Service / Report Builder
  • Power Automate
• Microsoft 365:
  • SharePoint
  • Teams
  • OneDrive
  • Access
• Webflow
• Nintex Forms / Workflow / API
• Dreamweaver
• Photoshop
• Oracle
• SQL relational database programming

Highly Desirable

• .NET Framework
• Object-oriented programming using C# or VB.NET
• AI-driven development in Microsoft Foundry or Copilot
• GitHub Copilot

Required Knowledge

• Reporting tools concepts and tool-specific functions
• Relational databases
• Data Definition Language (DDL)
• Tables, indexes, and views
• Unified Modeling Language (UML) concepts
• Object-oriented concepts
• Relational database objects
• Triggers, stored procedures, and packages
• Database query statements
• HTTP protocol
• Reports, sub-reports, and advanced reporting functions
• Stored procedure calls
• Relational database subqueries, outer joins, unions, cursors, and exception handling
• Middle-tier classes and interfaces
• Multi-threaded and collection of objects processing
• Website tools and web page design technologies
• Data warehouse star schema
• Dimensions and fact tables
• Data warehouse data management tools
• Extraction, transformation, and load (ETL) processors
• Business intelligence dashboards
• Current office technology and equipment

Required Skills and Abilities

• Develop, debug, and work with reporting tools.
• Invoke database management system objects, including views, packages, stored procedures, and functions.
• Work with relational database objects, including packages, stored procedures, functions, and cursors.
• Place application business logic and data validation in the appropriate software layer.
• Develop websites.
• Stay current with new technologies and approaches.
• Produce reports and understand reporting tools.
• Work with relational database triggers, stored procedures, cursors, and referential integrity objects.
• Access relational database vendor web tutorials and training documentation.
• Instantiate existing object-oriented classes.
• Invoke business logic objects from graphical user interface objects.
• Provide strategic and tactical planning for enterprise information systems.
• Develop prototypes.
• Use independent judgment and exercise discretion.
• Problem solve, prioritize, and multitask.
• Communicate clearly and concisely, both verbally and in writing.
• Establish and maintain effective working relationships.
• Work independently and in a team environment.
• Operate current office equipment, including computers and supporting applications.