Financial Data Analyst

Job ID Number

R5978

Employment Type

Full time

Worksite Flexibility

Onsite

Job Summary

We are looking for a motivated Financial Data Analyst ready to take us to the next level! If you have financial management experience, strong analytical skills and advanced Excel expertise, and are looking for your next career move, apply now.

Job Description

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.

What You’ll Do

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

What You'll Need

Required :

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

Preferred :

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.

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, utilizing a mouse, keyboard, and monitor

The pay range for this position is $40.00-$46.00 per hour (USD). Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages for this role includes medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave as provided by applicable law.

LI-AL2