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

Monmouth University; Washington (District of Columbia); Sur place; USD 70 000 - 100 000; Plein temps

Résumé du poste

Apex Consulting Solutions is seeking a Data Analytics, Power BI, Cost Modeling, and Power Platform Analyst to develop data-driven financial models and provide insights into cost structures, budgeting, and forecasting. The role emphasizes Power BI visualization, interdepartmental collaboration, and presenting cost analyses to executives.

The ideal candidate will have Power BI proficiency (DAX and Power Query), strong Excel/VBA skills, and experience with ERP systems. The position requires U.S.

Qualifications

• Active Secret Clearance or ability to obtain at least a Secret clearance; U.S. citizen.
• Bachelor’s degree in relevant fields; Master’s/ certification a plus.
• 1–3 years in cost analysis, financial modeling, or data analysis; recent grads welcome.
• Proficiency in Power BI with DAX and Power Query; strong financial modeling skills.
• Advanced Excel with complex formulas, pivots, VBA.
• Experience with SQL or database tools and ERP familiarity.
• Strong analytical and communication skills; ability to present to non-financial audiences.
• On-site work in Washington, D.C. 2–3 days per week for a Federal Government client.

Responsabilités

• Design interactive Power BI dashboards to visualize cost performance and budgets.
• Develop, maintain and improve cost models for forecasting and cost-savings opportunities.
• Generate financial reports and variance analyses for management.
• Integrate data from ERP and financial databases; ensure data quality for reporting.
• Support forecasting through historical trends and scenario analyses.
• Create automated workflows using Power Automate; develop Power Apps for data entry and budgeting.
• Present findings to senior management and cross-functional teams.
• Identify process improvements in data collection, reporting, and modeling.

Connaissances

Power BI

DAX

Power Query

Financial modeling

Cost management

Advanced Excel

VBA

SQL

ERP familiarity

Analytical skills

Communication

Collaboration

Formation

Bachelor’s degree in Computer Science, Finance, Economics, Data Science, or Accounting

Master’s degree or professional certification (CFA, CPA) is a plus

Outils

Power BI

Power Apps

Power Automate

Excel

SQL

ERP systems

DAX

Power Query

Description du poste

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

You must be a U.S. citizen and must either:

Already have a Bachelor’s degree (B.S.), or

Be in your final semester of completing your Bachelor’s degree.

Please do not apply if you do not meet these requirements.

Data Analytics, Power BI, Cost Modeling, and Power Platform 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 Computer Science, Finance, Economics, Data Science, Accounting, or related field. Master’s degree or professional certification (e.g., CFA, CPA) is a plus.
• Experience: 1-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. 2-3 days a week supporting 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.