Data Analyst - Scope Manager

K&A Engineering Consulting

$85K — $100K *
Real Estate & Construction
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's Degree in Business, Engineering, Construction Management, Data Analytics, or related field.
  • 10+ years of experience in construction, utility operations, or project management.
  • Advanced proficiency in Microsoft Excel, including pivot tables and complex formulas.
  • Strong skills in Microsoft PowerPoint and Word for reporting.
  • Experience with utility systems such as SAP, Primavera P6, or GIS platforms.
  • Required utility background and ability to analyze large datasets.

Responsibilities

  • Analyze project data to identify trends, risks, and opportunities for efficiency.
  • Develop scenario models for executive decision-making and portfolio optimization.
  • Create dashboards and automated reports to track project performance.
  • Validate data accuracy across multiple systems and reconcile discrepancies.
  • Monitor scope creep and alert project teams of potential issues.
  • Evaluate project scopes for strategic alignment and reliability needs.
  • Facilitate scope review meetings with engineering and planning teams.

Benefits

  • Medical, Dental, and Vision Insurance
  • 401K with Company Match
  • Paid Parental Leave
  • Flexible PTO and Paid Holidays
  • Tuition Reimbursement and Parking Reimbursement
Full Job Description
We are seeking a highly motivated and skilled Data Analyst-Scope Manager to join our team at K&A Engineering in Binghamton, New York. In this role, you will have the opportunity to work on exciting and challenging projects that make a real impact in the energy and utility sectors. You'll be part of a dynamic, people-focused team where your expertise, ideas, and contributions will be valued and celebrated.

Role Expectations:
  • Analyze project data related to location, scope, cost, and schedule to identify trends, dependencies, risks, and opportunities for efficiencies.
  • Develop scenario models under the guidance of the PMO to support executive decision-making and portfolio optimization.
  • Create dashboards, pivot tables, and automated reports to track project performance, scope changes, and resource utilization.
  • Validate data accuracy across multiple systems (GIS, SAP, Primavera, internal databases) and reconcile discrepancies.
  • Monitor scope creep and provide early warnings to project teams.
  • Evaluate project scopes to ensure alignment with strategic priorities, regulatory requirements, and system reliability needs.
  • Support the development of prioritization frameworks for capital and maintenance work.
  • Facilitate scope review meetings with engineering, construction, and planning teams.
  • Identify opportunities for bundling work to reduce outages, mobilization costs, and overall project duration.
  • Maintain a centralized scope repository and ensure consistent documentation standards.
  • Assist project managers in developing work plans, cost estimates, and schedules based on validated scope data.
  • Provide analytical support for annual budgeting, long-term planning, and resource forecasting.
  • Track project progress and provide variance analysis for cost, schedule, and scope.
  • Support regulatory filings and audit requests by preparing accurate, defensible data sets

What we're looking for:
  • Bachelor's Degree in Business, Engineering, Construction Management, Data Analytics, or a related field.
  • Minimum of 10 years of experience in construction, utility operations, or project management.
  • Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, algorithms, macros, complex formulas).
  • Strong skills in Microsoft PowerPoint and Word for reporting and presentations.
  • Experience with project management and utility systems such as SAP, Primavera P6, GIS platforms, or similar tools.
  • Utility background/experience is required
  • Ability to analyze large datasets and translate them into actionable insights.
  • Strong analytical and critical-thinking abilities.
  • Excellent communication and presentation skills.
  • Ability to work independently and collaboratively across multiple teams.
  • High attention to detail and strong organizational skills.
  • Comfortable working in a fast-paced, deadline-driven environment.
  • Onsite Position

Pay Range: $85,000-$100,000/year

  • Medical, Dental, and Vision Insurance
  • FSA, HSA, and Dependent Care Spending Account
  • 401K (Traditional and Roth with Company Match)
  • Lifestyle Spending Account (LSA)
  • Paid Parental Leave
  • Paid Holidays and Flexible PTO
  • Tuition Reimbursement, Parking and Transit Reimbursement, and Pet Insurance
  • Long-Term Disability, Short-Term Disability, and Life Insurance
  • EAP (Employee Assistance Program)


The salary range for this role considers a wide range of factors that are considered in making compensation decisions, including but not limited to technical ability, experience and training, licenses and certifications, and other related skillsets. The disclosed range is an estimate and has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled.

Similar Jobs

More Jobs at K&A Engineering Consulting

More Real Estate & Construction Jobs

Find similar Data Analyst - Scope Manager jobs: