Hybrid Financial Analyst – Power BI Report Writer (Dynamics 365 F&O) bei AETOS
AETOS · Chantilly, Vereinigte Staaten Von Amerika · Hybrid
- Professional
- Optionales Büro in Chantilly
AETOS LLC is a Minority Owned CVE Certified Service Disabled Veteran Owned Small Business (SDVOSB) providing information technology solutions focused on building a business that is customer-centered and performance-oriented. At Aetos, we specialize in developing IT solutions to optimize functionality and efficiencies for government and commercial clients to meet their business needs.
Job Description:We are seeking a highly skilled and analytical Financial Analyst with deep expertise in Power BI report writing, specifically leveraging data from Microsoft Dynamics 365 Finance & Operations (F&O). This role is perfect for a detail-oriented professional who thrives in a data-driven environment and enjoys transforming raw ERP data into meaningful insights that drive strategic financial decisions.
As a key member of our finance and business intelligence teams, you will be responsible for building and maintaining insightful reports, dashboards, and financial models that streamline reporting and forecasting for the organization.
Key Responsibilities
Develop, maintain, and optimize Power BI reports and dashboards based on data from Dynamics 365 F&O modules (including General Ledger, Accounts Payable/Receivable, Budgeting, Procurement, and Fixed Assets).
Collaborate with Finance, IT, and Operations teams to gather requirements and translate them into BI reporting solutions.
Perform in-depth financial analysis and modeling using ERP data and external sources.
Design robust data models and queries in Power BI for efficient and scalable reporting.
Support monthly, quarterly, and annual close processes with accurate financial reporting.
Ensure data integrity and implement quality control processes for all dashboards and financial reports.
Continuously identify opportunities to automate and optimize reporting through BI tools and ERP integration.
Provide ad hoc analysis and scenario modeling to support strategic initiatives.
Required:
Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, or a related field.
3+ years of experience in financial analysis with a strong focus on Power BI development.
Hands-on experience with Microsoft Dynamics 365 Finance & Operations (F&O) data architecture.
Strong SQL/DAX skills for query writing and data transformation.
Solid understanding of accounting principles and financial metrics.
Ability to work cross-functionally and communicate clearly with technical and non-technical stakeholders.
Preferred:
Master’s degree or relevant certifications (e.g., CPA, CFA, Power BI Data Analyst Associate).
Familiarity with Azure Data Lake, Synapse, or other cloud-based data platforms.
Experience working in mid-to-large size enterprise environments.
Knowledge of other BI or visualization tools (e.g., Solver, Tableau, Excel PivotTables) is a plus.
- Top-tier salary or rate potential commensurate with experience and skillset
- Comprehensive health, dental, and vision coverage
- 401(k) with company match
- Generous PTO and holidays
- Professional development support, including Solver certifications
- Collaborative and supportive on-site team culture
- Applicants must be authorized to work for any employer in the U.S. and reside in the U.S.