Power BI Financial Analyst – Federal Budget (Public Trust)

Lynch Consultants, LLC; Potomac (MD); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Profit-sharing bonus

Performance bonus

Job summary

Lynch Consultants, LLC in Rockville, MD is seeking a Power BI Financial Analyst who can transform federal budget data into decision-ready insights. You will design, build, and publish dashboards for senior leaders using Power BI Desktop and Power BI Service.

A BA/BS and 5+ years of experience, including federal work, are required. This hybrid role requires strong communication, ability to present findings, and capability to obtain or maintain a Public Trust clearance.

Qualifications

• BA/BS required.
• 5+ years of professional experience with a minimum of 2 years of Federal experience.
• 2+ years of advanced hands-on experience with Microsoft Power BI, including Power Query data modeling, DAX, publishing and managing reports in the Power BI Service.
• Demonstrated ability to communicate complex financial data to senior leadership through dashboards, briefings and presentations.
• Ability to obtain or maintain a Public Trust clearance.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports for financial/budget data.
• Connect to and transform financial data from multiple sources using Power Query, and build star-schema data models with federal fiscal-year tables.
• Publish and manage content in the Power BI Service, including scheduled refresh, workspace and app distribution, and row-level security for sensitive financial data.
• Automate recurring monthly financial status reports and respond to short-turnaround data requests from Program Managers, CORs, and the CIO.
• Present dashboards and financial findings to senior leadership through briefings and presentations.

Skills

Power BI

DAX

Power Query

SQL

Dashboard design

Data modeling

Federal experience

Communication to leadership

Education

BA/BS

Tools

Power BI Service

Power BI Desktop

Python

Job description

Lynch Consultants, LLC in Rockville, MD is seeking a Power BI Financial Analyst who can transform federal budget data into decision-ready insights. You will design, build, and publish dashboards for senior leaders using Power BI Desktop and Power BI Service.

A BA/BS and 5+ years of experience, including federal work, are required. This hybrid role requires strong communication, ability to present findings, and capability to obtain or maintain a Public Trust clearance.