Power BI Financial Analyst

About the role

Make an impact supporting the NIAD 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.

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 date 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.

Requirements

• BA/BS in Finance, Accounting, Business Administration, Information Systems, or a related field.
• 10+ years of Federal experience, including at least 7 years in financial reporting or budget analysis.
• Ability to obtain or maintain a Public Trust clearance.
• Knowledge of federal budget formulation and execution (commitments, obligations, expenditures, spend plans).
• 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.

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.

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.

Benefits

• Competitive compensation package.
• Employer‑supported 401(k).
• World‑class health benefits.
• Paid vacation and holidays.
• Programs that support well‑being.
• Performance and referral bonuses.
• Profit‑sharing bonus available to eligible associates.
• Flexible career architecture (move up, across, or stay at current level while taking on new challenges).
• Unlimited promotion opportunities.
• Career growth support (your timeline, your path, your definition of success).

Pay

$120,000 to $140,000 per year.

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.