Data Warehouse Developer (1-year Contract)
SIM University
Singapore, SG
1d ago

JOB DESCRIPTION

The Data Warehouse Developer is responsible for the successful delivery of business intelligence to meet the university's analytics and reporting needs.

The incumbent will work with the Data Architect Specialist and other units in SUSS to implement the technical vision for applications in the business intelligence & analytics data warehouse.

  • Develop and prepare schedules for the data warehouse
  • Prepare plans for all ETL procedures
  • Analyse large databases and recommend appropriate optimisation
  • Administer all requirements and design various functional specifications for the data
  • Provide support to the Software Development Life cycle
  • Analyse various data warehouse objects
  • Prepare ad hoc query reports for both the technical and business teams
  • Prepare various code designs and ensure their efficient implementation
  • Evaluate all codes and ensure the quality of all project deliverables
  • Monitor Data Warehouse work and provide subject matter expertise
  • Provide support to various teams in all technical matters
  • Coordinate with external parties and participate in various technical meetings
  • Design and implement various unit tests on the system and prepare test data
  • Attend training and development courses relevant to work and / or personal development, as well as participate in University-wide activities
  • Perform other tasks and activities as assigned by supervisors
  • JOB REQUIREMENTS

  • Degree in Computer Science or any relevant field
  • Minimum of 3 years of work experience in technical, enterprise or data architecture, with experience in BI full cycle implementation
  • Minimum of 3 years of work experience with Infosphere DataStage and other ETL tools
  • Experience with technologies such as SQL Server 2016, SSIS and stored procedures
  • Experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database
  • Proficiency in dimensional modeling techniques and their applications
  • Familiarity with reporting or visualisation software such as Qlik Sense, Microstrategy and Tableau will be an added advantage
  • Organised, meticulous, pro-active, resourceful and self-motivated
  • Strong analytical, consultative, communication and documentation skills
  • Ability to make good judgement and work with both technical and business personnel
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form