Intern, Data Analysis & Automation

Posted:
8/31/2026, 12:23:12 PM

Experience Level(s):
Internship

Field(s):
Business & Strategy ⋅ Data & Analytics

Workplace Type:
On-site

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

Ensign Infosecurity Pte. Ltd

Website: https://ensigninfosecurity.com/

Headquarter Location: Singapore, Central Region, Singapore

Employee Count: 501-1000

Year Founded: 2018

IPO Status: Private

Industries: Cloud Security ⋅ Consulting ⋅ Cyber Security ⋅ Identity Management ⋅ Information and Communications Technology (ICT) ⋅ Information Technology ⋅ Internet ⋅ Network Security ⋅ Penetration Testing ⋅ Professional Services