MCG Energy Solutions, LLC · 9 hours ago
Senior Application Software Developer
United States
Full-time
Remote
Senior Level
$110K/yr - $130K/yr
7+ years expMCG Energy Solutions, LLC is seeking a highly skilled T-SQL developer to play a critical role in the design, development, and maintenance of their settlement calculation engine. The ideal candidate will be responsible for developing and maintaining complex T-SQL scripts and collaborating with internal settlement SMEs to translate business rules into executable logic.
EnergyInformation TechnologyRisk ManagementSoftware
Hiring Manager
Terence Larson
Responsibilities
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
Assist in production issue diagnosis
Participate in ongoing improvement of coding standards and best practices specific to financial settlements
Qualification
Required
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
Minimum 7+ years of experience developing enterprise-grade SQL solutions, with at least 3 years focused on financial or energy market applications preferred
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
Preferred
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
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
Company
MCG Energy Solutions, LLC
Since 1995, MCG has provided software solutions for the everyday business needs of utilities and other entities in the wholesale energy marketplace.
51-200 employees
H1B Sponsorship
MCG Energy Solutions, LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (2)
2020 (1)
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
Peak Rock Capital
2025-04-22Debt Financing
Leadership Team
Mike Prickett
Chief Strategy Officer (CSO)
Recent News
2025-04-22
Company data provided by crunchbase