Senior Data & BI Engineer

Calpine, a business unit of Constellation Energy Corporation (Nasdaq: CEG), is America's largest generator of electricity from natural gas and geothermal resources with operations in competitive power markets. With 79 energy facilities in operation, Calpine’s fleet has the capacity to generate approximately 27,000 MW of electricity – enough to power approximately 27 million homes. Through wholesale power operations and its retail businesses, Calpine serves customers in 22 states and Canada. 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.

*** This role is not fully remote and requires 3 days onsite in Houston, Texas.

Job Summary (includes but is not limited to the following, other duties may be assigned)

We are seeking a seasoned and results-driven Senior Data & BI Engineer to lead the development of scalable, cloud-native analytics solutions. This role requires deep technical expertise in BI Solution development in Azure, with a strong understanding of modern data architecture and enterprise reporting.

The ideal candidate will be a strategic thinker with strong hands-on experience in building robust data pipelines and delivering actionable insights to business stakeholders.

Job Responsibilities

• Engage with business users to gather requirements and translate them into comprehensive data and BI solutions.
• Design and implement scalable data pipelines using PySparkand Azure Data Factory, integrating with Azure Data Lake, Synapse Analytics, DataBricks, and Microsoft Fabric.
• Develop and optimize data models and visualizations using Power BI, ensuring performance and usability across business units.
• Lead modernization efforts by migrating legacy BI systems to cloud-based platforms.
• Collaborate with cross-functional teams to ensure alignment with architectural standards and business objectives.
• Oversee system testing, user acceptance testing (UAT), and production deployments.
• Maintain and enhance existing BI solutions, ensuring reliability and scalability.
• Document data flows, transformation logic, and architectural decisions.
• Communicate effectively with stakeholders regarding upcoming changes and coordinate change management activities.

Job Requirements

• Minimum 10 years of experience in data engineering and BI development.
• Proven expertise in PySpark for data transformation and pipeline development.
• Extensive experience with Azure Data Services, including Data Factory, Data Lake, Synapse,Microsoft Fabricand DataBricks.
• Strong proficiency in Power BI dashboard development and data modeling.
• Solid understanding of cloud architecture, data governance, and performance optimization.
• Advanced SQL skills with a focus on query performance and scalability.
• Experience with dimensional modeling (Star and Snowflake schemas).
• Excellent communication and collaboration skills in cross-functional environments.
• Ability to manage multiple priorities in a dynamic and fast-paced setting.

Preferred Qualifications

• Familiarity with SSIS, SSRS, and SSAS(tabular and multi-dimensional models).
• Experience with DAX and MDX query languages.
• Exposure to Power Apps, Data Flows
• Knowledge of machine learning (ML)and artificial intelligence (AI) concepts and their application in data analytics.
• Have worked with Azure ML Services, and understand OpenAI LLM Model.
• Experience implementing role-based and row-level security in BI platforms.

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 [email protected]. Determination on requests for reasonable accommodation are made on case-by-case basis.

Please view Equal Employment Opportunity Posters provided by OFCCP here