PowerBI Developer for Financial Budget Actual

lt;span>

Purpose : < / b>To support development of Financial Budget and Actual Power BI model that meets stake holder requirements and delivers dynamic and userfriendly reporting and dashboards. The final model will replace resource intensive processes in place today and equip the team to manage the model independently to ensure design flexibility for future enhancements.

< / span>< / span>< / p>

Background and / or Current State : < / b>Standard financials are download and then further mapped and manipulated to aggregate data in a different hierarchy to present to leadership for decision making and meet financial reporting needs for the organization. The Current process is inefficient and labor intensive. To achieve the goal of dynamic reporting as well as the organization s initiative to bring data to the data hub this project was started in 2024 but has not yet been completed. Budget data from PBCS and actual data from CFS now reside in Redshift. A PBI data model has been started but requires further enhancements to allow the model to be used more broadly and accurately.< / span>
< / span>< / span>< / p>

Scope of Engagement : < / span>< / span>< / b>
< / span>< / span>< / p>

• Strong proficiency in data modeling report building and data visualization and reporting< / span>
  < / span>< / span>< / span>< / li>
• Ability to organize and structure data to be easier to work with and understand; design interactive Power BI dashboards; and ability to transform numbers and metrics into actionable insights< / span>
  < / span>< / span>< / span>< / li>
• Expertise in DAX functions including complex formulas< / span>
  < / span>< / span>< / span>< / li>
• Training and Support : Ability to guide and teach others on how to use Power BI effectively specifically on the above ensuring long term stability< / span>
  < / span>< / span>< / span>< / li>
• Working knowledge of data warehouse role around integrations with Power BI< / span>
  < / span>< / span>< / span>< / li>
• Ability to think strategically about long term sustainability for the model and reporting requirements< / span>
  < / span>< / span>< / span>< / li>
• Adhere to data compliance and governance standards< / span>
  < / span>< / span>< / span>< / li>< / ul>

  
  < / span>< / span>< / p>

  Expectations : < / span>< / span>< / b>
  < / span>< / span>< / p>

  • Eliminate the download and manipulation of data results in Excel templates and workbooks.< / span>
    < / span>< / span>< / span>< / li>
  • Enable finance to refocus resource time on more valueadd initiatives that align with strategic objectives< / span>
    < / span>< / span>< / span>< / li>
  • Increase knowledge and skill set of internal teams to support the organization with future PBi requirements including best practices around data modeling report building and data visualization to enhance skillsets.< / span>
    < / span>< / span>< / span>< / li>
  • Ensure staff have working knowledge to support the model upon completion of engagement fully.< / span>
    < / span>< / span>< / span>< / li>< / ul>

    
    < / span>< / span>< / p>

    Deliverables : < / span>< / span>< / b>
    < / span>< / span>< / p>

    • Fully automated and sustainable Power Bi solution that provides comprehensive financial reporting to the entire organization< / span>
      < / span>< / span>< / span>< / li>
    • Power Bi dashboards designed for selfservice access by finance and leadership< / span>
      < / span>< / span>< / span>< / li>
    • Standard Operating Procedures and internal expertise to continue development of staff expertise.< / span>
      < / span>< / span>< / span>< / li>
    • Training sessions and documentation for the internal team.< / span>
      < / span>< / span>< / span>< / li>
    • A seamless handover process ensuring the team is confident in managing and updating the PowerBI solution.< / span>< / span>
      < / span>< / span>< / li>< / ul>
      
      < / div>< / span>
      PowerBI

    Key Skills

    Forecasting,Microsoft Access,Microsoft Word,Military Experience,Pivot tables,Accounting,Microsoft Powerpoint,Microsoft Excel,Financial Analysis,Budgeting,DoD Experience,Financial Management

    Employment Type : Full Time

    Vacancy : 1

    About Company : No Limit Technology