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