Intern, Data Analysis & Automation

Ensign is hiring !

Key Responsibilities

• Document and map existing Excel files, reports, and manual workflows across various systems.
• Identify repetitive or manual steps that can be automated, and propose innovative solutions to consolidate data dispersed across multiple platforms, reducing manual effort and operational resistance.
• Support the development of automations using Excel (formulas, PivotTables, Power Query, basic VBA), Power BI, and Power Automate to streamline data extraction, presentation, and analysis.
• Leverage APIs from systems such as JIRA to integrate and connect automation processes across platforms.
• Perform data analysis to identify trends, anomalies, and insights, and translate these into clear outcomes aligned with senior management's objectives.
• Prepare reports, dashboards, and summaries (including presentation decks for senior management) that communicate findings in a clear and impactful manner.
• Maintain clear documentation of processes, data flows, and improvements.
• Ensure data accuracy and consistency across all sources and outputs.
   

Requirements

• Diploma in a relevant field (e.g. Business Administration, Information Technology, or related discipline)
• Strong skills in Excel formulas required; experience with VBA scripts is an advantage
• Familiarity with Power BI and/or Power Automate is preferred
• Exposure to API integrations (e.g. JIRA, REST APIs) is a plus
• Ability to conduct data analysis and present insights clearly to stakeholders
• A creative, problem-solving mindset with the ability to think outside the box
• Self-motivated and able to work independently when tasked with the outcome required
• Detail-oriented with strong organizational skills