Financial Systems Data Analyst (D365 & Power BI)

Location: Washington,District of Columbia,United States

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.

Must-Have Skills (Required)

• 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-Have Skills (Preferred)

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

To ensure you’ve reviewed the full technical requirements for this role, please include the word "Ascella" as the very first word in your response to the 'Why are you a good fit?' question on the application.

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.

*******************************************************

Position: Financial Systems Data Analyst Location: Washington, DC (fully remote) Base Compensation: We offer a competitive salary and benefits package, and we are open to discussing compensation based on your qualifications and experience Other Compensation: 4% contribution to 401(k), performance bonus, profit-sharing Paid Time Off: 16 days PTO/year, 11 holidays/year Benefits: Medical, Dental, Vision, Life, Disability, 401(k)…and more Position is open until filled, applications accepted on an ongoing basis.

*******************************************************

Equal Employment Opportunity Statement Ascella Technologies is an Affirmative Action/Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion or sexual orientation. We provide equal employment opportunities to all qualified candidates without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status or any other characteristic protected by law. Ascella Technologies is committed to providing veteran employment opportunities to our service men and women.