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.
- Not a fully remote position - three days in the office and two days remote.
Job Summary
This is a Business Intelligence Developer position in the energy sector. The BI developer will be responsible for designing, implementing, and maintaining BI solutions. This position will focus on data mining & analysis, ad hoc reporting, database development, and data warehouse maintenance. This is a detail oriented position with a drive towards creativity and excelling in workmanship of developed product.
Job Responsibilities
- Develop and extend ETL jobs to facilitate data retrieval
- Assist DBA in design and maintenance of database servers and reports
- Participate in testing procedures involving review, analysis, witnessing, and certification of business intelligence solutions
- Reliance on instructions, pre-established guidelines and knowledge of commonly used concepts, practices and procedures within a particular field to perform the functions of the position.
- Development of data marts and cubes within an enterprise data warehouse environment
- Review and optimize database implementations (DDL and DML)
- Create SSRS reports, dashboards, and notifications
- Meet with stakeholders to elicit requirements for project requests
- Create and maintain database models
Job Requirements
- Bachelor’s Degree in Computer Science, MIS, Statistics, or related field required
- 4+ years experience MS SQL Database development
- 3 – 4 years experience SQL Server Integration Services
- 3 – 4 years experience in SQL Server Reporting Services
- 3 – 4 years experience in MS SQL Data Warehouse
- 2 – 3 years experience in SQL Server Analysis Services
- 2 – 3 years experience ETL jobs
- 1 – 2 years experience in energy sector
- 1 – 2 years experience in C# or VB
- 1+ years experience in Microsoft Visio or ERWIN
- Excellent communication abilities required
- Excellent organizational skills required
- Advanced SQL development skills required
- Experience in Microsoft Excel and Access a plus
- Knowledge in Big Data Concepts a plus
- Knowledge in Statistics a plus
- Knowledge in Configuration and support of SSRS a plus
- Knowledge in SharePoint a plus
Additional Calpine Information
- Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individuals with Disabilities.
- 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.