Remote Data Analytics Intern: Dashboards & Insights

Page Mechanical Group, Inc.; Northern (KY); Hybrid; USD 21,000 - 30,000; Full time

Job summary

Page Mechanical Group, Inc. is seeking an Intern of Data Analytics to assist the Economics team in building an interactive dashboard that visualizes key business metrics. The role focuses on data visualization and economic analysis using Excel.

You will develop and maintain dashboards, work with PivotTables, charts, slicers, and large datasets, and collaborate with the Chief Economist and Research Assistant to provide insights for decision-making.

Qualifications

• Pursuing a degree in a related field (Economics, Math, Stats, Data Science, CS).
• Experience with Excel dashboards and PivotTables, charts, slicers, and conditional formatting.
• Experience with economic data, financial models, or BI tools.
• Familiarity with open-source research.
• VBA or Power Query experience is a plus.

Responsibilities

• Develop and maintain interactive Excel dashboards to track key indicators.
• Utilize PivotTables, charts, slicers, and conditional formatting for visuals.
• Work with large datasets to identify trends and insights for decision-making.
• Collaborate with the Chief Economist and Research Assistant on dashboard functionality.
• Ensure data accuracy and consistency across reports.
• Document dashboard development processes for knowledge sharing.

Skills

Communication skills

Analytical thinking

Problem solving

Organizational skills

Interpersonal skills

Time management

Education

Bachelor's or Master's in Economics, Math, Stats, BA, Data Science

Tools

Excel

Power Query

VBA

Job description

Page Mechanical Group, Inc. is seeking an Intern of Data Analytics to assist the Economics team in building an interactive dashboard that visualizes key business metrics. The role focuses on data visualization and economic analysis using Excel.

You will develop and maintain dashboards, work with PivotTables, charts, slicers, and large datasets, and collaborate with the Chief Economist and Research Assistant to provide insights for decision-making.