Power BI Financial Analyst at Lynch Consultants in Rockville, MD

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.
• 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!

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

• MUST have a BA/BS in Finance, Accounting, Business Administration, Information Systems, or a related field.
• MUST have 10+ years of Federal experience, including at least 7 years in financial reporting or budget analysis.
• 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, 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.
• Knowledge of Power BI row-level security, performance tuning, and data governance practices.
• Experience writing SQL queries to extract and prepare data for reporting.
• 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

Required

• Microsoft Power BI
• Power Query data modeling
• DAX
• Federal budget formulation and execution

Preferred

• SQL query writing

Benefits

• 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.
• 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.
• Salary: $120,000 to $140,000/yr. Commensurate with experience.