Quantitative IT Business Analyst — Remote, Excel Expert

ICF; Newark (NJ); Remote; USD 73,770 - 125,408; Full time

Benefits offered by this job

Flexible workplace arrangements

Donation matching

Tuition reimbursement

401k matching

Employee Stock Purchase Plan

Job summary

ICF is seeking a Quantitative IT Business Analyst to join our Utility Program and Services Group in New Jersey. The role emphasizes software development lifecycle, data analysis, and business intelligence for energy efficiency projects.

A strong mathematical or engineering background and advanced Excel skills are highly valued. You will work with stakeholders to define requirements, translate complex calculations into Excel models, and produce comprehensive documentation and training.

Qualifications

• 3+ years of IT project delivery experience.
• Proficiency in Microsoft Excel and advanced data analysis.
• 2+ years creating requirements, design specs, and test scripts.

Responsibilities

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

Skills

Excel proficiency

Microsoft Office

Requirements gathering

Education

Bachelor’s degree in IT, Mathematics, Engineering, Computer Science, or related field

Tools

JIRA

SharePoint

Smartsheet

Job description

ICF is seeking a Quantitative IT Business Analyst to join our Utility Program and Services Group in New Jersey. The role emphasizes software development lifecycle, data analysis, and business intelligence for energy efficiency projects.

A strong mathematical or engineering background and advanced Excel skills are highly valued. You will work with stakeholders to define requirements, translate complex calculations into Excel models, and produce comprehensive documentation and training.