Job DescriptionAs 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- Engagewith business users to gather requirements and translate them intocomprehensive data and BI solutions.
- Designand implement scalable data pipelines using PySparkand AzureData Factory, integrating with Azure Data Lake, SynapseAnalytics, DataBricks, and Microsoft Fabric.
- Developand optimize data models and visualizations using Power BI,ensuring performance and usability across business units.
- Leadmodernization efforts by migrating legacy BI systems to cloud-basedplatforms.
- Collaboratewith cross-functional teams to ensure alignment with architecturalstandards and business objectives.
- Overseesystem testing, user acceptance testing (UAT), and production deployments.
- Maintainand enhance existing BI solutions, ensuring reliability and scalability.
- Documentdata flows, transformation logic, and architectural decisions.
- Communicateeffectively with stakeholders regarding upcoming changes and coordinatechange management activities.
RequirementsJob Requirements- Minimum 8-10years of experience in data engineering and BI development.
- Provenexpertise in PySpark for data transformation and pipelinedevelopment.
- Extensiveexperience with Azure Data Services, including DataFactory, Data Lake, Synapse,MicrosoftFabricand DataBricks.
- Strongproficiency in Power BI dashboard development and datamodeling.
- Solidunderstanding of cloud architecture, data governance, and performanceoptimization.
- AdvancedSQL skills with a focus on query performance and scalability.
- Experiencewith dimensional modeling (Star and Snowflake schemas).
- Excellentcommunication and collaboration skills in cross-functional environments.
- Abilityto manage multiple priorities in a dynamic and fast-paced setting.
- Familiaritywith SSIS, SSRS, and SSAS(tabular andmulti-dimensional models).
- Experiencewith DAX and MDX query languages.
- Exposureto Power Apps, Data Flows
- Knowledgeof machine learning (ML)and artificial intelligence(AI) concepts and their application in data analytics.
- Have workedwith Azure ML Services, and understand OpenAI LLM Model.
- Experienceimplementing role-based and row-level security in BI platforms.
BenefitsBenefits 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
