Integrator/ Developer II

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

Please view Equal Employment Opportunity Posters provided by OFCCP here

Originally posted on Himalayas