Project Portfolio Data Analyst

Job ID Number R5978 Employment Type Full time Worksite Flexibility Hybrid Job Summary We are looking for a motivated Project Portfolio 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 Project Portfolio 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 Project Portfolio 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 Required What You'll Need • 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. Reasonable Accommodation Statement 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 application.accommodations@cai.io or (888) 824 – 8111. Equal Employment Opportunity Policy Statement CAI is committed to equal employment opportunity. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or veteran status. All employment decisions are based on valid job requirements, including hiring, promotion, and compensation. Harassment and retaliation are prohibited.