Business Intelligence Developer - job 1 of 2

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 (includes but is not limited to the following, other duties may be assigned)

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
• Participates in testing procedures involving review, analysis, witnessing, and certification of business intelligence solutions
• Relies 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 illicit 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 hrrecruitment@calpine.com. Determination on requests for reasonable accommodation are made on case-by-case basis.

Please view Equal Employment Opportunity Posters provided by OFCCP here

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)