Sql Python Intern Jobs in Syosset, NY (NOW HIRING)

About the Opportunity 

Managing data is a core element of operating the world's most inspiring Virtual Power Plant (VPP). (You can't fact check vibes.) Data Engineering is the team that brings it all together. From millions of internet-connected devices that use, store, and distribute power to all the clients that use those devices to manage grid load, Data Engineering makes it possible. We love data, translation, observability, and quality. 

From schema design to data transformation, from privacy and security to compliance, Data Engineering covers a lot of range. It's a tight-knit team of engineers dedicated to excellence, quality, high-throughput communication, and deep collaboration. Client experience is at the focus of our efforts, but we also serve other internal customers with high-value data and information. 

The Role

You will integrate with the Data Engineering team, collaborating as a full-fledged member of the team, not doing some intern project on the side. You are joining us during the busiest season and will get a full glimpse of what it is like to work on a dedicated team of professionals who care about one another and are dedicated to each other's success.

• Collaborate closely across teams to help build and maintain EnergyHub's core data products
• Pair with and receive mentorship from brilliant engineers from a variety of backgrounds, gaining wisdom from their unique experiences and talents
• Deepen your knowledge of modern data engineering tools like Snowflake, dbt, Airflow, and Sigma
• Work in an agile environment, deepening your understanding of translating business and client needs into excellent products
• Contribute to mission-critical projects across the data lifecycle through
  • Feature development
  • Data platform enhancement
  • Bug fixes (identification & resolution)
  • Automations & efficiency improvements
  • Pair programming and code review (providing & receiving feedback)
  • Documentation
  • Monitoring and alerting
• Improve monitoring, troubleshooting, and resolution processes to improve our processes
• Monitor cloud costs across our toolset to maintain efficiency and justify expenses
• Build the absolutely coolest stuff of your career (so far)
• Help your hiring manager sustainably manage their usage of adjectives and adverbs
• Other duties as assigned

About you

• First and foremost, you have to sincerely love data and all the things it can enable and empower
• Current enrollment in (or immediate graduate of) an undergraduate or graduate program in or related to data engineering
• Proficiency in SQL and Python and perhaps even dbt and Sigma experience, with an awesome ability to bring sanity and clarity to syntactic complexity
  • Nice to have: Snowflake Data Warehousing Workshop (Badge 1)
  • Nice to have: dbt Fundamentals
• Some monitoring and dashboarding experience (e.g. Snowflake, Sigma, Datadog)
• A clear understanding of the difference between OLAP and OLTP RDBMS systems and when to recommend one over the other
• Knowledge of a variety of file structures such as CSV, JSON, and Parquet, and when one might be preferable over others
• Drive and dedication for quality and performance in everything you touch and thirst for learning new techniques
• Clear communication (written and verbal), capable collaboration (in-office and online), and cultivated curiosity
• Warmth and welcoming for your collaborators, colleagues, and cohort, with an urge to help them succeed and pay their generosity forward to others
• Above-average appreciation for alliteration
• Well-grounded stance on AI adoption that makes you a stronger, more capable engineer

Please note that sponsorship of new applicants for employment authorization, or any other immigration-related support, is not available for this position at this time.

Why work for EnergyHub?

• Collaborate with outstanding people: Our employees work hard, do great work, and enjoy collaborating and learning from each other.
• Gain well rounded experience: EnergyHub offers a diverse and dynamic environment where you will get the chance to work directly with executives and develop expertise across multiple areas of the business.
• Work with the latest technologies: You'll gain exposure to a broad spectrum of IoT, SaaS and machine learning obstacles, including distributed fault-tolerance, device control optimization, and process modeling to support scalable interaction with disparate downstream APIs.
• Be part of something important: Help create the future of how energy is produced and consumed. Make a positive impact on our climate.

About EnergyHub

EnergyHub empowers utilities and their customers to create a clean, distributed energy future. We help consumers turn their smart thermostats, EVs, batteries, and other products into virtual power plants that keep the grid stable and enable higher penetration of solar and wind power.

To learn more, visit energyhub.com.

EnergyHub is an Equal Opportunity Employer

EOE, Including Disability/Vets. Reasonable accommodations are available for individuals with disabilities throughout the application process. If you are a person with a disability needing assistance with the application process, please contact accommodations.apply@energyhub.net.

In connection with your application, we collect information that identifies, reasonably relates to or describes you ("Personal Information"). The categories of Personal Information that we may collect include your name, government-issued identification number(s), email address, mailing address, other contact information, emergency contact information, employment history, educational history, and demographic information. We collect and use those categories of Personal Information about you for human resources and other business management purposes, including identifying and evaluating you as a candidate for potential or future employment or future positions, recordkeeping in relation to recruiting and hiring, conducting analytics, and ensuring compliance with applicable legal requirements and Company policies. By submitting your application, you acknowledge that we may retain some of the personal data that you provide in your application for our internal operations such as managing our recruitment system and ensuring that we comply with labor laws and regulations even after we have made our employment decision.

Notice To Third Party Agencies:

EnergyHub understands the value of professional recruiting services. However, we are not accepting resumes from recruiters or employment agencies for this position. In the event we receive a resume or candidate referral for this position from a third-party recruiter or agency without a previously signed agreement, we reserve the right to pursue and hire those candidate(s) without any financial obligation to you.