Power BI & Data Integration Developer

Calpine Corporation; San Diego, Northern (CA, KY); Hybrid; USD 84,000 - 124,000; Full time

Job summary

Calpine Corporation is seeking a skilled Power BI Data Engineer to design, develop, and optimize data reports and dashboards, enabling informed business decisions across its Community Energy initiatives. You will build scalable data models, implement ETL pipelines, and integrate diverse data sources, including APIs and databases.

The role emphasizes collaboration with analysts and stakeholders to translate requirements into technical solutions, maintain documentation, and contribute to DevOps

Qualifications

• 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.
• Minimum 3 years of hands-on experience developing and maintaining Power BI solutions, including dashboards, reports, and semantic data models.
• Minimum 3 years of experience with DAX, Power Query, Data Flows, T-SQL, and SSIS.
• Minimum 3 years of experience in API development and integration.
• Minimum 3 years of experience writing, optimizing, and troubleshooting complex SQL queries.

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.

Skills

API Development & Integration

Data Modeling & DB Design

Query Optimization

Power BI

DAX

Education

Bachelor's degree in information systems/CS/data analytics

Tools

Power BI

SQL Server

SSIS

Job description

Calpine Corporation is seeking a skilled Power BI Data Engineer to design, develop, and optimize data reports and dashboards, enabling informed business decisions across its Community Energy initiatives. You will build scalable data models, implement ETL pipelines, and integrate diverse data sources, including APIs and databases.

The role emphasizes collaboration with analysts and stakeholders to translate requirements into technical solutions, maintain documentation, and contribute to DevOps