Business Applications Analyst
Core
Design, develop, and maintain business applications and automated workflows using Microsoft Power Platform and SQL to optimize operational efficiency.
Role type
Business Applications Analyst (Power Platform & SQL)
Builds
Power Apps (Canvas and Model-Driven), Power Automate flows, Power BI reports/dashboards, SQL queries/stored procedures
Domain
Enterprise software development, data analytics, business process automation
Required skills
Power Apps development, Power Automate cloud flows, Advanced SQL (joins, subqueries, CTEs, stored procedures), DAX calculations, Data modeling, API integration, Relational database management
Preferred skills
Microsoft Dataverse, Power BI administration, Azure SQL/Data Services, Power Automate Desktop (RPA), Git/Azure DevOps, Power Query (M language), Agile/Scrum methodologies
Technologies
Microsoft Power Platform (Apps, Automate, BI), SQL Server, SharePoint, Microsoft 365, REST APIs, Azure SQL, Azure Data Services
Responsibilities
Design and maintain Power Apps and automated workflows; Develop and optimize SQL queries and database views; Create advanced Power BI reports and dashboards; Integrate Power Platform solutions with enterprise systems; Analyze business requirements and translate them into technical solutions; Monitor application performance and troubleshoot production issues; Document technical solutions and business processes
Seniority
Mid-level, hands-on IC