Power BI Financial Analyst

Lynch Consultants, LLC; Rockville (MD); Híbrido; USD 90.000 - 140.000; Jornada completa

Descripción de la vacante

Lynch Consultants, LLC seeks a Power BI Financial Analyst to transform federal budget data into decision-ready insight for the NIAID OCICB Financial Management Office. The role focuses on building dashboards, data models, and automated reports using Power BI.

The ideal candidate has a BA/BS, at least 5 years of professional experience with at least 2 years in federal work, and the ability to obtain a Public Trust clearance. Hybrid work in Rockville, MD with 2 onsite days per week.

Formación

• BA/BS required.
• 5+ years of professional experience with at least 2 years federal experience.
• 2+ years of advanced hands-on experience with Power BI (Power Query, DAX, publishing and managing reports).
• Ability to communicate complex financial data to senior leadership via dashboards and presentations.
• Must be able to obtain or maintain a Public Trust clearance.

Responsabilidades

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

Conocimientos

Power BI

Communication to leadership

Public Trust eligibility

SQL

Educación

BA/BS

Herramientas

Power Query

DAX

Power BI Service

Descripción del empleo

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!

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.