IT Business Analyst - ICF

PSE&G Clean Energy Jobs Program; New Jersey; Remote; USD 73,000 - 125,000; Full time

Benefits offered by this job

Flexible work arrangements

Tuition reimbursement

401k matching

Employee Stock Purchase Plan

Volunteer opportunities

Job summary

ICF is seeking an IT Business Analyst to join the Utility Program and Services Group. The role emphasizes math/engineering background and advanced Excel expertise, supporting energy efficiency tracking, reporting, and system design throughout the software development lifecycle.

The candidate will translate complex calculations into Excel models and convert them into system requirements, train users, and collaborate with stakeholders to deliver high-quality IT solutions for energy projects.

Qualifications

• Bachelor's degree in IT, mathematics, engineering, computer science, or related field.
• 3+ years in IT project delivery or related role.
• Proficiency with Excel (pivot tables, macros, advanced data analysis).
• 2+ years creating requirements, design specs, test scripts, and system docs.

Responsibilities

• Participate in all phases of the software development lifecycle with a focus on energy efficiency tracking and reporting tools.
• Engage stakeholders to define system requirements and optimal design approaches.
• Analyze client processes for technology-driven improvements.
• Develop documentation: requirements, design docs, use cases, test plans, scripts.
• Read complex calculations, build dynamic Excel models, convert to system requirements.

Skills

Excel proficiency

IT project delivery

Documentation

Data analysis

Stakeholder collaboration

Education

Bachelor's degree in IT/Math/Engineering/CS

Tools

JIRA

SharePoint

Smartsheet

Job description

Ready to make a difference?

ICF is seeking an IT Business Analyst to join our innovative Utility Program and Services Group. This role is ideal for professionals with a strong mathematical or engineering background and advanced expertise in Excel. The IT Delivery Business Analyst will play a critical role in the software development lifecycle, system data analysis, and business intelligence for energy efficiency and utility projects.

Why you will love working here:

• Quality of life : Flexible workplace arrangements, work-life balance
• Investment of the community: Donation matching, volunteer opportunities
• Investment in you: Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan
• And many, many more

What you will be doing:

• Participate in all phases of the software development lifecycle, including requirements gathering, system design, testing, and tool delivery, with a focus on energy efficiency tracking and reporting tools.
• Engage stakeholders to define system requirements and contribute to optimal design approaches.
• Analyze client processes and identify opportunities for technology-driven improvements.
• Develop comprehensive documentation, including requirements specifications, design documents, use cases, test plans, and scripts.
• Read and interpret complex calculations, translate them into dynamic Excel models, and transfer these models into requirements for system configuration.
• Provide training and support for IT system users, troubleshoot issues, and ensure optimal system functionality.
• Collaborate effectively in team environments, contributing to client-focused solutions with high-quality deliverables.
• Present updates on tasks during status meetings and maintain clear communication with project teams.

What we need you to have (minimum qualifications):

• Bachelor’s degree in IT, Mathematics, Engineering, Computer Science, or a related field. (or applicants can substitute one year of related experience for one year of education)
• 3+ years of experience in IT project delivery or a related role.
• Proficiency in Microsoft Office, especially Excel (including pivot tables, macros, advanced data analysis functions, and building models).
• 2+ years of demonstrated experience in creating standard documentation such as requirements and design specifications, test scripts, and system documentation.
• Must be able to pass a background check, and drug screening.

What we would like you to have:

• Strong analytical skills with proven ability to read, interpret, and model complex calculations in Excel and translate them into actionable system requirements.
• Proficiency in project management and issue-tracking tools such as JIRA, SharePoint, or Smartsheet.
• Experience testing software, tracking issues, and ensuring high-quality outputs.
• Exceptional organizational skills, with the ability to manage multiple projects and meet deadlines effectively.
• Strong customer service and team collaboration skills, with an ability to communicate effectively across diverse stakeholders.
• Knowledge of SNUGGPro is a plus.

Candidate AI Usage Policy

At ICF, we are committed to ensuring a fair and equitable interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.

However, we understand that some candidates may require accommodations that involve the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at . We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.

Pay Range

There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.

The pay range for this position based on full-time employment is:

$73,403.00 - $124,784.00

Job Location

Must be based out of New Jersey - (Remote)