Data / Cost Modeling Analyst

Apex Consulting Solutions, LLC.

Washington (District of Columbia)

On-site

USD 70,000 - 105,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Apex Consulting Solutions, LLC. is seeking a Data Analytics, Power BI, Cost Modeling, and Power Platform Analyst in Washington, D.C. to develop data-driven financial models, visualizations, and automated workflows that optimize budgeting and forecasting.

You'll collaborate with finance, operations, and senior leaders to deliver cost insights and strategic planning support. The role blends technical Power BI skills with financial acumen, requiring a proactive approach to data integration,

Qualifications

  • Active Secret Clearance or ability to obtain; must be a U.S. Citizen.
  • Bachelor's degree in Finance/Economics/Statistics/Accounting; CFA/CPA a plus.
  • 0–3 years in cost analysis, financial modeling, or data analysis.
  • Proficiency in Power BI with DAX and Power Query; strong Excel skills.
  • Analytical mindset with ability to communicate financial insights clearly.
  • Ability to collaborate with cross‑functional teams.

Responsibilities

  • Design and build interactive dashboards and reports in Power BI for cost performance and budgeting.
  • Develop, maintain, and improve cost models to forecast expenses and identify savings.
  • Create financial reports detailing cost behaviors, variance analysis, and structures.
  • Integrate data from ERP systems and financial databases for analytics.
  • Support forecasting by analyzing trends and scenarios.
  • Use Power Automate to automate workflows and Power Apps for data entry and budgeting processes.
  • Present findings to senior management in clear, actionable terms.
  • Identify opportunities to improve data collection, reporting, and modeling.

Skills

Data analysis
Financial modeling
Data visualization
Communication
Cost optimization

Education

Bachelor's degree in Finance/Economics/Statistics/Accounting
Master's degree or CFA/CPA is a plus

Tools

Power BI
DAX
Power Query
Excel VBA
SQL

Job description

Washington, D.C. (Onsite) · Full-time Position

Apex Consulting Solutions is in search of a Data Analytics, Power BI, Cost Modeling, and Power Platform Analyst who will be responsible for developing data-driven financial models and providing insights into cost structures, budgeting, and forecasting. This role involves leveraging Power BI to visualize and interpret data to support decision-making processes and optimize financial performance.

The analyst will work closely with cross-functional teams, including finance, operations, and senior management, to present cost analysis and projections that align with business goals. The analyst will leverage Power BI, Power Apps, and Power Automate to develop and maintain financial models, interactive dashboards, and automated workflows. This role blends technical skills in Power BI with financial expertise in cost modeling, making it ideal for candidates skilled in data visualization, financial analysis, and strategic budgeting.

Key Responsibilities:
  • Data Analysis & Visualization: Design and build interactive dashboards and reports in Power BI to provide clear visibility into cost performance, budget trends, and financial metrics.
  • Cost Modeling: Develop, maintain, and improve cost models to predict expenses, forecast budgets, and identify cost-saving opportunities.
  • Financial Reporting: Create financial reports and analyses for management, detailing cost behaviors, variance analysis, and cost structures.
  • Data Integration: Gather, cleanse, and integrate data from multiple sources, including ERP systems, financial databases, and other relevant systems.
  • Performance Forecasting: Support financial forecasting by analyzing historical trends, current performance data, and potential future scenarios.
  • Automation & App Development: Use Power Automate to design and implement automated workflows, ensuring streamlined data integration, data validation, and notification systems for cost tracking and reporting. Develop custom applications in Power Apps to simplify data entry, cost tracking, and budgeting processes.
  • Stakeholder Communication: Present cost analysis, forecasts, and findings to senior management and other stakeholders, translating complex data into actionable insights.
  • Continuous Improvement: Identify opportunities to enhance data collection processes, reporting, and financial modeling capabilities.
Requirements:
  • Clearance Requirement: Must have an Active Secret Clearance or be able to obtain a minimum secret clearance; must be a U.S. Citizen.
  • Education: Bachelor's degree in Finance, Economics, Statistics, Accounting, or related field. Master's degree or professional certification (e.g., CFA, CPA) is a plus.
  • Experience: 0-3 years of experience in cost analysis, financial modeling, or data analysis roles. Recent graduates welcome to apply.
  • Technical Skills: Proficiency in Power BI, including DAX and Power Query for data transformation. Strong knowledge of financial modeling and cost management principles. Advanced Excel skills, particularly in complex financial formulas, pivot tables, and VBA.
  • Analytical Skills: Ability to analyze large datasets, identify patterns, and deliver insights with a focus on cost optimization.
  • Strong communication skills to present financial information clearly to non-financial audiences. Ability to collaborate with cross-functional teams.

Candidates MUST be available to work onsite in Washington, D.C. supporting a Federal Government agency client.

Preferred Qualifications:
  • Experience with SQL or other database management tools.
  • Familiarity with ERP systems, such as SAP, Oracle, or Microsoft Dynamics.
  • Previous programming experience is a plus.
  • Background in business intelligence and data analytics.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analytics, Power BI, Cost Modeling, and Power Platform Analyst
Data Analytics, Power BI, Cost Modeling, and Power Platform Analyst

Monmouth University • Washington

On-site
USD 70,000 - 100,000
Federal Cost Modeling & Power BI Analyst (Onsite DC, Secret)
Federal Cost Modeling & Power BI Analyst (Onsite DC, Secret)

Monmouth University • Washington

On-site
USD 70,000 - 100,000
Cost Modeling & Data Insights Analyst - Power BI, Onsite DC
Cost Modeling & Data Insights Analyst - Power BI, Onsite DC

Apex Consulting Solutions, LLC. • Washington

On-site
USD 70,000 - 105,000
Data Analyst (Part Time)
Data Analyst (Part Time)

Apex Consulting Solutions, LLC. • Washington

On-site
USD 65,000 - 85,000
Financial Data Analyst
Financial Data Analyst

Insight Global (United States) • Washington

On-site
USD 135,000 - 150,000
Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

Jobgether • United States

Remote
USD 85,000 - 120,000
Sr. Financial Data Analyst/Developer
Sr. Financial Data Analyst/Developer

Aegis Corps, Inc. • Herndon (VA)

Hybrid
USD 90,000 - 130,000
Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

Job Envoy • United States

Remote
USD 70,000 - 120,000
Federal Financial Reporting Analyst - Washington, Dc - Onsite
Federal Financial Reporting Analyst - Washington, Dc - Onsite

Arthur Grand Technologies Inc • Washington

On-site
USD 90,000 - 130,000
Federal Financial Reporting Analyst - Washington, Dc - Onsite
Federal Financial Reporting Analyst - Washington, Dc - Onsite

Arthur Grand • Washington

On-site
USD 100,000 - 140,000