Note: The job is a remote job and is open to candidates in USA. Aegis Corps, Inc. is seeking a talented Financial Data Analyst/Developer to join their team and play a pivotal role in creating sophisticated budget management solutions. The role involves utilizing data from government financial systems to develop analytical tools and collaborating with experts to ensure alignment with project goals.
Responsibilities
- Utilize data extracted from Government financial systems to develop, design, and build financial management data analytical and forecasting tools
- Collaborate with Government subject matter experts to understand requirements and ensure the developed tools align with the desired end state
- Design and implement financial forecasting, budget tracking, and expenditure analysis functionalities
- Create automated processes for data retrieval and updates, ensuring accuracy and data integrity
- Develop interactive reports using Microsoft 365 applications, including Power Platform, Excel Pivot reports, and Power Business Intelligence (BI) Dashboard reports
- Build budget analytics tools as per project specifications
- Collaborate with team members and stakeholders to ensure timely project delivery and adherence to project management standards
- Deploy tools and reports to cloud environments as required
Skills
- Bachelor's degree in Finance, Economics, Computer Science, or a related field
- Proven experience in financial analysis, budgeting, and forecasting
- Strong proficiency in software development with a focus on customized analytical tools
- Proficiency in Microsoft 365 applications, including Power Platform, Excel, and Power BI. (7+ yrs. for Senior Consultant level, 5+ yrs. for Consultant II level, 3+ yrs. for Consultant level)
- Experience in data management, validation, and accuracy checks
- Excellent problem-solving skills and attention to detail
- Effective communication and collaboration skills
- **4-7 Years of Experience in MS Operational Automation Software Families**
- Proficiency in Microsoft OneNote for customized group and one-on-one training
- Proficiency in Power Automate for training on process automation
- Proficiency in Power Query and Power Pivots for training on data management
- Proficiency in Power BI for training on report development
- Proficiency in Power Apps for training on app development
- Knowledge of Power Platform, Kofax Power PDF Advanced, and DocuSign
- **Documentation and technical writing (e.g., SOP, User Guide, UAT results)
- **Accounting and finance background/understanding
- Familiarity with government financial systems and regulations is a plus
- Federal background and consulting experience preferred
Benefits
- This is a remote position with the option to work from office.
- Occasional on-site presence may be required for specific occasions or meetings.
Company Overview