> Markdown version of [/jobs/ext/1233445-business-systems-analyst-power-bi-financial-reporting](https://www.wearedevelopers.com/jobs/ext/1233445-business-systems-analyst-power-bi-financial-reporting). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Systems Analyst (Power BI & Financial Reporting) - **Company:** Salmon Ltd - **Location:** Richland, WA, United States - **Experience:** Expert - **Salary:** $120,000.0 - **Contract:** Contract - **Skills:** Microsoft Access, Microsoft Word, Microsoft Excel, Data Analysis, Microsoft Outlook, Business Systems, Databases, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mining, Data Warehousing, Database Schema, Excel Formulas, Microsoft Office, Performance Tuning, Powerpivot, Microsoft PowerPoint, Power BI, Microsoft SharePoint, Data Processing, Powerquery, Data Management, Powerapps, Custom Reports - **Published:** July 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=f933cdc32be80828 ## About the Role We are seeking a skilled and detail-oriented Business Systems Analyst to provide comprehensive data and business systems support for the United States Department of Energy (DOE) at the Hanford Site. In this role, you will bridge the gap between financial data and actionable insights, split approximately 60% supporting the Budget (BUD) Division and 40% supporting the Finance (FIN) Division. The ideal candidate will possess advanced Excel skills and intermediate-to-advanced proficiency in the Microsoft Power Platform (Power BI, Power Query, Power Pivot, and DAX) to build data models, automate workflows, and generate critical federal financial reports., * Education: High School Diploma or higher. * Advanced Skill Level (36+ months experience): * Microsoft Excel (Advanced formulas, data manipulation, VLOOKUPs/Index Match, formatting). * Intermediate Skill Level (12+ months experience): * Power BI, Power Query, and Power Pivot (including extensive use of DAX). * Microsoft PowerPoint, Word, and SharePoint. * Data mining from large enterprise data warehouses. * Basic Skill Level (6+ months experience): * Microsoft Outlook. Preferred Experience * Strong independent task management, prioritization, and communication skills (written and verbal). * Experience maintaining databases in Microsoft Access or similar software. * Proficiency with Microsoft Teams. * Federal Context: Prior knowledge of Federal Government/Department of Energy (DOE) budget execution principles and financial systems. * Hanford Knowledge: Familiarity with the Hanford Site mission, activities, and strategic priorities is highly preferred., * Bachelor's (Preferred), * Department of Energy: 5 years (Required) ## Description * Data Model Development: Build, optimize, and maintain multiple data models within Power BI to serve as the foundation for executive reporting and analysis. * Data Integration: Extract, transform, and cleanse data (ETL) from diverse sources, including department data warehouses, Excel spreadsheets, SharePoint, and Access databases. * Advanced DAX Formulas: Develop custom measures using DAX (Data Analysis Expressions) to address complex, multi-angled reporting requirements. * Schema Design: Apply best practices in schema design, relationships, and performance optimization to ensure efficient system operations. Dashboards, Apps, & Reporting * Interactive Dashboards: Create and maintain customized reports, interactive dashboards, charts, and graphs using Power BI and Microsoft Excel. * Process Automation: Develop Microsoft Forms and Power Apps to simplify and streamline data entry and collection workflows. * Data Integrity: Collaborate across offices to improve data collection methods, reporting accuracy, and cross-functional knowledge sharing. Training, Documentation, & IT Collaboration * Staff Training: Train Finance and Budget division staff on Power BI Desktop, Power BI Service, and other Microsoft tools during weekly meetings to foster a data-driven culture. * Documentation: Create and maintain a comprehensive, step-by-step Desk Guide/User Manual covering data schemas, navigation, and reporting procedures to promote team self-sufficiency. * IT Coordination: Coordinate with internal and contractor IT departments to streamline user permissions, manage access controls, and resolve Power BI technical issues. Key Deliverables & Reporting Schedule The contractor will be responsible for executing the following data production schedule with high accuracy and professionalism: * Daily: Extract and upload Standard Accounting & Reporting System (STARS) data into the master data file, update Power Pivot lookup/fact tables, and ensure correct record coding. * Monthly: Populate executive tables, charts, and dashboards post-month-end closing; report obligation and cost variances to HQ (by the 10th); prepare PowerPoint and SharePoint budget presentations. * Quarterly & Annually: Validate and reconcile HQ Execution Summaries; generate the annual Budget Execution Review PowerPoint presentation for HQ DOE by October 31st. * Bi-Annually: Update and publish the user manual covering Power Pivot data schemas, Power Query, SharePoint, and Microsoft Teams best practices. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)