Assistant VP, Data Engineer Posting Date: 5 Jan 2024 Location: Singapore (City Area), Singapore, 048624 Company: United Overseas Bank Ltd About UOB Un..
Assistant VP, Data Engineer Posting Date: 5 Jan 2024 Location: Singapore (City Area), Singapore, 048624 Company: United Overseas Bank Ltd About UOB United Overseas Bank Limited (UOB) is a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America. In Asia, we operate through our head office in Singapore and banking subsidiaries in China, Indonesia, Malaysia and Thailand, as well as branches and offices. Our history spans more than 80 years. Over this time, we have been guided by our values - Honorable, Enterprising, United and Committed. This means we always strive to do what is right, build for the future, work as one team and pursue long-term success. It is how we work, consistently, be it towards the company, our colleagues or our customers. About the Department Group Technology and Operations (GTO) provides software and system development, information technology support services and banking operations. We have centralized and standardized the technology components into Singapore, creating a global footprint which can be utilized for supporting our regional subsidiaries and the branches around the world. We operate and support 19 countries with this architecture to provide a secure and flexible banking infrastructure. Our Operations divisions provide transactional customer services for our businesses while also focusing on cost efficiency through process improvements, automation and straight through processing. Job Responsibilities The Data Engineer, Microsoft BI Developer & Administrator , is a member of the Data Analytics Technology team. This role will be responsible for the end-to-end software development and support for all work related to projects, quarterly change requests, L3 production fixes. This includes software product implementation and administration, application design, development, implementation, testing and support. You will be expected to work on Finance & Risk Analytics domain. Key responsibilities for this role are: Lead Server Administration activities for SSAS (SQL Server Analysis Services) & SSRS (SQL Server Reporting Services) for On-Premise implementation Build PowerShell scripts required for processing data in SSAS & SSRS reports Analyse and trouble-shoot SSAS, SSRS, Excel Add In and In-Memory related production issues by collaborating with other technical, vendor and business teams; Drive performance tuning Resolve connectivity issues of MBI solution with underlying Teradata / Hadoop based Data Marts & Enterprise Data Warehouse Handle and maintain BAU deployed applications to ensure stability, reliability, security, performance and SLA monitoring in SIT, UAT and production environment Liaise with the end-user and technical solution team to implement solutions that align with the organization's business objectives. Create frameworks, technical features which helps in faster operationalisation of Reporting solutions Independently install, customise and integrate software packages and programs Manage the technical delivery within timeline and with quality Carry out POCs involving new data technologies Ensure end-user satisfaction and meeting service level agreement Create technical documents such as solution design, program specifications for target solutions Maintain and recommend software improvements to ensure a platform centric management of software applications Work on delivering Change Request and Project implementation for Microsoft PBI solutions Involve in UAT, user training, pre-implementation preparation and post-implementation support activities Maintain and support MBI environment Ability to train users effectively to use the reporting tool, to build, customize & schedule reports Job Requirements The right candidate should possess: Min. 6+ years of experience in implementing SSAS & SSRS development & SSAS administration for On-Premise version of Microsoft Power BI Good knowledge of Power BI Server Architecture, expertise in PowerShell scripting Expertise in designing modular scheduling jobs (e.g. using Control-M) for refreshing SSAS In-Memory Models Expertise in performance optimization for SSAS Tabular models using Direct Query and In-Memory Models Experience in optimizing SSAS design by assessing DAX queries hitting Teradata based Data Warehouse & Data Mart Expertise in Windows / NT and SQL Server Administration - monitoring SSAS & SQL Server statistics Expertise in SSAS design, derived measures, SSRS reports & Data Modeling Knowledge of different code standards for SSAS, SSRS & PowerShell scripting; skills in leveraging reusable code components Experience in creating dashboards, volume reports, operating summaries, and presentations and graphs Hands on experience other BI Tools (Qlik) and Big Data tool stacks Knowledge in Data modelling, working with calculations, leveraging the Set Analysis Ensure incorporation of best practices and lessons learnt from prior projects Have Finance & Risk management domain knowledge Worked in large scale data warehouse & on premise Power BI, Qlik based visualisation Be a part of UOB Family UOB is an equal opportunity employer. UOB does not discriminate on the basis of a candidate's age, race, gender, color, religion, sexual orientation, physical or mental disability, or other non-merit factors. All employment decisions at UOB are based on business needs, job requirements and qualifications. If you require any assistance or accommodations to be made for the recruitment process, please inform us when you submit your online application. Apply now and make a difference.
