Power BI Financial Analyst

Lynch Consultants Llc; Rockville (MD); On-site; USD 100,000 - 140,000; Full time

Benefits offered by this job

Health benefits

401(k)

Paid vacation and holidays

Job summary

Lynch Consultants, LLC is seeking a Power BI Financial Analyst to transform federal budget data into decision-ready insights in Rockville, MD. The role requires advanced Power BI development and a solid background in budgeting or financial management.

You will design dashboards, publish reports in Power BI Service, and present findings to senior leadership. Hybrid work with some onsite meetings is expected and a Public Trust clearance may be required.

Qualifications

• BA/BS required with a relevant field.
• 7+ years of Federal experience.
• Ability to obtain or maintain a Public Trust clearance.
• Knowledge of federal budget formulation and execution.
• Advanced Power BI experience: data modeling, DAX, publishing in Power BI Service.
• Ability to communicate complex financial data to senior leadership.

Responsibilities

• 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, including scheduled refresh, workspace and app distribution, and row-level security for sensitive data.
• Automate recurring monthly financial status reports and respond to short-turnaround data requests from Program Managers and leadership.
• Present dashboards and financial findings to senior leadership through briefings and presentations.

Skills

Federal budgeting

Data visualization

Dashboards

Stakeholder communication

Power BI development

Power Query / DAX

SQL queries

Education

BA/BS

Tools

Power BI

Power Query

DAX

Power BI Service

SQL

Job description

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!

Only applicants who fully meet all required qualifications will be considered for further review.

Salary:$100,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 7+ years of Federalexperience.
• MUST be able to obtain OR maintain a Public Trust clearance.
• MUST have knowledge of federal budget formulation and execution (commitments, obligations, expenditures, spend plans).
• MUST have advanced hands-on experience with Microsoft Power BI, including Power Query data modeling, DAX, publishingand managing reports in the PowerBI Service.
• MUST have demonstrated ability to communicate complex financial data to senior leadership through dashboards, briefings and presentations.

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.

Job Duties:

• Design, build, and maintain PowerBI 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-yeartables.
• 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:

• Knowledgeof 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, buildrelationshipsand 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, paidvacationand 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:Wedon’thave a cap on advancement at Lynch. Ifyou’reready 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’rehere to support you.

About Us:

Lynch Consultants, LLC is an Equal Opportunity Employer. We are a premier Federalprofessional servicesfirm 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.