Financial Systems Data Analyst (D365 & Power BI)

Ascella Technologies, Inc.•Washington, DC

1d•Remote

About The Position

Help us modernize how the federal government converts complex financial data into meaningful insights that drive informed decision-making and accountability. In this role, you will bridge the gap between technical data architecture and financial integrity, ensuring a federal agency has the transparency and reporting accuracy needed to meet internal standards. What you will achieve Deliver Data Insights: You will design and deploy sophisticated Power BI dashboards that transform raw financial data into clear, actionable intelligence for decision-makers. Ensure Financial Integrity: You will develop automated reconciliation models using Power BI and D365 data to identify and resolve discrepancies, ensuring 100% accuracy in financial reporting. Modernize Reporting Workflows: You will leverage the Power Platform—including Power Apps and Power Automate—to streamline data collection and automate manual reporting tasks. Bridge Technical & Financial Needs: You will collaborate with stakeholders to translate complex accounting requirements into intuitive Dataverse-backed solutions and visualizations. Our Culture: What Makes Ascella Employees Great At Ascella, we celebrate innovative thinkers who are empowered to share their ideas and tackle real business challenges. Your creativity will not only be welcomed but also essential in shaping our processes and solutions. We are passionate about lifelong learning, fostering a culture that prioritizes professional development and personal growth. Here, you’ll collaborate with a talented team that supports and inspires each other, ensuring that you’re continually challenged and encouraged to expand your skills. Client satisfaction is at the heart of our mission. Our employees are dedicated to providing exceptional service, proactively addressing both current and future client needs. You’ll be part of a team that values the client experience as a key component of our success. Open communication is vital to our work environment. We maintain an open door policy, encouraging questions and the sharing of ideas. We believe in aligning individual contributions with company objectives, fostering transparency, and regularly seeking feedback to enhance our processes. Lastly, we are committed to being an inclusive organization. We embrace diversity, ensuring that all employees feel valued and respected. Our varied talents and experiences drive creativity and innovation, making our workplace dynamic and successful.

Requirements

US Citizenship (no dual citizenship)
Bachelor's degree from an accredited college or university
Extensive experience building complex dashboards and performing financial data reconciliation with Power BI
Hands-on experience navigating and extracting data from Microsoft Dynamics 365 Finance environments.
Strong proficiency in leveraging Dataverse as a data source and using Power Apps/Power Automate for solution enhancement.

Nice To Haves

Experience with federal financial management standards or government accounting principles.
Microsoft Certifications (e.g., PL-300 Power BI Data Analyst or MB-300 Core Financials).
Experience with SQL or DAX for advanced data modeling and transformation.

Responsibilities

Deliver Data Insights: You will design and deploy sophisticated Power BI dashboards that transform raw financial data into clear, actionable intelligence for decision-makers.
Ensure Financial Integrity: You will develop automated reconciliation models using Power BI and D365 data to identify and resolve discrepancies, ensuring 100% accuracy in financial reporting.
Modernize Reporting Workflows: You will leverage the Power Platform—including Power Apps and Power Automate—to streamline data collection and automate manual reporting tasks.
Bridge Technical & Financial Needs: You will collaborate with stakeholders to translate complex accounting requirements into intuitive Dataverse-backed solutions and visualizations.