Notes :

MSPE letters are mission-critical for students' residency applications
Volume: 1,000 1,500 letters per season
Letters must be uploaded to ERAS during the September October submission window
Success criteria: letters produced correctly, delivered on time, and meet compliance requirements
Engagement Duration: Through UAT and production deployment

Profile :

MS Power Platform Developer, 10+ years of experience including 5+ years of experience with Power Automate
Advanced Power Automate skillset with strong understanding of Power BI and data integration
Ability to design and implement interaction between Power BI and Power Automate
Experience connecting Microsoft Power Platform with cloud based data solutions (Google Cloud Storage, BigQuery preferred)
Familiarity with data pipelines and API-based integrations across cloud environments
Proven track record of delivering Power Automate workflows on tight deadlines
Proactive collaborator and communicator with both business and technical stakeholders

Responsibilities

Design and implement automated workflows using Power Automate to:
- Extract PDF reports from Power BI
- Store PDFs in Google Cloud Storage
- Generate URLs for stored files
- Update Eloqua objects for student notifications
Solve technical integration challenges between Power BI, GCP, and BigQuery
Ensure workflows include error handling, audit logging, and compliance safeguards
Deliver a fully functional solution by April 1

Requirements

Advanced experience with Power Automate and API integrations.
Strong understanding of Power BI outputs and workflow automation.
Ability to design scalable document-generation processes.
Familiarity with Google Cloud Storage and BigQuery (preferred but not required).

Technical Skills

Bonus Skill

Background in higher education systems or working with SIS environments (Ellucian, Banner, etc.).

Additional Details:

Data Flow & Infrastructure

Key Technical Puzzle for the Candidate

How will Power Automate integrate with:
- Power BI
- Google Cloud Storage (GCP)
- BigQuery
This integration path is not yet clear, and the incoming resource will need to solve it.

Power Platform Developer