Data Analytics Analyst

 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 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. 

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, Data Science, 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. 

Soft Skills: 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. 

Background in business intelligence and data analytics.