Microsoft Power Applications Analyst

Reports to: Director of Technology
Employment Status: Full Time
FLSA Status: Exempt

Position Purpose:
The Microsoft Power Applications Analyst is responsible for designing, developing, and maintaining firm solutions using PowerApps, Power BI, PowerShell, and Azure technologies. The ideal candidate will collaborate with cross-functional teams to build automated workflows, interactive dashboards, and custom applications while ensuring integration with Azure services and Entra ID for enhanced security and efficiency. Work on various concurrent projects which progress at a pace driven by the firm's business objectives. The Microsoft Power Applications Analyst must also be able to demonstrate the following proficiencies:

Major tasks, Responsibilities and Key Accountabilities:

• Design, develop, and deploy custom applications using Microsoft PowerApps to address specific firm requirements.
• Create and maintain interactive dashboards and reports in Power BI, enabling data visualization and actionable insights.
• Write, maintain, and troubleshoot scripts in PowerShell for automation, integration, and system administration tasks.
• Integrate Power Platform solutions with Microsoft 365 services (e.g., SharePoint, Teams, Dataverse) and third-party systems.
• Develop workflows using Power Automate to streamline and automate repetitive tasks and processes.
• Leverage Azure services (e.g., Logic Apps, Azure Functions, Azure Storage) to extend and scale Power Platform solutions.
• Configure and manage authentication, permissions, and security using Entra ID (Azure Active Directory) and other identity management tools.
• Implement and maintain data governance, compliance, and security across Power Platform and Azure environments.
• Collaborate with stakeholders to gather requirements, troubleshoot issues, and deliver user-focused solutions.
• Stay current on emerging Power Platform, Azure, and Entra ID features, tools, and technologies to identify opportunities for innovation and improvement. Participate in projects for new software implementation and upgrades.
• Participates in the development and management of software requests and updates.
• Provides quality assurance testing for compatibility issues and continuity of knowledge base and SOP documentation.
• Performs other miscellaneous duties as assigned.

Qualifications:

• Proven experience in building applications using Microsoft PowerApps.
• Proficiency in developing Power BI dashboards, and data models.
• Hands-on experience with PowerShell scripting for system administration and automation.
• Familiarity with Azure services, such as Logic Apps, Azure Functions, and Azure Storage, for building and extending business solutions.
• Proficiency in managing authentication, permissions, and access control using Entra ID (Azure Active Directory).
• Experience with Power Automate for creating workflows and automating processes.
• Familiarity with Dataverse, SharePoint, SQL, and other common data sources used with the Power Platform.
• Understanding of REST APIs, OData services, and other integration techniques.
• Strong problem-solving and troubleshooting skills.
• Must be willing to be accessible during off hours to monitor application servers and take action where appropriate.
• Certifications in Microsoft Power Platform (e.g., PL-100, PL-200, PL-400) and Azure (e.g., AZ-900, AZ-104, AZ-204) are a plus.
• Experience in integrating Power Platform solutions with Azure identity and access management.
• Previous experience in IT administration or support roles with a focus on Azure and Power Platform.

General Competencies Required:

• Writes clearly, accurately, and concisely.
• Maintains confidentiality and the highest ethical standards dealing with confidential firm end user and client data.
• Follows all policies and procedures.
• Able to deal with frequent changes, delays, or unexpected events.
• Strong customer service orientation
• Strong verbal communications skills

Education:

• Bachelor's degree in computer science, Information Systems, or a related field, or equivalent experience.

ADA: The employer will make reasonable accommodations in compliance with the Americans with Disabilities Act of 1990.

This job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and marginal job functions are subject to modification.