About this role
<h2 class="MsoNoSpacing" style="text-align:justify"><span style="font-size:20.0px"><b>Who We Are</b></span></h2> <p class="MsoNoSpacing" style="text-align:justify"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">As Singapore's first institute for lifelong learning, the Singapore University of Social Sciences (SUSS) champions inclusivity to bring education to all and ensure that they are given equal opportunities to develop to their fullest potential in our diverse learning environment.</span></span></span></p> <p class="MsoNoSpacing" style="text-align:justify"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">We advocate for the same for our people. We believe everyone should have equal opportunities and develop to their fullest potential in their careers.</span></span></span></p> <p class="MsoNoSpacing" style="text-align:justify"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Embark on an exciting lifelong journey with us in making a positive difference in your career and serving our society.</span></span></span></p> <p class="MsoNoSpacing" style="text-align:justify"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">For more information on Singapore University of Social Sciences, please visit </span><a href="http://www.suss.edu.sg" style="color:#0563c1;text-decoration:underline"><span style="color:#000000">www.suss.edu.sg</span></a></span></span></p> <div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:20.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Who We Are</b></H2> </div><div><p><span style="font-size:12.0px"><span style="font-family:Arial, Helvetica, sans-serif">As Singapore's first institute for lifelong learning, the Singapore University of Social Sciences (SUSS) champions inclusivity to bring education to all and ensure that they are given equal opportunities to develop to their fullest potential in our diverse learning environment.<br> We advocate for the same for our people. We believe everyone should have equal opportunities and develop to their fullest potential in their careers.<br> Embark on an exciting lifelong journey with us in making a positive difference in your career and serving our society.<br> For more information on Singapore University of Social Sciences, please visit<br> www.suss.edu.sg</span></span></p> </div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:20.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>About The Job</b></H2> </div><div><p style="margin-bottom:11.0px"><span style="font-size:12.0px"><span style="font-family:Arial, Helvetica, sans-serif">The Data Warehouse Developer is critical in managing and optimising the University’s data warehouse to meet its current and future business intelligence and reporting needs.<br>This individual collaborates with the Data Architect Specialist and other units to uphold and enhance the technical efficacy of the BI&A Data Warehouse, balancing current operational demands with forward-looking technology strategies.</span></span></p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:20.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Job Description</b></H2> </div><div><ul> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Plan, develop, and script ETL processes for both cloud and on-premise data warehouses, and perform ETL unit and development testing.</li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Design automation processes to control data access, ensure data availability and integrity and optimise data integration across cloud and on-premise environments.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Conduct performance tuning of end-to-end integration processes within source/target databases in cloud and on-premise systems.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Design and implement unit tests and prepare test data for solutions in both environments.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Investigate and resolve data issues promptly in cloud and on-premise data warehouses.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Monitor data warehouse operations and provide subject matter expertise to support maintenance and ongoing enhancements in both cloud and on-premise platforms.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Define and implement security requirements for the data warehouse across cloud and on-premise environments.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Collaborate with stakeholders on business intelligence (BI) and analytics requirements, leveraging cloud capabilities and on-premise systems.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Conduct feasibility studies, facilitate BI and analytics projects, and ensure successful delivery in both environments.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Ensure project timelines are met within cost and quality guidelines, considering cloud and on-premise resource allocation.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Ensure IT compliance with corporate governance, best practices, and University policies in cloud and on-premise contexts.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;line-height:107%;font-family:arial, helvetica, sans-serif">Attend relevant training and development courses focused on cloud technologies and participate in University-wide activities.</span></li> <li style="font-family:helvetica, arial, sans-serif;font-size:12.0pt"><span style="font-size:12.0pt;line-height:107%;font-family:helvetica, arial, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Perform other tasks and activities as supervisors assign, supporting initiatives in cloud and on-premise data warehouse</span>s.</span></li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Job Requirements</b></H2> </div><div><ul> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Bachelor’s or Master’s degree in Computer Science, IT, Data Science, or related field from a recognised university.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Minimum 5 years of experience in data warehousing, across cloud and on-premise environments.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong experience in SQL/coding, database administration, QA testing, and data warehouse monitoring.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Solid knowledge of dimensional modelling and data warehouse design principles.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Hands-on experience with cloud platforms such as AWS Redshift, Azure Synapse Analytics, or Google BigQuery.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience with ETL tools such as AWS Glue, Azure Data Factory, or IBM Infosphere DataStage.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Familiar with BI and reporting tools such as Power BI, MicroStrategy, or similar.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong analytical skills with the ability to translate complex data into actionable insights.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Good communication and stakeholder management skills, with the ability to work across technical and business teams.</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Detail-oriented, adaptable, and committed to data quality and best practices.</span></li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:20.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>What Do We Offer</b></H2> </div><div><p>At SUSS, we advocate the Spirit of Learning and pride ourselves as lifelong learners. You will gain access to various learning platforms and plenty of development opportunities to support your growth in a meaningful career!</p> <p><br> Besides that, you will also get:</p> <ul> <li>Competitive Pay Package</li> <li>Hybrid Work Arrangement (Subject to Job Role)</li> <li>Medical Benefits</li> <li>Flexible Benefits</li> <li>Family Care Leaves</li> <li>Volunteer Service Leaves</li> <li>Wellness & Recreation Activities</li> <li>Lifelong Learning Opportunities</li> <li>Career Development Opportunities through Internal Job Postings and Transfers</li> </ul> </div></div></div><h2 class="MsoNoSpacing"><span style="font-size:20.0px"><b>What We Offer</b></span></h2> <p class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">At SUSS, we advocate the Spirit of Learning and pride ourselves as lifelong learners. You will gain access to various learning platforms and plenty of development opportunities to support your growth in a meaningful career!</span></span></span></p> <p class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Besides that, you will also get:</span></span></span></p> <ul> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Competitive Pay Package</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Hybrid Work Arrangement (Subject to Job Role)</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Medical Benefits</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Flex Benefits</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Family Care Leaves</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Volunteer Service Leaves</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Wellness & Recreation Activities</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Lifelong Learning Opportunities</span></span></span></li> <li class="MsoNoSpacing"><span style="font-size:13.333px"><span style="font-family:Arial, Helvetica, sans-serif"><span style="color:#000000">Career Development Opportunities through Internal Job Postings and Transfers</span></span></span></li> </ul>