U.S. Citizen only - Power BI, Data Analyst, and Cost Modeling

Apex Consulting Solutions is hiring a Data Analytics, Power BI, Cost Modeling, and Power Platform Analyst to develop financial models, dashboards, and automated workflows supporting cost analysis, budgeting, and forecasting. The analyst will integrate and interpret data, communicate findings to stakeholders, and support a Federal Government agency client.

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 for team members and stakeholders
• 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

Skills
• You must be a U.S. Citizen
• Must have an Active Secret Clearance or be able to obtain a minimum secret clearance, must be a U.S. Citizen
• Bachelor's degree in Computer Science, Finance, Economics, Data Science, Accounting, or related field
• 1-3 years of experience in cost analysis, financial modeling, or data analysis roles
• 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
• 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
• Experience with SQL or other database management tools
• Familiarity with ERP systems, such as SAP, Oracle, or Microsoft Dynamics
• Background in business intelligence and data analytics

Company Overview
• Apex doesn't support federal programs from the outside. It was founded in 2022, and is headquartered in Alexandria, Virginia, US, with a workforce of 11-50 employees. Its website is https://myapexconsulting.com/.