IT Business Analyst

ICF Olson; New Jersey; Hybrid; USD 74,000 - 125,000; Full time

Benefits offered by this job

Flexible work arrangements

Volunteer opportunities

Tuition reimbursement

Professional development resources

401k matching

Employee Stock Purchase Plan

Job summary

ICF is seeking a Quantitative IT Business Analyst to join our Utility Program and Services Group. Based out of New Jersey with remote options, you will contribute to the software development lifecycle, data analysis, and business intelligence for energy efficiency and utility projects.

You will translate complex calculations into dynamic Excel models, document requirements, and collaborate with stakeholders to deliver high-quality, scalable solutions.

Qualifications

• Bachelor’s degree in IT, Math, Engineering, CS, or related field.
• 3+ years of IT project delivery experience.
• Advanced Excel skills including pivot tables, macros, and modeling.
• 2+ years creating requirements, design specs, test scripts, and system docs.
• Ability to pass background and drug screening.

Responsibilities

• Participate in all phases of the software development lifecycle with focus on energy efficiency tracking.
• Engage stakeholders to define system requirements and design approaches.
• Analyze client processes for technology-driven improvements.
• Develop documentation: requirements, design documents, use cases, test plans.
• Translate complex calculations into dynamic Excel models and translate to system requirements.
• Provide training and support for IT system users.
• Collaborate in team environments and present updates in status meetings.

Skills

Excel modeling

Analytical skills

Project delivery

Documentation

Communication

Education

Bachelor's degree in IT, Mathematics, Engineering, or Computer Science

Tools

JIRA

SharePoint

Smartsheet

Job description

IT Business Analyst Location: Must be based out of New Jersey - (Remote)

Ready to make a difference? ICF is seeking a Quantitative 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. Familiarity with statewide Technical Resource Manuals is a plus.

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 (Ask your recruiter for more details!)

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.

Applicants needing an accommodation for disability or religious purposes in connection with the application process should contact [e-mail] for assistance.

Working at ICF ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive.

We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read ourEEO policy. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please [e-mail] we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more aboutworkplacediscriminationrights or our benefit offerings which are included in theTransparency in (Benefits) Coverage Act.

Candidate AI Usage Policy At ICF, we are committed to ensuring a fair 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 accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance [e-mail]. 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,770.00 - $125,408.00 New Jersey Remote Office (NJ99)

About ICF ICF is a global consulting and technology services company with approximately 9,000 employees, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future. Learn more at icf.com.