Business Intelligence and Data Intern

Sprague Energy - Portsmouth, NH

- Intern

Hybrid - Portsmouth, NH

Merchant Wholesalers, Nondurable Goods

About the position

This position will be based out of Sprague's Portsmouth, NH office. (Some level of hybrid work can be considered). Local, New England area candidates preferred. Sprague is looking for a Business Intelligence and Data Intern for Summer 2025 to support the Retail Natural Gas and Electricity Business Operations team. We are seeking upbeat and energetic candidates with excellent communication skills, who thrive on challenges and are excited about the idea of working in a high growth, fast-paced organization in the energy sector. The intern(s) will work with assigned supervisors / subject experts from the Retail Business Operations and Analytics team and will interact with other members of the Retail Energy BU team as well as present project results and receive feedback from the management team. We are looking for candidates with a strong interest and academic background in Business Analytics, Data Analytics and Data Science with multidisciplinary skills across Business, Economics, Finance and Statistical analysis. The ideal candidate should also be eager to learn more about the challenges facing the energy markets and have a desire to develop their skills and solve problems in the energy industry as a career path. The successful candidate will develop and apply skills in business intelligence (BI), data visualization, data modeling, data management, data process automations, data governance and data solutions architecture on prem and in the cloud environment and other business and data analytics areas, while learning from and supporting energy industry professionals and contributing towards the Sprague Retail Energy BU goals. Interns might also be required to independently analyze and propose solutions for specific business problems.

Responsibilities

• Collaborate with cross-functional teams to understand business needs and deliver data-driven solutions.
• Develop, maintain, and optimize BI reports, dashboards, and KPIs to support business decision-making.
• Assist in the creation of data models, metadata layers, data markets, and related catalogs.
• Support the development and maintenance of data pipelines and infrastructure.
• Collaborate with stakeholders to gather and document business requirements for BI solutions.
• Develop and manage data management scripts, code version controls, and catalogs.
• Identify and implement process improvements for data management and analytics.
• Support business requirements and data architecture solutions related to data and BI.
• Automate repetitive business processes using BI and data tools.
• Provide data-driven insights and communicate findings and insights through visualizations and reports.

Requirements

• Currently pursuing a Bachelors or Master's Degree in Business Analytics, Data Analytics, Data Science, Economics, Finance, Business, Statistics, or a related field.
• Knowledge of Business Intelligence (BI) tools such as Power BI, Tableau, QuickSight, etc.
• Experience creating and maintaining dashboards, visualizations, and KPIs.
• Programming and development experience in Python, SQL, GitHub, etc.
• Strong drive to learn and develop a career in the energy sector.
• Enthusiasm for learning and professional growth.
• Familiarity with SQL and database management.
• Strong understanding of data modeling, data management, data layers, and data schemas.
• Some knowledge of cloud BI and data analytics environments (AWS, Azure, etc.).
• Experience in developing data and business analytics in AWS is a plus.
• Ability to translate complex data into actionable insights for non-technical stakeholders.
• Ability to solve problems, conduct research as needed, and see projects through to fruition.
• Strong interpersonal skills, attention to detail, and the ability to manage multiple projects simultaneously.
• Strong quantitative, analytical, and problem-solving skills.
• Interest in the energy industry, including energy sustainability and transition topics.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team to deliver high-quality BI solutions.
• Adherence to high standards of ethics and respect for individuals and the work environment.

Benefits

• Collaborative work environment
• Opportunities for professional growth
• Engagement in community initiatives