As an Data Engineer at Calpine Inc., you will contribute to the BI development to optimize energy operations, enhance forecasting, and improve operational efficiency. This role is ideal for professionals with 10+ years of experience who are passionate comprehensive data and BI solutions development and solving real-world energy sector challenges using PySpark and Azure Data Factory.
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 PySpark and 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 8 - 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 Fabric and 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.
- 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.
-
Benefits include:
- Medical, vision and dental
- Prescription drug coverage
- Calpine’s Retirement Savings Plan (401(K)) matching
- Paid time off and paid parental leave
- Comprehensive health programs, including our Wellness Program, telemedicine, Employee Assistance Program, Health Care and Dependents Care Flexible Spending Accounts (FSAs) and more
- Life insurance
- Education reimbursement program
- Adoption assistance
- Scholarship and vocational grant programs
- Training and education opportunities
- Bonus eligible
