Data Analyst - Strategic Finance and Operations -W2

Long term contract

Location: Vienna, VA 22182

Job description:

In this role within Platforms & Partnerships, Strategic Finance and Operations team, the Data Analyst will work with financial and operational data to create insightful reports and dashboards, enabling business decision-making and supporting our global strategy.
You will take ownership of projects and work with team members to deliver solutions that meet the needs of internal functions and leadership of the Firm.
The ideal candidate will have a solid data foundation and experience using Power BI in data analysis, data transformation, modeling, and visualizations with an appetite for continuous learning and development.
This role is an exciting opportunity to join an accomplished and professional organization with a sustained track record of growth, development, and innovation. Your career here is yours to own and grow alongside the Firm.

Finance, Accounting, and Reporting

Translate inputs from people roster (FTEs and ICs), vendor agreements (SOWs) and invoices into budget and forecast models
Assist with tracking P&P team spend for budget, actual and forecast at the platform level
Assist in budgeting and forecasting processes; support the preparation and presentation of materials for firm leadership.
Review and validate vendor invoices and time/expense submissions; ensure accuracy and track to estimated capitalization
Support P&P team with billing code set up, coding of invoices and tracking of spend
Review and reconcile vendor invoices with internal reports to ensure hours and billing rates are accurately captured before payment is made to vendors
Provide necessary data to finance stakeholders (strategic finance, FP&A, tax) for ISL chargeback process, forecasting and quarterly and yearly compliance purposes
Prepare, review, and distribute monthly reports including P&L for each platform, data, and financial analysis to leadership; respond to ad-hoc data/analysis requests.
Assist in preparing internal finance/accounting presentations to senior management.

Data, Analytics & Technology

Translate business requirements into clear, actionable design and implementation plans.
Develop models, specifications, workflows, and diagrams to support delivery of data analytics for proactive decision making for product managers and leadership.
Design and maintain dashboards, reports, and KPI scorecards using Power BI and other tools in alignment with business needs.
Support P&P team in calculating portfolio management metrics, including revenue and ROI, collaborating with ISL and finance stakeholders to understand data nuances and consolidating data from various data sources
Test, validate, and troubleshoot solutions to ensure data accuracy and functionality.
Manage and prioritize competing demands from internal and external stakeholders; find creative solutions to meet diverse data needs.
Evaluate and manage sensitive, confidential information and communications with sound judgment.
Collaborate with finance and technology teams to enhance revenue tracking and forecasting capabilities.

Education & Experience

Bachelor s degree required (Accounting, Finance, Business, Economics, Computer Science, Data Science, Statistics, or related fields preferred).
1 4 years of relevant experience in finance, accounting, data analysis, sales operations, or consulting.
Experience with Power BI, SQL, Excel (advanced), and financial/operational data analysis preferred.
Experience with SAP and CRM systems (e.g., ServiceNow, Radius) is a plus.

Skills & Knowledge

Proficiency in MS Word, Excel, PowerPoint, and Outlook.
Strong understanding of financial reporting, budgeting, and forecasting
Familiarity with relational and non-relational databases; experience with SQL scripting required, python preferred.
Power BI experience including data modeling, DAX, M Query, and implementing security models (e.g., row-level restrictions).

Data Analyst - Strategic Finance and Operations - W2

Key skills