Role details

SATS · SATS

Intern, Mutimedia and Simulation Design

Finance Internship Estimated $1,000 - $1,600 / month (role-title estimate)

Role summary

At SATS, this Intern, Mutimedia and Simulation Design role focuses on assisting in designing and implementing relational database schemas (SQL) to store company-wide operational data. Requirements include sQL Mastery: Ability to write queries, join tables, and understand relational database concepts and Proficiency: Hands-on experience with Power BI (preferred) or Tableau, specifically using DAX or Power Query.

Summary based on employer-provided role details.

Role highlights

Responsibilities

  • Assist in designing and implementing relational database schemas (SQL) to store company-wide operational data.
  • Data Integration (ETL): Clean, transform, and load data from various sources (Excel, APIs, legacy systems) into a centralized database.
  • Dashboard Development: Build interactive, real-time dashboards in Power BI or Tableau to help management track KPIs.
  • Perform regular data audits to ensure "data hygiene" and troubleshoot any connectivity issues between the database and the reporting tools. Documentation:
  • Create a simple "data dictionary" so the team understands what each data field means and where it comes from. Deliverables: Build Power BI dashboard for staff training compliance tracking. Design and build finance reporting process using power automate.

Requirements

  • SQL Mastery: Ability to write queries, join tables, and understand relational database concepts.
  • Proficiency: Hands-on experience with Power BI (preferred) or Tableau, specifically using DAX or Power Query.
  • Excel Power User: You should be comfortable with VLOOKUPs, Index/Match, and Pivot Tables.
  • Knowledge of Python or R is a significant advantage. Soft Skills:
  • Communication: The ability to explain technical data concepts to non-technical stakeholders.

Role Quick Info

Company SATS
Brand SATS
Category Finance
Location SGP,, SATS Maintenance Centre
Work type Internship
Pay Estimated $1,000 - $1,600 / month (role-title estimate)

Employer-listed pay is shown as published.
Other ranges are HiredInn estimates based on the role title or role area. Confirm pay with the employer before applying.

Tags

10 labels
FinanceEntry LevelAdmin SupportCorporateFood SafetyAirport HospitalityCateringFood SolutionsOperationsInternship