Excel Data Analyst at Comtec Consultants

Title: Excel Data Analyst
Location: Hybrid (2 days/week onsite Newark, NJ)
Duration: Fulltime

Responsibilities:

• Gather the data outputs from projects and develop reports and forecast about past and future project performance, analyze/manage the data and find insights that can be used to improve projects and how they function
• Prepare data and reports for project managers, the PMO team, project stakeholders, and the C-suite, with an understanding of the different needs of each
• Work with the stakeholders to gather requirements for building Data Entry templates, Charts, and Graphs
• Develop Data Entry templates with formulas
• Analyze the data and develop charts and graphs
• Build Pivot tables
• Develop PowerPoint slides to present the charts and graphs
• Create and present summary reports in Excel

Requirements:

• Minimum 3 years of experience as a Data Analyst
• 3+ years of MS Excel, creating Data Entry templates, pivot tables, charts, and graphs
• Must have experience with advanced formulas in Excel
• Must have experience developing presentations in PowerPoint
• Experience with macros is a plus
• Knowledge of Project, Program and Portfolio Management processes and methodologies
• Must have strong customer service skills
• Must have excellent verbal and written communication skills, including presentation, facilitation, and coordination skills