The Role
Develops and maintains Power BI dashboards, semantic models, ETL processes, APIs, and SQL Server data solutions. Integrates data from databases, files, APIs, and enterprise systems; performs data transformation, validation, optimization, troubleshooting, and production support. Participates in DevOps, CI/CD, testing, documentation, and release management while translating stakeholder needs into scalable technical solutions.
Summary Generated by Built In
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.
Job Summary (includes but is not limited to the following, other duties may be assigned)
Calpine Community Energy has partnered with Community Choice Aggregators (CCA) in California to provide communities with a choice to purchase cleaner energy at competitive rates. CCAs procure renewable sources of electricity for their customers and utilize the power lines, owned by the local utility, to distribute this renewable energy. Calpine Community Energy provides CCAs with data management, billing, account, rate implementation, and contact center services, which are operationally critical to their success.
Job Responsibilities
• Design, develop, maintain, and enhance Power BI reports, dashboards, and visualizations that support business decision-making.
• Develop complex data models and perform advanced data transformation, manipulation, and analysis using Power BI tools such as DAX, Power Query, SQL, and related technologies.
• Consolidate, integrate, and transform data from diverse sources, including databases, Excel files, text files, web APIs, and other enterprise systems.
• Design and maintain relational and dimensional database models to support reporting and analytics requirements.
• Build, maintain, and optimize ETL processes using SQL Server Integration Services (SSIS) and other data integration tools.
• Develop scalable data solutions and data delivery mechanisms utilizing APIs and modern integration technologies.
• Perform data validation, quality assurance, troubleshooting, and root cause analysis to ensure data accuracy and reliability.
• Optimize queries, reports, and data processing workflows to improve system performance, scalability, and efficiency.
• Participate in DevOps and CI/CD processes, including deployment automation, version control, testing, and release management activities.
• Create and maintain technical documentation, including data models, process workflows, test plans, test cases, use cases, system configurations, and support procedures.
• Provide production support, troubleshoot application issues, and respond to user questions following implementation.
• Collaborate with business stakeholders, analysts, and technical teams to gather requirements and translate business needs into technical solutions.
• Maintain effective communication with management, project teams, and end users throughout the development, testing, deployment, and maintenance lifecycle.
• Support continuous improvement initiatives by identifying opportunities to enhance reporting capabilities, data processes, and application performance.
Job Requirements
Education
• Bachelor’s degree in information systems, Computer Science, Data Analytics, Engineering, or another technical/science-related discipline required, or an equivalent combination of education, technical training, and relevant work experience.
Experience
• Minimum of 3 years of hands-on experience developing and maintaining Power BI solutions, including dashboards, reports, and semantic data models.
• Minimum of 3 years of experience with DAX, Power Query, Data Flows, T-SQL, and SSIS.
• Minimum of 3 years of experience in API development and integration.
• Minimum of 3 years of experience writing, optimizing, and troubleshooting complex SQL queries.
• Experience with database design, data modeling, and data warehouse concepts.
• Proven experience designing, maintaining, and optimizing SQL Server environments supporting large data volumes and/or enterprise data warehouses.
• Experience integrating and transforming data from multiple data sources, including databases, APIs, spreadsheets, and flat files.
Technical Skills
Required
• Power BI
• DAX
• Power Query
• Data Flows
• T-SQL
• SSIS
• SQL Server
• C#
• API Development and Integration
• Data Modeling and Database Design
• Query Optimization and Performance Tuning
Preferred / Nice to Have
• Microsoft Azure, including:
• Azure SQL
• Azure Functions
• Azure API Management
• Azure Synapse Analytics
• DevOps and CI/CD practices
• .NET Framework/.NET Core
• TypeScript
• AngularJS
• Python
• R
• Experience with other major cloud platforms may be considered in lieu of Azure experience.
Skills, Knowledge & Abilities
• Strong analytical and problem-solving skills with the ability to propose and implement effective technical solutions.
• Demonstrated ability to rapidly learn new technologies, tools, programming languages, and business processes.
• Excellent verbal and written communication skills, with the ability to effectively communicate technical concepts to both technical and non-technical audiences.
• Ability to manage multiple projects and competing priorities in a fast-paced environment.
• Ability to work independently with minimal supervision while also collaborating effectively within cross-functional teams.
• Strong organizational skills and attention to detail.
• Demonstrated flexibility and adaptability to changing business needs and priorities.
• Commitment to delivering high-quality, scalable, and maintainable solutions.
• Experience supporting production applications and troubleshooting complex technical issues.
Salary Range
$84,246.70 to $124,263.82
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
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Skills Required
- Bachelor's degree in information systems, computer science, data analytics, engineering, or another technical or science-related discipline, or equivalent education, training, and relevant experience
- At least 3 years of hands-on experience developing and maintaining Power BI dashboards, reports, and semantic data models
- At least 3 years of experience with DAX, Power Query, Data Flows, T-SQL, and SSIS
- At least 3 years of experience in API development and integration
- At least 3 years of experience writing, optimizing, and troubleshooting complex SQL queries
- Experience with database design, data modeling, and data warehouse concepts
- Experience designing, maintaining, and optimizing SQL Server environments supporting large data volumes or enterprise data warehouses
- Experience integrating and transforming data from databases, APIs, spreadsheets, and flat files
- Power BI, DAX, Power Query, Data Flows, T-SQL, SSIS, SQL Server, C#, API development and integration, data modeling, database design, and performance tuning
- Microsoft Azure, including Azure SQL, Azure Functions, Azure API Management, and Azure Synapse Analytics
- DevOps and CI/CD practices
- .NET Framework or .NET Core
- TypeScript, AngularJS, Python, or R
- Experience with other major cloud platforms in lieu of Azure experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Calpine Corporation is America’s largest generator of electricity from natural gas and geothermal resources with operations in competitive power markets. Our fleet of 76 power plants in operation or under construction represents more than 26,000 megawatts of generation capacity -- enough to power approximately 20 million homes. Through wholesale power operations and our retail businesses Calpine Energy Solutions and Champion Energy, we serve customers in 22 states, Canada and Mexico. Our clean, efficient, modern and flexible fleet uses advanced technologies to generate power in a low-carbon and environmentally responsible manner. We are uniquely positioned to benefit from the secular trends affecting our industry, including the abundant and affordable supply of clean natural gas, environmental regulation, aging power generation infrastructure and the increasing need for dispatchable power plants to successfully integrate intermittent renewables into the grid. Please visit www.calpine.com to learn more about how Calpine is creating power for a sustainable future
