Financial Data Analyst

Cai•Hollywood, FL

6d•$40 - $44•Onsite

About The Position

We are looking for a Financial Data Analyst to track, monitor, analyze, and report on the performance and status of IT Product Construction projects. The role supports portfolio management decision-making by providing insights into project financial performance, resource allocation, risk mitigation, and strategic alignment. The analyst will assist in identifying trends and areas for process improvement, while collaborating with various teams. The role involves working closely with project managers, stakeholders, and executive leadership to develop dashboards, reports, and presentations that facilitate financial transparency and project success. In essence, the Financial Data Analyst acts as a bridge between project data and decision-making, enabling the PMO to effectively manage projects, optimize performance, and achieve strategic objectives. This position will be a contract and onsite in Miramar, FL. Due to the specific legal and contractual requirements associated with this position, this role will be direct employment with CAI. This position does not offer work authorization sponsorship now or in the future.

Requirements

Bachelor's degree in business, Data Analytics, Information Systems, or related field
5+ years of financial management experience. Experience in forecasting, budgeting, and month-end close activities
5+ years of advanced knowledge/experience with MS Excel. Advanced Excel skills, including power-pivots, VLOOKUP, and nesting formulas.
5+ years of experience in data analysis, preferably within a PMO or project environment
5+ years of demonstrated experience with data visualization and reporting tools
5+ years of experience communicating with various levels within an organization
3+ years of experience creating presentations in PowerPoint and presenting to executive stakeholders
Must be proficient in Microsoft Office (MS Word, Excel, PowerPoint)
Experience in data analysis tools like Excel, SQL, Tableau, or Power BI

Nice To Haves

Proven experience implementing or improving processes using Excel/data
Strong analytical and problem-solving skills
Excellent communication and interpersonal skills
Experience with Agile, Waterfall, or hybrid project management methodologies
Familiarity with project management tools like Jira, Microsoft Project, or Trello
Financial analytical skills, including spend curves, burn-rate, and rate-volume analysis.

Responsibilities

Gather and analyze data from various project management systems and tools to track project performance against key performance indicators (KPIs), budgets, and timelines.
Collect, validate, and analyze project data related to schedules, budgets, risks, and resources
Develop and distribute regular project reports, dashboards, and other visualizations to communicate project 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 and teams 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 the development of risk mitigation strategies
Effectively communicate data insights and recommendations to stakeholders at various levels of the organization
Responsible for budget management for the scope they are accountable for.
Manage internal labor in collaboration with Project Managers against the budget.
Solid understanding of accounting rules for expense and capital activities