Microsoft 365 Developer – Power Platform & Data Solutions
About The Position
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.
Requirements
- 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
- Power Automate (Cloud & Desktop)
- Power BI (Data Modeling, DAX, RLS)
- Dataverse
- SharePoint Online structured list design
- Microsoft Graph API
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
