Power Platform Solution Architect

Hi,Please review the below JD:Role: Power Platform Solution Architect – Predictive Model ModernizationLocation: RemoteJob OverviewSophus IT Solutions is seeking an experienced Power Platform Solution Architect to lead the modernization of the Predictive Model.The current forecasting solution is a complex Excel-based financial model used for:Cash balance forecastingRevenue and expenditure projectionsBurn-rate analysisLoan amortization forecastingScenario planning and reportingThe modernization initiative will replace manual spreadsheet-driven processes with an automated, scalable, and governed Microsoft Power Platform solution.The ideal candidate will possess strong expertise in:Power BIPower AppsPower AutomateDataversePower Query/DataflowsFinancial forecasting and analytical modelingData transformation and automationKey Responsibilities:Solution ArchitectureDesign end-to-end Power Platform architecture for the PWAA Predictive Model modernizationTranslate complex Excel-based forecasting logic into scalable enterprise solutionsDefine scalable data models and semantic modelsEnsure maintainability, governance, transparency, and auditabilityData Management & AutomationAutomate ingestion of financial data from systems such as:AFRSCMSWebITreasury systemsExcel/CSV source filesBuild reusable data transformation pipelines using:Power BI DataflowsPower QueryEliminate manual spreadsheet-based ETL processesImplement automated refresh and orchestration workflows using Power AutomateForecasting & AnalyticsImplement forecasting logic currently embedded in Excel formulasDevelop and optimize:Cash flow forecastingBurn-rate calculationsLoan amortization modelsRevenue projectionsScenario analysisSupport dynamic recalculation of forecasts based on user-defined assumptionsPower Apps DevelopmentBuild Power Apps Canvas applications for:Scenario managementAssumption managementWorkflow trackingForecast adjustmentsUser interaction and approvalsIntegrate Dataverse for governed business data storageReporting & VisualizationDevelop Power BI dashboards and reports supporting:Actual vs projected analysisHistorical trendsCash balance forecastingScenario comparisonsFinancial reporting for leadership and stakeholdersCentralize reporting logic using Power BI semantic modelsRequired Qualifications7+ years of Microsoft Power Platform experienceStrong expertise in:Power BIPower QueryPower AppsPower AutomateDataverseStrong experience with:Data transformationData automationETL processesFinancial data modelingReporting and analyticsAdvanced Excel and spreadsheet modeling experienceExperience modernizing legacy/manual business processesStrong understanding of forecasting and analytical solutionsPreferred QualificationsExperience with financial forecasting or budgeting systemsExperience with loan amortization and cash flow modelsPublic sector/government project experienceExperience with:SharePointAzure SQLMicrosoft FabricEnterprise reporting platformsKnowledge of governance, security, and compliance best practicesSoft SkillsStrong analytical and problem-solving abilitiesExcellent communication and stakeholder management skillsAbility to translate business requirements into scalable technical solutionsExperience collaborating with finance, operations, and leadership teamsRegards,Mohamed Ijaz Sr. US & Canada IT Recruiter