Engineering Intern at EnergyHub in Remote

Summary: EnergyHub empowers utilities and their customers to create a clean, distributed energy future. The Engineering Intern will collaborate closely with the Data Engineering team to build and maintain core data products while gaining hands-on experience with modern data engineering tools and methodologies. Responsibilities: - 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 Required Qualifications: - 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 - 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 - Well-grounded stance on AI adoption that makes you a stronger, more capable engineer Preferred Qualifications: - Nice to have: Snowflake Data Warehousing Workshop (Badge 1) - Nice to have: dbt Fundamentals - Above-average appreciation for alliteration Required Skills: Data Engineering, SQL, Python, dbt, Sigma, Snowflake, Data Warehousing, Monitoring, Dashboarding, OLAP, OLTP, RDBMS, CSV, JSON, Parquet, Curiosity, Drive, Dedication