Power BI Financial Analyst
At a glance
Mid-level FP&A role at Lynch Consultants. Rockville · full-time · $90,000–$140,000 base.
financeroles summary, based on the employer's posting.
What you'll do
- Build and maintain Power BI dashboards that turn federal budget and financial data into usable reporting
- Shape data from multiple sources in Power Query and create star-schema models with federal fiscal-year tables
- Manage Power BI Service publishing, refresh schedules, workspace distribution and access controls for sensitive data
- Automate monthly financial status reports and answer fast-turnaround requests from program managers, CORs and the CIO
- Brief senior leaders on dashboard findings and financial results
What you bring
- A bachelor’s degree and at least five years of professional experience, including two or more years in federal work
- At least two years of advanced Power BI work covering Power Query, DAX, and report publishing and management
- You can explain complex financial information to senior leaders using dashboards, briefings and presentations
- You can obtain or keep a Public Trust clearance
Who this fits
This mid-level role suits someone with federal budgeting or financial management experience who can build Power BI reporting and present findings to senior leaders. You’ll work in Rockville on a hybrid schedule, with at least two onsite days each week and additional onsite attendance possible for meetings, deliverables and leadership briefings.
From the employer
Make an impact supporting the NIAID Office of Cyber Infrastructure and Computational Biology (OCICB) Financial Management Office. Lynch Consultants is seeking a Power BI Financial Analyst who can transform federal budget data into decision-ready insight. If you have strong Power BI development skills and a background in budgeting or financial management, this position is for you!
Only applicants who fully meet all required qualifications will be considered for further review.
Salary: $90,000 to $140,000/yr. Commensurate with experience.
Work Location and Schedule:
- Rockville, MD
- Hybrid schedule: At least 2 days onsite per week.
- Additional onsite presence may be required for meetings, deliverables, and senior leadership briefings.
Required Qualifications – Must Have:
- MUST have a BA/BS.
- MUST have 5+ years of professional experience with a minimum of 2 years of Federal experience.
- MUST have 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.
- MUST have demonstrated ability to communicate complex financial data to senior leadership through dashboards, briefings and presentations.
- MUST be able to obtain OR maintain a Public Trust clearance.
Preferred Qualifications:
- Microsoft Certified: Power BI Data Analyst Associate.
- Experience using python for data cleansing, transformation, and report automation.
- Familiarity with NIH, HHS, or federal financial management systems.
- Have a BA/BS in Finance, Accounting, Business Administration, Information Systems, or a related field.
- Knowledge of federal budget formulation and execution (commitments, obligations, expenditures, spend plans).
Job Duties:
- 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:
- Knowledge of Power BI row-level security, performance tuning, and data governance practices.
- Experience writing SQL queries to extract and prepare data for reporting.
If you are a highly motivated individual with the ability to solve complex issues, take on new responsibilities, build relationships and think in unique and innovative ways, we are looking for you!
Why Join LC?
At Lynch Consultants (LC), your career growth is unlimited. We offer a competitive compensation package, employer-supported 401(k), world-class health benefits, paid vacation and holidays, plus programs that support your well-being.
You’ll gain:
Competitive total compensation: Our starting salaries are competitive, and our total compensation package goes even further. You have the chance to earn performance and referral bonuses, plus a profit-sharing bonus available to eligible associates.
Flexible career architecture: We encourage growing in your own way, whether that be moving up, moving across, or staying at your current level while taking on new challenges.
Unlimited promotion opportunities: We don’t have a cap on advancement at Lynch. If you’re ready to take on more responsibility and leadership, the opportunity is there.
Your career, your choice: Your timeline. Your path. Your definition of success. Whether you want to sprint towards partnership, explore different service lines, or master your craft at your current level, we’re here to support you.
About Us:
Lynch Consultants, LLC is an Equal Opportunity Employer. We are a premier Federal professional services firm where your work makes a real difference. We value purpose, growth, and impact, and we proudly support and encourage applications from U.S. military veterans.