Financial Data Analyst

Financial Data Analyst

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

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 experience with data visualization and reporting tools
• 5+ years of experience communicating with various stakeholders within the 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

$40.00-$45.00 per hour

The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.