Job Description 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
Required Skills - 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)
- Dataverse
- SharePoint Online structured list design
- Microsoft Graph API
Desired Skills - PL-400: Power Platform Developer
- PL-300: Power BI Data Analyst
- Experience in regulated enterprise or government environments
- Knowledge of Azure Logic Apps, Azure Functions, or SQL Azure
- Experience with Dataverse architecture
Technical skills: - REST APIs
- JSON
- SQL fundamentals
- Azure AD / Entra ID
Security, Governance & Compliance - Implement role-based access control (RBAC)
- Align automation and reporting with enterprise data governance standards
- Apply DLP policies within Power Platform
- Support compliance requirements (NIST, ISO, SOC2, etc.)
- Maintain structured documentation and audit trails
#ECS1
ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis any characteristic protected by law. All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, or local jurisdiction law.
ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3200+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.
Never miss an opportunity! Create an alert based on the job you applied for.
