Developer SQL II

Calpine Corporation is America's largest generator of electricity from natural gas and geothermal resources with operations in competitive power markets. Its fleet of 76 power plants in operation and one under construction represents nearly 26,000 megawatts of generation capacity. Through wholesale power operations and its retail businesses, Calpine serves customers in 22 states, Canada and Mexico. Its clean, efficient, modern and flexible fleet uses advanced technologies to generate power in a low-carbon and environmentally responsible manner.

The company was established on the premise that a strong commitment to the environment is inextricably linked to excellence in power generation and corporate responsibility. Since its founding in 1984, Calpine has led the power industry in its unwavering commitment to environmental stewardship. In addition, its renewable geothermal plants use steam generated deep below the earth's surface to produce clean, renewable electricity.

Job Summary

This is not a fully remote position.

The SQL Developer is responsible for supporting the Retail Platform team by developing SQL solutions leveraging Microsoft technology platforms. Use of SQL Server database, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI will be required.

Job Responsibilities

1. Working with Microsoft SQL Stack e.g. SQL Server 2016 or higher, SSAS, SSIS, SSRS, MDM, Power BI.
2. Use of data model concepts, master data management, operational process, SDLC, project management, data profiling, data cleansing/de-duplication processes.
3. Create and maintain DAX and MDX queries and perform performance tuning on SSAS.
4. Implement data warehousing and associated architecture.
5. Data migration with source database to target database mapping.
6. Database design with multidimensional modeling.
7. Working directly with the business clients.
8. Extensive use of written and oral communication skills, particularly the ability to synthesize complex issues/scenarios into easy-to-understand concepts.
9. Works closely with the business team, development team, analysis team, and the users to enhance quality and product delivered.
10. Responsible for precisely communicating impact, status, priority, progress, and road blocks to management.
11. Provides guidance in terms of priority and ownership of issues and requests.

Job Requirements

1. Undergraduate degree in information systems, computer science, other technical/science degree, or equivalent work experience and technical training is required.
2. 3+ years of direct experience as a SQL Developer.
3. Experience in managing software requests, projects, and internal customers.
4. Experience with every phase of the System Development Life Cycle.
5. Experience with being the technical liaison between the business users and development.
6. Experience with Azure DevOps is desired.
7. 1 to 2 years of retail energy related experience is highly desired.
8. Strong written and verbal communication skills.
9. Strong analytical and critical thinking skills.
10. Good inter-personal skills combined with a willingness to listen.
11. Self-motivated, goal oriented, and possess the initiative to learn independently.
12. Analytical, advanced decision-making skills, and problem solving abilities.
13. Must demonstrate a positive, customer-focused attitude.
14. Must be well organized and detail oriented.
15. Ability to convey technical information in a clear and concise manner to other less technically oriented customers.
16. Ability to manage multiple duties at the same time.
17. Advanced Proficiency in the Microsoft Office suite and Office 365.
18. Demonstrated ability to work in ambiguous situations and across organizational boundaries.
19. Sitting and standing for long periods of time.

Microsoft SQL Technologies

1. Microsoft SQL Server stack (Reporting Services, Integration Services, Analysis Services and Power BI).

Relational Database Management Systems

1. Microsoft SQL Server 2016 or newer.

Salary Information

Position is eligible for annual bonus. Salary Range $77,250.10 to $113,943.15.

Additional Calpine Information

1. Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individuals with Disabilities.
2. Calpine is committed to Equal Employment Opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. If you are interested in applying for employment and need special assistance or an accommodation to use our website or to apply for a position, please send an e-mail with your request to Determination on requests for reasonable accommodation are made on a case-by-case basis.