Computer Specialist 23

Ariel Partners•New York, NY

About The Position

The Home Energy Assistance Program (HEAP) is a critical initiative providing financial aid to eligible low-income households in New York City for heating and cooling expenses. This program encompasses regular emergency benefits, as well as support for heating equipment repair and replacement. Regular HEAP benefits are disbursed annually, with amounts varying based on household size, income, and energy costs. Emergency HEAP benefits are available from January to March for households facing crisis situations, such as heating emergencies or utility shut-off threats, offering a one-time payment. The Heating Equipment Repair and Replacement Program (HERR) assists eligible households with necessary repairs or replacements of malfunctioning heating equipment like furnaces or boilers. The HEAP application utilizes a hybrid architecture, integrating Microsoft Azure Cloud, Power Platform, Synapse Analytics, and on-premises services to facilitate seamless data integration, advanced analytics, and a scalable infrastructure, all aimed at ensuring a safe and healthy living environment for recipients.

Requirements

A minimum of 4 years of experience with Microsoft Azure (Cloud & Hybrid Architecture) and Microsoft Power Platform (Power Apps, Power Automate)
Synapse Analytics and SQL Development (Advanced Queries, Stored Procedures, Optimization)
Data Warehousing and ETL / Data Integration
Real-time & Ad Hoc Reporting and Data Analysis & Data Validation
System Monitoring & Performance Tuning and Production Support & Troubleshooting
Security & Access Control and Financial Data Reconciliation
Payment Processing Systems (PA/NPA, HEAP365, Autoheaters, SSI)

Responsibilities

Provide Post-Go-Live System Support and Stabilization
Monitor production systems to ensure stability and optimal performance during the stabilization phase.
Identify, troubleshoot, and resolve system, data, and integration issues in a timely manner.
Perform root cause analysis and implement corrective and preventive measures.
Collaborate with technical and business teams to address production incidents and service requests.
Support performance tuning and optimization across Azure, Power Platform, Synapse Analytics, and on-premises components.
Manage Payment Processing Operations
Execute monthly payment processes, including PA/NPA and HEAP365, in accordance with business rules and timelines.
Manage and run annual autopayment processes, including Autoheaters and SSI.
Validate payment data for accuracy, completeness, and compliance prior to execution.
Troubleshoot and resolve payment processing issues and discrepancies.
Ensure timely completion of all payment cycles and coordinate with stakeholders on status and outcomes.
Develop and Deliver Reporting Solutions
Design, develop, and maintain real-time, scheduled, and ad hoc reports based on business requirements.
Provide rapid turnaround for urgent reporting requests from business stakeholders.
Ensure accuracy, consistency, and integrity of all reported data across systems.
Develop and optimize queries, dashboards, and data extracts using Synapse Analytics and related tools.
Perform data validation and reconciliation to support reporting outputs and business decisions.
Collaborate with stakeholders to gather reporting requirements and translate them into technical solutions.
Support System Enhancements and Continuous Improvement
Analyze business requirements and implement system enhancements and configuration changes.
Work with cross-functional teams to design and deploy new features and improvements.
Perform testing, validation, and deployment of system updates and fixes.
Maintain and improve data flows and integrations across systems.
Ensure adherence to system design standards, security protocols, and best practices.
Maintain System Knowledge and Documentation
Document system architecture, data flows, and operational processes.
Maintain technical and functional documentation for ongoing support and future enhancements.
Provide knowledge transfer and guidance to team members as needed.
Assist support teams in resolving complex technical issues related to the application.
Ensure documentation is kept up to date with system changes and enhancements.