Analytics Engineer (2-year contract) (2 vacancies), IITS

HYPERSCAL SOLUTIONS PTE. LTD.; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading educational institution in Singapore is seeking a Data Engineer to design and implement efficient data ingestion pipelines and develop insightful reports. The ideal candidate will have at least 5 years of experience, strong skills in Python and SQL, and a background in data warehousing. The role offers opportunities for professional development and competitive compensation in a collaborative environment.

Benefits

Competitive compensation packages

Generous professional development opportunities

Generous professional development opportunities

Qualifications

• Minimum 5 years in data engineering or relevant IT experience.
• Advanced skills in data engineering coding and principles.
• Experience developing data pipelines using Spark.

Responsibilities

• Design and implement automated data ingestion pipelines.
• Ensure data accuracy and consistency across datasets.
• Develop and maintain reports for business needs.
• Monitor and optimize the SMU Data Platform for efficiency.

Skills

Data engineering coding skills

Python

SQL

Spark

Data warehousing

Power BI

Azure DevOps

Git

Education

Degree/Diploma in Computer Science, IT or related discipline

Tools

Databricks

Microsoft Azure

GitHub

Job description

COMPANY DESCRIPTION

Singapore Management University is a place where high-level professionalism blends together with a healthy informality. The 'family-like' atmosphere among the SMU community fosters a culture where employees work, plan, organise and play together – building a strong collegiality and morale within the university. Our commitment to attract and retain talent is ongoing. We offer attractive benefits and welfare, competitive compensation packages, and generous professional development opportunities – all to meet the work‑life needs of our staff. No wonder, then, that SMU continues to be given numerous awards and recognition for its human resource excellence.

RESPONSIBILITIES

• This position is for Office of Integrated Information Technology Services (IITS).
• Efficient Data Ingestion Jobs
  • Achieve reliable, efficient data ingestion by designing and implementing automated pipelines that bring data from multiple sources into theU Data Platform, adhering to SMU's data engineering standards, data management guidelines, and data governance policies.
• Integrated and Actionable Data Assets
  • Ensure consistency and accuracy across datasets by cleansing, transforming, and standardising data according to business rules and common reference codes.
  • Establish data quality checks, validation, maintain high standards of data accuracy, compliance, and timeliness, remodel data structure to be analytics-friendly to support trustworthy reporting and insights generation.
• Report Development and Maintenance
  • Fulfil business needs through the development and maintenance of reports, translating requirements into effective data visualisations that align with analytics objectives.
• Data Platform Enhancement & Monitoring
  • Ensure the stability and efficiency of the SMU Data Platform by continuously monitoring platform health, resolving issues promptly, and optimising workflows to maintain timely and accessible data.
  • Assist the technical lead in sustaining and improving the data ecosystem infrastructure to align with SMU's requirements.
• Production Support
  • Maintain uninterrupted data access by monitoring and supporting production ETL jobs and reports.
  • Address and resolve data pipeline and report issues, ensuring updated data availability and process efficiency.
• Documentation & Knowledge Sharing
  • Support team alignment and knowledge retention by creating and maintaining detailed documentation of data engineering processes and report design, promoting standards, and fostering a culture of shared best practices.
• Continuous Improvement
  • Contribute to process improvements by identifying opportunities for automation and standardisation, reducing manual intervention, and enhancing data pipeline efficiency across the SMU Data Platform.

QUALIFICATIONS

• Degree/Diploma in Computer Science, IT or related discipline.
• Minimum 5 years in data engineering or relevant IT experience.
• Advanced skills in data engineering coding and principles, with expertise in designing scalable, reusable, maintainable high-quality data pipelines.
• Skilled in designing and implementing orchestration pipelines using Python, Spark, SQL, and related tools.
• Ability to write clean, efficient code from scratch, establishing core processes for data engineering within the team.
• Strong understanding of data warehousing, including dimensional modelling, data lakehouse concepts, data mesh, and visualisation frameworks.
• Experience developing data pipelines using Spark, with hand‑on experience in Databricks preferred.
• Experience reports, with hands‑on experience in Power BI preferred.
• Proficiency in data cloud platforms, preferably Microsoft Azure, Databricks.
• Proficient with tools like for version control, e.g. Azure DevOps, GitHub.
• Familiarity with DevOps, CI/CD processes, and automation practices is a plus.
• Results‑oriented, with a strong focus on both quality and efficiency.
• Proactive, positive problem‑solver with a "can‑do" attitude.

OTHER INFORMATION

Candidates who do not possess the stipulated qualifications but relevant work experience may still apply. Remuneration and appointment terms shall commensurate with qualifications and experience. SMU reserves the right to modify the appointment terms where necessary.

Please note that your application will be sent to and reviewed by the direct employer – Singapore Management University