Data Analyst - Scope Manager

K&A Engineering Consulting – is a privately held company, providing comprehensive consulting, engineering and design, program/project management, construction management, and support services to power utility and industrial clients. Specializing in substation, transmission, distribution, distributed energy resources, and EPC services, we excel in solving complex challenges with precision-driven solutions. We pride ourselves on employing top talent, fostering a culture of excellence, and building meaningful relationships with clients and employees.

Powered By Innovation, Passion, And Purpose.

Start Your K&A Career

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

Why Join K&A?

People-First Culture: We put our people at the center of everything we do, creating an environment where your professional and personal growth is a top priority.

Innovation & Learning: We encourage continuous learning and invest in your development through training, mentorship, and hands-on experience.

Collaborative Team Environment: We believe in the power of collaboration and working together to achieve the best outcomes for our clients and employees.

Recognition & Growth: We’ve earned our reputation through uncompromising precision and a commitment to excellence. As an agile and fast-growing company, we offer plenty of opportunities for your career advancement and growth.

Competitive Compensation & Benefits: We offer a comprehensive benefits package for eligible classified employees, including but not limited to:

• 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)

Check out our career page for more information!

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.