Data Engineer

Job Description A fortune 500 leading integrated power company in the US is looking to expand it Enterprise Analytics data team in hiring a Data Engineer. They work with electricity customers large and small to implement sustainable solutions for producing and managing energy, developing smarter energy choices while servicing almost 3 million residential and commercial customers nation-wide. As the Data Engineer you will be involved in providing technical expertise while defining requirements, solution designing, and process automation for team projects, advance the creation of a centralized data lake that integrates systems. contribute to the creation of a customer-centric business via the development, documentation, and deployment of a core model in the data lake and recommend solutions and the use of industry standards when appropriate. The ideal candidate should have experience in scripting tools for automation, data warehouse design, and cloud computing, including the associated solution design, planning, maintenance, and support. Offices in Houston, TX, Philadelphia, PA, and Princeton, NJ but you can work 100% remote. This team thrives on collaboration, effective communication, and work life balance. Contract Duration: 1 year. Most likely to be extended past that point and/or flipped full time after 6 months. Required Skills & Experience

• Python
• PySpark
• ETL
• SQL Server
• SSIS packages
• Data Lakes
• Data Warehouses
• Databricks (Delta Lake)
• SQL/Oracle
• AWS

• Stored procedures
• SQL Queries
• QA/UAT (user acceptance testing)
• Airflow
• MDM (master data management)
• Stakeholder interaction
• Good communication

• 100% Data Engineering

• 100% Hands On