Intern, Data Analysis & Automation

Ensign is hiring !

We are looking for a detail-oriented intern to support the mapping of Excel-based processes, build simple automations, and assist with data analysis and reporting. This role provides hands-on exposure to real business workflows and opportunities to apply analytical and technical skills in a corporate environment.
 

Key Responsibilities

• Document and map existing Excel files, reports, and manual workflows.
• Assist in identifying repetitive or manual steps that can be automated.
• Maintain clear documentation of processes and improvements.
• Support the development of Excel automations using formulas, PivotTables, Power Query, and basic VBA (training provided where needed).
• Help automate data consolidation and recurring reports.
• Work with structured and semi-structured datasets (e.g. Excel, CSV).
• Perform basic data analysis to identify trends, anomalies, and insights.
• Prepare reports, dashboards, and summaries for internal stakeholders.
• Ensure data accuracy and consistency.