IT Business Analyst

Role Description

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.

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.

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.

Requirements

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

Benefits

• Flexible workplace arrangements, work-life balance.
• Donation matching, volunteer opportunities.
• Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan.
• And many, many more (Ask your recruiter for more details!).