13 Apr
SQL Developer
Michigan, Jackson , 49201 Jackson USA

Vacancy expired!

Department Summary The Technical Analyst belongs to the Wholesale Settlements group, which is part of the Transactions and Wholesale Settlements department in Energy Supply Operations. This department is responsible for validating and communicating the settlement of Consumers Energy’s Market and Transmission transactions with Midcontinent Independent System Operator, Inc. (MISO). On an annual basis the Company sells approximately 36 million MWh of electricity with a value of $1.1 billion and purchases approximately 54 million MWh of electricity with a value of $1.6 billion plus transmission serviceand other services valued at $400 million from MISO.

Key Responsibilities The Technical Analyst performs complex analytical, technical and administrative tasks. The scope of responsibility requires individual initiative to assimilate data from various sources and factor processes into decisions. The challenge of this position is to analyze and validate the Wholesale Settlements data and provide timely reporting. Analysis includes, but is not limited to MISO Settlement data, Consumers Energy’s wholesale electricity related contracts, Accounting data, PSCR, FERC, operational analysis, and software system troubleshooting. The successful candidate would need to perform (at a minimum) the following activities:• Maintain and update SQL based Monthly Invoice Control Documents to Accounting• Manage the tracking and reconciliation of MISO Peak Load Contribution (PLC) data• Develop and maintain SQL Server Reporting Services reports for Wholesale Settlements • Participate in audits by assembling and supplying the required data• Prepare data reports to be filed with various governmental agencies regarding Transactions and Wholesale Settlements department activities.• Prepare reports on request to support Energy Supply work process.In addition, this position will provide support and back-up for others within the Electric Supply organization

Required Qualifications • Bachelor’s Degree in a technical discipline (IT), business or related area. Equivalent combination of education & experience may be considered• 1+ years of related experience

Preferred Qualifications: The following skills will/may set you apart from others: • Development experience• SQL experience• Microsoft Office application experience• Billing or accounting software experience• Familiarity with database concepts• Attention to detail• Audit experience• Ability to work well with various departments, as well as various levels of Company management• Strong written, verbal and interpersonal skills• Excellent analytical skills

Vacancy expired!


Report job