Financial Data Analyst

Responsibilities

• Gather and analyze data from project management systems and tools to track performance against KPIs, budgets, and timelines.
• Collect, validate, and analyze schedules, budgets, risks, and resources for projects.
• Develop and distribute regular project reports, dashboards, and visualizations to communicate performance to stakeholders.
• Identify trends, patterns, and issues through data analysis and recommend corrective actions.
• Ensure the accuracy, completeness, and consistency of project data across the PMO.
• Identify opportunities to improve processes based on data analysis and best practices.
• Collaborate with project teams to improve data collection processes and reporting methods.
• Assist project managers with data-related tasks, such as creating reports, analyzing data, and troubleshooting issues.
• Support the implementation of new reports, tools, and processes.
• Assist in the development and maintenance of project documentation and data standards.
• Identify and analyze potential risks based on project data and assist in risk mitigation strategies.
• Effectively communicate data insights and recommendations to stakeholders at various levels of the organization.
• Manage budget for the scope they are accountable for and coordinate internal labor with Project Managers against the budget.
• Demonstrate a solid understanding of accounting rules for expense and capital activities.

Requirements

• Bachelor’s degree in business, Data Analytics, Information Systems, or a related field.
• 5+ years of financial management experience, including forecasting, budgeting, and month-end close activities.
• 5+ years of advanced Microsoft Excel skills, including power pivots, VLOOKUP, and nested formulas.
• 5+ years of experience in data analysis, preferably within a PMO or project environment.
• 5+ years of experience with data visualization and reporting tools.
• 5+ years of experience communicating with stakeholders across the organization.
• 3+ years of experience creating PowerPoint presentations and presenting to executive stakeholders.
• Proficiency in Microsoft Office (Word, Excel, PowerPoint).
• Experience with data analysis tools such as Excel, SQL, Tableau, or Power BI.
• Experience with project management and collaboration tools such as Jira, Microsoft Project, and Trello.

Technologies

• Microsoft Excel
• SQL
• Tableau
• Power BI
• Jira
• Microsoft Project
• Trello
• Microsoft Word
• PowerPoint

Benefits

• Medical, dental, and vision insurance
• 401k retirement account access
• Paid sick leave
• Paid time off

Physical Demands

• Ability to safely and successfully perform essential job functions consistent with the ADA and other standards
• Sedentary work involving sitting or remaining stationary most of the time with occasional movement around the office
• Ability to conduct repetitive tasks on a computer, using a mouse, keyboard, and monitor

Reasonable Accommodation

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.