Senior Application Software Developer

We are looking for a highly skilled T-SQL developer with a deep understanding of Microsoft SQL Server and a strong software engineering foundation. This position plays a critical role in the design, development, and maintenance of our settlement calculation engine and associated data. The ideal candidate will have experience working with interval-based time series data and financial logic (e.g., reconciliation, invoicing), preferably within ISO/RTO energy markets such as CAISO, MISO, PJM, NYISO, ISNE, ERCOT, etc.

• Develop and maintain complex T-SQL scripts, stored procedures, and performance-optimized queries to support settlement logic.
• Understand and implement settlement rules, charge code logic, and effective dating across various ISO markets.
• Work directly with internal settlement SMEs and the Lead Settlements Developer to translate business rules into executable logic.
• Design and support data models for high-volume transactional and interval-based datasets.
• Support resettlement processing and batch settlement routines with high accuracy.
• Contribute to internal tools that support settlement calendar generation, validation, and audit workflows.
• Collaborate with the broader software development team but focus primarily on the SQL layer.
• Provide accurate development estimates and document logic thoroughly for auditability and future enhancements.
• Participate in ongoing improvement of coding standards and best practices specific to financial settlements.

Technical

Skills:

• Expert-level T-SQL development (e.g., stored procedures, set-based operations).
• Strong understanding of interval-based time series data and financial reconciliations.
• Familiarity with effective dating, batch processing, and resettlement cycles.

• ISO/RTO energy market settlement exposure (CAISO, PJM, MISO, etc.).
• Billing/AR/AP system knowledge (e.g., charge calculations, invoice generation).
• Familiarity with settlement calendars, charge code logic, and financial audit/compliance standards.

• Strong analytical, documentation, and problem-solving skills.
• Ability to work autonomously and own entire components of the SQL-based solution.
• Effective communicator, able to interface with technical and non-technical stakeholders.

• Understanding of ISO-specific settlement rulebooks.
• Working knowledge of XML and time-series data serialization.
• Exposure to .NET/C# for internal tool integration or reporting layers (not core to the role).
• Awareness of financial audit practices related to settlements.

Minimum 7+ years of experience developing enterprise-grade SQL solutions, with at least 3 years focused on financial or energy market applications preferred.

None. May act as a mentor or technical lead on projects.