Finance Data Analyst: Dashboards, Forecasting & Insights

CPG; Ashburn (VA); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Hybrid work model

Office in Ashburn

Job summary

CPG is seeking a Financial Analyst II in Ashburn to bridge data management and financial reporting. You will oversee integrations between NetSuite, DataRails, HRIS, and ERP systems, mapping data and creating dashboards to support timely decision-making.

This role sits in Finance and reports to the Director/VP of Strategic Finance, offering a hybrid schedule with 2-4 days in the Ashburn office and opportunities to drive budgeting and forecasting processes.

Qualifications

• 4-5 years of professional work experience.
• 2-3 years of DataRails experience; 1-2 years of business analytics experience acceptable.
• Strong Excel skills.
• Excellent verbal and written communication skills.
• Bachelor's Degree.
• Knowledge of financial modeling and accounting and financial reporting is desired, but not required.

Responsibilities

• Maintain and monitor integrations between NetSuite, DataRails, HRIS, and other systems of record for data availability for financial reporting, budgeting, and forecasting.
• Manage and maintain the DataRails environment, including data mappings, datasets, calculations, templates, dashboards, and recurring reporting structures.
• Perform recurring data validation, reconciliation, and quality checks to ensure data integrity as the business evolves.
• Partner with Finance, Accounting, HR, and data administration teams to understand reporting needs and translate business questions into usable data sets.
• Design, build, and maintain dashboards, reports, and visualizations that provide actionable insights for operational and financial decision-making.
• Develop and maintain budgeting templates, forecasting models, and scenario planning tools to support financial planning processes.
• Perform financial analysis, variance analysis, sensitivity analysis, and trend analysis using Excel, DataRails, and other reporting tools.
• Create and maintain custom DataRails calculations to support reporting, forecasting, and management analysis.
• Identify opportunities to improve, streamline, or automate reporting processes, data mapping, and monthly reporting workflows.
• Document data definitions, calculation logic, mapping assumptions, and recurring reporting procedures to support consistency and continuity.
• Investigate and communicate data discrepancies, reporting issues, trends, and key findings to supervisors and stakeholders in a clear and actionable manner.
• Support ad hoc analysis and special projects related to financial reporting, business analytics, data management, and operational decision-making.

Skills

Excel

Communication

Education

Bachelor's Degree

Tools

NetSuite

DataRails

Job description

CPG is seeking a Financial Analyst II in Ashburn to bridge data management and financial reporting. You will oversee integrations between NetSuite, DataRails, HRIS, and ERP systems, mapping data and creating dashboards to support timely decision-making.

This role sits in Finance and reports to the Director/VP of Strategic Finance, offering a hybrid schedule with 2-4 days in the Ashburn office and opportunities to drive budgeting and forecasting processes.