What are the responsibilities and job description for the Budget and Finance System Support position at FEFA, LLC?
FEFA LLC is seeking a skilled Business Systems Support Specialist in budget and finance to provide comprehensive support in data modeling, reporting, and systems optimization.
Key Responsibilities
FEFA LLC is an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or on the basis of disability. We offer a competitive compensation package including a competitive salary, medical benefits, PTO, holiday pay and more.
Key Responsibilities
- Build, optimize, and maintain multiple data models in Power BI
- Implement best practices for schema design, relationships, and performance tuning
- Extract data from diverse sources (data warehouses, Excel, SharePoint, Access)
- Cleanse, transform, and integrate data into Power BI models for seamless reporting
- Develop and implement DAX-based custom measures to meet advanced reporting needs
- Empower users with tools to analyze trends, uncover insights, and make informed decisions
- Maintain and regularly update a detailed desk guide for data modeling and report creation
- Ensure team members can independently execute procedures
- Coordinate with IT teams to manage user permissions and troubleshoot Power BI issues
- Facilitate secure and compliant data access for users
- Create tailored reports and interactive dashboards using Power BI and other BI tools
- Incorporate external Excel data into Power BI models for dynamic visualizations
- Design Microsoft Forms and Power Apps to streamline data entry and enhance user experience
- Train Finance and Budget staff in Power BI desktop and service functionalities
- Deliver short training sessions during weekly staff meetings on Microsoft tools like Power BI, SharePoint, and Outlook
- Foster a data-driven culture through knowledge sharing
- Collaborate with other offices to improve data collection, reporting accuracy, and overall data integrity
- Assist in the creation and management of SharePoint sites for the Finance Division
- Develop dashboards and visualizations to effectively communicate insights and support decision-making processes
- Other duties as assigned
- High school diploma or higher
- Advanced Excel Experience is required
- Intermediate Power BI, Power Query, Power Pivot, DAX language, PowerPoint, Word, SharePoint is required
- Outlook experience is required
- Intermediate experience in data mining from large data warehouses is required
- Strong communication skills (reading, writing, and speaking) are required
- Ability to independently manage multiple tasks with shifting priorities
- Experience maintaining databases in Microsoft Access or similar platforms
- Familiarity with Teams and other collaborative tools
- Knowledge of Federal Government and budget execution principles is preferred
- U.S. citizenship with the ability to obtain and maintain a Clearance is required
FEFA LLC is an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or on the basis of disability. We offer a competitive compensation package including a competitive salary, medical benefits, PTO, holiday pay and more.
