Microsoft Excel Power Automate Developer

Job Title: Microsoft Excel & Power Automate DeveloperLocation: RemoteContract Duration: Project-Based (Estimated 1–3 Months, Part-Time)Pay Rate: $45–$55/hourContract Type: 1099 (Independent Contractor Only) Project Overview:We are seeking an experienced Microsoft Excel & Power Automate Developer to design and implement a custom-built, end-to-end financial automation tool tailored to our firm’s internal consulting operations. This project will involve building a self-contained solution (non-subscription based) that streamlines how we manage and track consultant and employee billing, payroll, invoicing, and margin reporting.The final product will allow our team to input bill rates and pay rates and generate dynamic outputs such as margin projections vs. actuals, partner revenue tracking, and firm-level financial summaries. Additionally, the tool must integrate invoice tracking, allow for standardized hour submissions, and generate client-facing invoices and internal revenue dashboards, all powered by Excel logic and Power Automate flows. Scope of Services & Key Deliverables: Design and develop a fully functional Excel-based financial tool integrated with Power Automate workflowsCreate input fields for consultant/employee pay rates, bill rates, and monthly hoursGenerate outputs including: Margin Projections vs. ActualsConsultant and Partner RevenueFirm-level Revenue & Profitability TrackingStandardized, auto-filled client invoices for approval Develop standardized invoice entry forms for time tracking (per consultant/employee)Build automation flows to pull input data and update financial dashboards in real timeEnsure the tool is non-subscription based, allowing our firm to fully own and operate it upon completionInclude documentation and basic training for staff handoffProject proposal after interview stage Required Skills & Qualifications: Proven experience developing advanced Excel-based financial modelsStrong expertise in Power Automate, including data flow creation, triggers, and integrationsProficiency in Excel formulas, macros, pivot tables, Power Query, and dashboardingExperience working with financial or consulting services data (e.g., margins, invoicing, labor tracking)Ability to create clean, user-friendly interfaces within ExcelExperience delivering end-to-end automated tools for internal business useExcellent documentation and communication skillsMust be able to work independently and deliver a finished product with limited oversight Preferred Qualifications: Familiarity with project-based consulting firms or staffing modelsBackground in accounting, finance, or operations analyticsExperience building tools for margin, utilization, and profitability trackingAbility to advise on additional automation opportunities within Excel or Microsoft 365 suite

Created: 2026-03-10