Microsoft 365 Developer – Power Platform & Data Solutions

ECS is seeking a Microsoft 365 Developer – Power Platform & Data Solutions to work remotely.  

 

The Microsoft 365 Developer – Power Platform & Data Solutions is responsible for identifying business automation opportunities, designing structured data models, and delivering scalable solutions using Power Automate and Power BI.

This role requires the ability to translate complex business requirements into well-architected workflows, structured data environments, and executive-ready dashboards. The ideal candidate combines process engineering, automation development, and strong data modeling expertise within the Microsoft 365 ecosystem.

 

Core Responsibilities:

Use Case Development & Process Engineering

• Partner with business units to identify automation and reporting opportunities
• Conduct business process mapping (current-state / future-state)
• Develop structured use cases with defined inputs, outputs, dependencies, and success metrics
• Translate operational challenges into scalable Power Platform solutions
• Create functional and technical design documentation

Power Automate Architecture & Implementation (Primary Focus)

• Design and develop advanced Power Automate cloud and desktop flows
• Implement structured, reusable workflow frameworks
• Build multi-step approval processes, compliance routing, escalations, and exception handling
• Implement error handling, logging, retry policies, and monitoring
• Develop API integrations and custom connectors
• Integrate automation with:
• SharePoint Online lists and libraries
• Microsoft Teams
• Outlook / Exchange
• Dataverse
• Third-party SaaS systems
• Establish Dev/Test/Prod environment strategy and governance controls

Data Architecture & Structured Data Modeling (Critical Requirement)

• Design normalized and scalable data structures within:
• SharePoint lists
• Dataverse
• SQL (if applicable)
• Develop relational data models with clear entity relationships
• Define metadata strategy and taxonomy standards
• Implement data validation rules and governance controls
• Ensure data integrity and reporting compatibility
• Structure data to optimize:
• Automation performance
• Reporting accuracy
• Scalability
• Compliance tracking

Power BI Data Modeling & Reporting

• Develop Power BI dashboards aligned to defined business KPIs
• Build optimized data models using:
• Star schema design
• Fact and dimension tables
• Calculated columns and DAX measures
• Create automated reporting pipelines connected to SharePoint, Dataverse, or APIs
• Ensure data refresh automation and performance optimization
• Develop executive-level dashboards and operational reports
• Implement row-level security (RLS) where required

Salary Range: $100,000 - $115,000

General Description of Benefits

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience)
• 3–5+ years experience within Microsoft 365 / Power Platform
• Demonstrated experience building complex Power Automate workflows
• Strong experience designing structured data models
• Advanced Power BI development experience including DAX and data modeling
• Experience integrating APIs and REST services
• Strong understanding of relational data principles

Key Technical Skills

• Power Automate (Cloud & Desktop)
• Power BI (Data Modeling, DAX, RLS)
• D