Remote IT Business Analyst — Excel-Driven Energy Solutions

PSE&G Clean Energy Jobs Program; New York (NY); Remote; USD 73.000 - 125.000; Vollzeit

Benefits dieser Stelle

Flexible workplace arrangements

Tuition reimbursement

401k matching

Employee Stock Purchase Plan

Donation matching

Volunteer opportunities

Work-life balance

Zusammenfassung

ICF is seeking an IT Delivery Business Analyst to join our Utility Program and Services Group. The role emphasizes energy efficiency tracking, system data analysis, and business intelligence using advanced Excel models to drive reporting and decision making.

The candidate will gather requirements, design solutions, and translate complex calculations into actionable system specs. Strong communication with stakeholders and experience in SDLC are essential.

Qualifikationen

• Bachelor’s degree in IT, Mathematics, Engineering, Computer Science, or related field; (or substitute one year of related experience per year of education).
• 3+ years of experience in IT project delivery or related role.
• Proficiency in Microsoft Office, especially Excel (pivot tables, macros, advanced data analysis, modeling).
• 2+ years of demonstrated experience in creating standard documentation (requirements/design specs, test scripts, system docs).
• Must pass background check and drug screening.

Aufgaben

• 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 contribute to design approaches.
• Analyze client processes and identify technology-driven improvement opportunities.
• Develop documentation: requirements, design docs, use cases, test plans, scripts.
• Read and interpret complex calculations, translate into dynamic Excel models, and translate to system configuration requirements.
• Provide training and support for IT system users and troubleshoot issues.
• Collaborate in teams to deliver high-quality client-focused solutions.
• Present task updates in status meetings and maintain clear communication with project teams.

Kenntnisse

Excel advanced

Requirements gathering

System design

Business intelligence

Stakeholder management

Testing

Training and support

Ausbildung

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

Tools

JIRA

SharePoint

Smartsheet

Jobbeschreibung

ICF is seeking an IT Delivery Business Analyst to join our Utility Program and Services Group. The role emphasizes energy efficiency tracking, system data analysis, and business intelligence using advanced Excel models to drive reporting and decision making.

The candidate will gather requirements, design solutions, and translate complex calculations into actionable system specs. Strong communication with stakeholders and experience in SDLC are essential.