FULL_TIME
5-10
Financial Systems Data Analyst (D365 & Power BI)
2/27/2026
The analyst will design and deploy sophisticated Power BI dashboards to convert raw financial data into actionable intelligence for decision-makers. They will also develop automated reconciliation models using Power BI and D365 data to ensure 100% accuracy in financial reporting.
Working Hours
40 hours/week
Company Size
51-200 employees
Language
English
Visa Sponsorship
No
About The Company
Who We Are
Ascella's founders are all veterans of the IT industry. Their experiences include development and execution of successful IT business strategies. With this leadership, we have assembled a high-caliber team to deliver quality service to our clients.
Ascella personnel include experts in information technology, project delivery, and business domain knowledge. Ascella teams have the management capacity, business infrastructure and professional team required to deliver for our clients from day one and to rapidly build capacity as the demand for services increases.
Our History
Ascella Technologies specializes in delivering IT services to Federal, state and local government clients. Ascella was founded in 2002 with a goal of delivering value-added technology-based solutions rather than simply filling technical services positions.
Since inception, Ascella has directly assisted numerous government agencies and has teamed with other vendors on projects that range in size from less than $1 million to over $100 million.
About the Role
<p dir="ltr">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.</p><h2>What you will achieve</h2><ul><li><strong>Deliver Data Insights: </strong>You will design and deploy sophisticated Power BI dashboards that transform raw financial data into clear, actionable intelligence for decision-makers.</li><li><strong>Ensure Financial Integrity:</strong> You will develop automated reconciliation models using Power BI and D365 data to identify and resolve discrepancies, ensuring 100% accuracy in financial reporting.</li><li><strong>Modernize Reporting Workflows:</strong> You will leverage the Power Platform—including Power Apps and Power Automate—to streamline data collection and automate manual reporting tasks.</li><li><strong>Bridge Technical & Financial Needs: </strong>You will collaborate with stakeholders to translate complex accounting requirements into intuitive Dataverse-backed solutions and visualizations.</li></ul><h2>Must-Have Skills (Required)</h2><ul><li><strong data-path-to-node="6,0,0" data-index-in-node="0">US Citizenship (no dual citizenship)</strong></li><li>Bachelor's degree from an accredited college or university</li><li>Extensive experience building complex dashboards and performing financial data reconciliation with Power BI</li><li>Hands-on experience navigating and extracting data from Microsoft Dynamics 365 Finance environments.</li><li>Strong proficiency in leveraging Dataverse as a data source and using Power Apps/Power Automate for solution enhancement.</li></ul><h2>Nice-to-Have Skills (Preferred)</h2><ul><li>Experience with federal financial management standards or government accounting principles.</li><li>Microsoft Certifications (e.g., PL-300 Power BI Data Analyst or MB-300 Core Financials).</li><li>Experience with SQL or DAX for advanced data modeling and transformation.</li></ul><p><em>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.</em></p><h2>Our Culture: What Makes Ascella Employees Great</h2><div><p data-path-to-node="10">At Ascella, we celebrate <strong data-path-to-node="10" data-index-in-node="25">innovative thinkers</strong> 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.</p><p data-path-to-node="11">We are passionate about <strong data-path-to-node="11" data-index-in-node="24">lifelong learning</strong>, 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.</p><p data-path-to-node="12"><strong data-path-to-node="12" data-index-in-node="0">Client satisfaction</strong> 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.</p><p data-path-to-node="13"><strong data-path-to-node="13" data-index-in-node="0">Open communication</strong> 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.</p><p data-path-to-node="14">Lastly, we are committed to being an <strong data-path-to-node="14" data-index-in-node="37">inclusive</strong> 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.</p></div><p>*******************************************************</p><p><strong>Position:</strong> Financial Systems Data Analyst <br><strong>Location:</strong> Washington, DC (fully remote)<br><strong>Base Compensation:</strong> We offer a competitive salary and benefits package, and we are open to discussing compensation based on your qualifications and experience<br><strong>Other Compensation: </strong>4% contribution to 401(k), performance bonus, profit-sharing<br><strong>Paid Time Off: </strong>16 days PTO/year, 11 holidays/year<br><strong>Benefits:</strong> Medical, Dental, Vision, Life, Disability, 401(k)…and more<br><em><strong>Position is open until filled, applications accepted on an ongoing basis.</strong></em></p><p>*******************************************************</p><p><strong><span style="text-decoration: underline;">Equal Employment Opportunity Statement</span></strong><br><em>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.</em></p>
Key Skills
Power BID365Data ReconciliationData ArchitectureData InsightsPower PlatformPower AppsPower AutomateDataverseFinancial IntegrityReporting WorkflowsUS CitizenshipDAX
Categories
Finance & AccountingData & AnalyticsTechnologyGovernment & Public Sector
Benefits
401kPerformance BonusProfit-SharingMedicalDentalVisionLifeDisability
Apply Now
Please let Ascella Technologies, Inc. know you found this job on InterviewPal. This helps us grow!
Prepare for Your Interview
We scan and aggregate real interview questions reported by candidates across thousands of companies. This role already has a tailored question set waiting for you.
Elevate your application
Generate a resume, cover letter, or prepare with our AI mock interviewer tailored to this job's requirements.