Specialist, FAO
Core
Manage complex financial data ecosystems, generate high-impact MIS reports, and create client-ready dashboards for Finance & Accounting Outsourcing (FAO) operations.
Role type
Senior IC MIS Executive (FAO)
Builds
Operational and financial MIS reports, interactive BI dashboards, and executive presentations
Domain
Finance & Accounting Outsourcing (FAO)
Required skills
SQL, Power BI, Excel (macros, pivots), PowerPoint, FAO core metrics, billing reconciliations
Preferred skills
Microsoft Power BI certification, SQL Database Management certification, Advanced Data Analytics certification
Technologies
SQL, Power BI, Excel, PowerPoint
Responsibilities
Extract, clean, compile, and analyze large datasets from multiple accounting systems to generate daily, weekly, and monthly operational and financial MIS reports; Design, monitor, and update Service Level Agreement (SLA) frameworks and Key Performance Indicators (KPIs) unique to FAO lifecycles; Build, publish, and maintain interactive business intelligence dashboards using Power BI to visualize operational metrics, data trends, and productivity analysis; Write optimized SQL queries, subqueries, and joins in pulling clean datasets from structured databases, ensuring data architecture integrity; Translate complex analytical insights into structured, impactful, and client-ready PowerPoint (PPT) presentations for performance reviews and stakeholder updates; Collaborate proactively with cross-functional finance teams, operational managers, and international clients to address reporting requirements and deliver variance analysis statements.
Seniority
Mid-level, hands-on IC