SQL Developer

SUMMARY:

We are seeking a SQL Developer with 4–6 years of professional experience who is interested in developing expertise in settlement calculations within North American energy markets. In this role, you will work closely with Senior Developers and Settlement SMEs to translate business rules into SQL-based logic that supports financial settlement processing, reporting, and audit workflows. This position is ideal for a developer with strong SQL fundamentals who wants to grow into a specialized and high-impact domain.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Develop, maintain, and troubleshoot T-SQL stored procedures, queries, and supporting database objects used in settlement processing.
• Translate business and settlement rules into accurate and maintainable SQL logic.
• Work with SMEs and the Lead Settlements Developer to understand charge codes, effective dating rules, and settlement requirements.
• Support processing of interval-based time-series data and transactional datasets.
• Verify calculation outputs and assist in data validation and discrepancy resolution.
• Participate in code reviews and follow established SQL coding standards.
• Assist in diagnosing and resolving production issues related to settlement logic or data quality.
• Contribute to documentation supporting auditability, operational workflows, and maintainability.

REQUIRED QUALIFICATIONS:

Technical Skills:

• Strong T-SQL development skills (stored procedures, set-based operations, joins, aggregations).
• Solid understanding of relational database design and data modeling concepts.
• Ability to interpret and reason about complex data relationships across multiple tables and systems.
• Ability to analyze and work within existing SQL logic to troubleshoot and enhance functionality.

Soft Skills:

• Strong analytical thinking and attention to detail.
• Ability to break larger requirements into incremental technical tasks.
• Clear communicator, able to explain logic and outcomes to technical and non-technical stakeholders.
• Self-driven learner who can work independently and collaborate effectively.

OTHER DESIRABLE SKILLS:

• Experience working with financial, operational, or time-series datasets.
• Experience supporting financial calculations, billing operations, or reconciliation workflows.
• Exposure to ISO/RTO energy market settlements (CAISO, PJM, MISO, ERCOT, etc.).
• Familiarity with XML-based data processing.
• Understanding of C#/.NET for tooling or reporting integration.

EXPERIENCE:

• Minimum 4 years of professional SQL development experience supporting business logic, data processing, or reporting workflows.
• Bachelor’s degree in Computer Science, MIS, Engineering, Math, Finance, or related field preferred, not required.

SUPERVISORY RESPONSIBILITIES:

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