Microsoft Power Apps Developer - Consultant

Amplytico; San Francisco (CA); Hybrid; USD 90,000 - 145,000; Full time

Job summary

Amplytico is seeking a talented Microsoft Power Apps Developer with strong Power BI expertise to design, develop, and maintain custom business applications on the Power Platform. You will build canvas and model-driven apps, connect to SharePoint, Dataverse, SQL Server, and external APIs, and create actionable Power BI insights.

The role requires 4+ years of hands-on Power Apps experience, strong data modeling skills, and the ability to translate business requirements into technical solutions.

Qualifications

• 4+ years of hands-on experience with Microsoft Power Apps (canvas and model-driven)
• Proficient in Power BI development, including complex reports and data modeling
• Advanced DAX formulas and measures
• Experience with Power Query (M language)
• Proven expertise in Power Automate for multi-step workflows and approvals
• Strong data connectivity with SQL Server, SharePoint, Excel, Dataverse, and external APIs
• Knowledge of environment security, sharing settings, RBAC, and data loss prevention
• Experience with responsive design for desktop, tablet, and mobile
• Strong troubleshooting across the Power Platform ecosystem
• Knowledge of Dataverse structure and relationships
• Experience with SharePoint Online integration with Power Platform
• Strong SQL knowledge for data querying and manipulation
• Excellent communication to translate technical concepts to non-technical stakeholders
• Legal authorization to work in the United States

Responsibilities

• Design, develop, and implement end-to-end solutions using Power Apps (canvas and model-driven)
• Create responsive interfaces for web and mobile apps with UX, performance, and accessibility
• Architect data integration across SharePoint lists, Dataverse, SQL Server, Excel and external APIs
• Develop Power BI reports, dashboards, and visualizations with data modeling
• Maintain secure data connections between Power Apps and Power BI with real-time sync
• Lead requirements gathering sessions and translate needs into technical specs
• Build automated workflows with Power Automate including approvals and notifications
• Create technical documentation: architecture diagrams, data models, processes, and user guides
• Debug and troubleshoot across the Power Platform ecosystem
• Monitor and evaluate new Power Platform features and adoption strategies

Skills

Power Apps development

Power BI development

Canvas apps

Model-driven apps

DAX

Power Automate

Data integration

SharePoint

Dataverse

SQL Server

Security & RBAC

Responsive design

Communication

US work authorization

Tools

SharePoint

Dataverse

SQL Server

Excel

Job description

We are seeking a talented Microsoft Power Apps Developer with strong Power BI expertise to join our team. In this role, you will design, develop, and maintain custom business applications using the Microsoft Power Platform while leveraging Power BI for data visualization and analytics solutions.

Key Responsibilities:

• Design, develop, and implement end-to-end solutions using Microsoft Power Apps, including canvas apps and model-driven apps tailored to specific business requirements
• Create sophisticated, responsive interfaces for web and mobile applications with attention to user experience, performance optimization, and accessibility standards
• Architect and implement complex data integration strategies connecting Power Apps with multiple data sources including SharePoint lists, Dataverse, SQL Server, Excel, and third-party APIs through custom connectors
• Develop comprehensive Power BI reports, dashboards, and visualizations that transform raw data into actionable business insights using DAX, M language, and advanced data modeling techniques
• Establish and maintain secure, efficient data connections between Power Apps solutions and Power BI reports, ensuring real-time data synchronization and appropriate access controls
• Lead requirements gathering sessions with business stakeholders, translating business needs into technical specifications and providing multiple solution options with pros and cons
• Build sophisticated automated workflows using Power Automate to streamline business processes, incorporating conditional logic, approvals, notifications, and error handling
• Create detailed technical documentation including solution architecture diagrams, data models, process flows, and comprehensive user guides for end-users and administrators
• Perform thorough debugging and troubleshooting across the Power Platform ecosystem, identifying root causes and implementing sustainable solutions
• Proactively monitor and implement new Power Platform features and updates, evaluating their potential impact and recommending adoption strategies

Qualifications:

• Minimum 4+ years of hands-on experience developing and deploying solutions with Microsoft Power Apps, including both canvas and model-driven applications
• Demonstrated proficiency in Power BI development, including creating complex reports, dashboards, and implementing data models using star schema design principles
• Advanced knowledge of DAX formulas and measures for data calculations and analysis in Power BI
• Experience with Power Query (M language) for data transformation and preparation
• Proven expertise in Power Automate (Microsoft Flow) for creating multi-step approval workflows, scheduled processes, and automated notifications
• Strong understanding of data connectivity options and experience integrating with various data sources including SQL Server, SharePoint, Excel, Dataverse, and external APIs
• Proficiency in configuring and managing environment security, including sharing settings, role-based permissions, and data loss prevention policies
• Experience implementing responsive design for applications that function across desktop, tablet, and mobile devices
• Demonstrated ability to troubleshoot and resolve complex issues within the Power Platform ecosystem
• Knowledge of Microsoft Dataverse (formerly Common Data Service) structure, entity relationships, and customization
• Experience with SharePoint Online list and library integration with Power Platform solutions
• Strong SQL knowledge for data querying, joins, and manipulation
• Excellent communication skills with ability to translate technical concepts to non-technical stakeholders
• Legal authorization to work in the United States

Preferred:

• Experience with Dataverse custom entities, forms, business rules, and plugins
• Experience with Azure services integration, including Logic Apps, Functions, and API Management
• SQL Server database design, optimization, and management experience
• Background in business process analysis and workflow optimization
• Experience implementing security and compliance requirements in enterprise environments
• Knowledge of Power Virtual Agents for chatbot development

Work Location:

This position requires onsite presence at client locations and/or our San Francisco office up to 2 days per week. Candidates must reside within a commutable distance of the San Francisco Bay Area. This position is hybrid (partial remote/partial onsite) and is not eligible for full remote work.

About Us:

Amplytico is a specialized consulting firm helping energy companies transform data into business value. We combine advanced analytics with deep energy sector knowledge to uncover insights that empower organizations to pioneer the future of energy services. Learn more at amplytico.com

Compensation:

As required by California law, the base salary range for this position in San Francisco is $90,000 to $145,000. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, the decision will be made on a case-by-case basis related to these factors.

Amplytico is an Equal Opportunity Employer. We do not discriminate based upon race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or any other applicable legally protected characteristics. We are committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, please contact us at [e-mail]