Market Analyst Intern at Intersect in San Francisco, CA

Summary: Intersect is a company focused on innovative energy solutions and modern infrastructure, recently acquired by Google. The Market Analyst Intern will support the Market Analytics team by building data pipelines, developing analytical tools, and delivering market insights to aid energy trading and commercial decision-making. Responsibilities: - Build and Improve Data Pipelines - Maintain and enhance ETL pipelines on Google Cloud Platform to ensure reliable, scalable data workflows - Refactor existing ETL processes to improve efficiency, robustness, and maintainability - Organize and clean up existing data and codebases to support long-term scalability - Develop Analytics and Automation Tools - Build automation tools using Python and SQL to streamline workflows for traders and originators - Develop analytical models that improve decision-making speed and accuracy - Support adoption of best practices in coding, version control, and DevOps within the analytics team - Deliver Market Insights - Produce quantitative analysis across power and natural gas markets, including ERCOT dynamics - Analyze large datasets to uncover trends related to generation, pricing, and emerging load drivers - Translate complex data into actionable insights for commercial and trading teams Required Qualifications: - Currently pursuing a Bachelor's or Master's degree in Mathematics, Computer Science, Engineering, Data Science, or a related quantitative field - Experience with data analysis, quantitative modeling, or market research through coursework, internships, or academic projects - Programming experience in Python and SQL (BigQuery experience is especially helpful) - Familiarity with data pipelines, ETL workflows, and version control tools such as GitHub - Exposure to JavaScript, data visualization, and exploratory data analysis techniques - Ability to work with large datasets and build structured analytical models - Understanding of electricity markets (especially ERCOT) and/or natural gas markets will help you ramp quickly - Familiarity with energy trading concepts or energy data analytics is a plus - Connections to academic or research communities in quantitative fields or energy systems are beneficial - Strong problem-solving skills and the ability to learn quickly in a fast-paced, evolving environment - A curious, humble mindset with a drive to understand complex systems and data - Ability to work independently on technical problems while collaborating closely with cross-functional teams - Commitment to analytical rigor, transparency, and building trust through data - Alignment with Intersect's values: humility, authenticity, long-term thinking, equity, and people-first collaboration Required Skills: Python, SQL, Data Analysis Important Skills: ETL Pipelines, Quantitative Modeling, Electricity Markets Nice-to-Have Skills: GitHub, JavaScript, Data Visualization, Exploratory Data Analysis Benefits: Mentorship: Each intern will receive guidance from experienced professionals throughout the program, Capstone Presentation: Interns will present their final project to executive leadership at the end of the program