At Marina Bay Sands, the Lead Engineer is tasked with overseeing the comprehensive support of SAS suite of products (SAS EG, SAS AMO, SAS WRS and SAS Dashboard). This pivotal role involves executing all related activities to develop, maintain and manage data pipelines, databases, and associated solutions, all while adhering to organizational standards and best practices. Providing Level 2 support to business users on user requests and incidents. Working closely with business in gathering requirements and understanding the metrics required for generation of reports, cubes, dashboards, summarizing data tables for business products, sales, consumer marketing, customer integrated profiling, digital life, business marketing, consumer operations and marketing teams.

JOB SCOPE

• Reporting to the Associate Director of Systems Infrastructure
• Ensure highest availability level of SAS 9.4 suite of components, system and infrastructure availability, process efficiency, compliant and audit requirements.
• Act as Subject Matter Experts on content of SAS 9.4, the schemas, and the relations on data services platform, data analytics and database solution.
• Building SAS reports, Dashboards and Automation to support business on queries and visualizations over the databases.
• Introduce effective recovery tools and processes to meet the needs of the data operation and recovery readiness.
• Lead on troubleshooting and remediation of any incident or problem with infrastructure and data pipelines affecting availability of SAS data services.
• Maintain documentation template for new data services solution and update of architecture and design changes, updates for engineer/configuration, and operation transition for data services application rollout/enhancement.
• Possess solid understanding of IT policies, standards, SOP, procedures, regulatory/statutory and audit requirements.
• Update of processes and SOP, security hardening, alignment to standards, compliant, regulatory, and audit requirement.
• Update of SAS support processes and workflow, operating guides, and run book for smooth operation support and to handle production service request, access request, coordinate and raise change request to seek approval on change request.
• Setup regular monitoring/health checks and review them to detect any issue that requires follow up action to address capacity, performance issue, potential down time, data replication and consistency issue.
• Responsible with risk and vulnerability assessment at application level and come up with a risk remediation/security patch/mitigation according to risk rating timeline and follow up with the technology security and cyber risk team to manage risk exception if any.

Service Support:

• Developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data to other SAS applications for data updates, data cleansing and reporting.
• Define and design operation support process/workflow to enable operation teams to provide L1/L2 support. Monitor and oversee adhere to support KPI.
• Review on service operation gaps/KPI, provide regular training to L1/L2 support for continuous service improvement.
• Review of the health checks report to identify potential issues to resolve beforehand to avoid downtime.
• Identify and implement services improvements on operational monitors to measure system performance and capacity metrics.
• Submit Budgetary requirement on time for project proposal, operation capacity upgrade, service improvement plan, lifecycle maintenance contracts renewal.
• Establish and maintain all data operation processes through standardization, continuous service improvement.
• Tracking on the lifecycle of all deployed services and component for timely update/upgrade, ensure timely renewal of subscription, maintenance agreements and professional services needed to support system operation.
• Working closely with business in gathering requirements and understanding the metrics required for generation of reports, cubes, dashboards, summarizing data tables for business products, sales, consumer marketing, customer integrated profiling, digital life, business marketing, consumer operations and marketing teams.
• Foster a highly effective teamwork environment where accountability, clear effective communication, and a high level of customer service is demonstrated.
• Support 24x7 hours business operation, after office hours On-Call support is expected.

JOB REQUIREMENTS

• Bachelor’s degree in computer science, information technology, or a similar field.

• At least 5 years’ experience as a SAS Engineer with experience in development and maintenance support.
• Experience with SAS BASE, Enterprise Guide (EG), Event Stream Processing (ESP), Visual Analytics (VA) , Viya platforms (VI and VA) and Data Integration (DI) are required.
• Minimum 3yr experience in SAS application maintenance and SAS Management Console (SMC)
• Minimum 3yrs experience in dealing large data sets in Hadoop / Oracle / DB2
• Dashboarding experience with tableau / power BI / SAS VA is desirable
• Experience in shell /batch scripting

• Working knowledge of Hadoop ecosystem (Hadoop, Cloudera Data Science Work Bench, Flume, Hive, Hue, Impala, Kafka, Kudu, Oozie, Hbase and so on) using both automated toolsets as well as manual process.

• Knowledge and experience in end-to-end project delivery, either traditional SDLC or agile delivery methodologies (or hybrid approaches)
• Experiences in a delivery role on Business Intelligence, Data Warehousing, Big Data or analytics projects
• Exceptional communication, documentation and presentation skills and stakeholder management experiences
• Experiences in business intelligence, data warehousing/platform, and data strategy projects
• Application packaging and deployment experience across DEV to PROD environments.
• Experience in maintenance reporting and managing change / service requests.

• Good project management skills

Marina Bay Sands is committed to building a diverse, equitable and inclusive workforce, providing equal opportunities as we grow our talent base to match our growth ambitions in Singapore. Our employees are committed to adhere to and abide by all rules, regulations, policies and procedures, including the rules of conduct and business ethics of the Company.