About the Role
Supports the design, implementation and maintenance of data
flow channels and data processing systems that support the collection, storage, batch and
real-time processing, and analysis of information in a scalable, repeatable and secure
manner. He/She focuses on defining optimal solutions to data collection, processing and
warehousing. He designs, codes and tests data systems and works on implementing those
into the internal infrastructure. He/She focuses on collecting, parsing, managing,
analysing and visualising large sets of data to turn information into insights accessible
through multiple platforms. He/She uses development tools to generate reports,
dashboards and analytical solutions according to business rules and specifications.
He/She is passionate about data and works with large data sets. He/She has a keenness for
understanding business processes and resolving challenges in order to provide solutions
with the help of clean and interlinked databases and architectures. He/She adopts an
analytical approach to solving problems and displays confidence when communicating
ideas.
Responsibilities
- Work with stakeholders to understand needs for data structure, availability and accessibility
- Support the translation of data needs into technical system requirements
- Advise on latest technologies, strategies, and products in database and data processing software
- Recommend types of data and data sources needed
- Support the building of data flow channels and processing systems to extract, transform, load and integrate data from various sources
- Develop complex code, scripts and data pipelines to process structured and unstructured data near real-time
- Develop prototypes and proof of concepts for the selected solutions
- Support the identification of data sources (both internal and external)
- Perform operational ad-hoc data provision to extract/load data based on stakeholder requirements using ETL tools such as Informatica
- Gather data from internal systems and external sources
- Enter information into data collection systems
- Clean databases from duplicated, outdated or irrelevant information
- Perform data validation and quality control check
- Mine data to identify trends, patterns and correlations
- Develop automated and logical data models and data output methods
- Design data reports and visualisation tools to facilitate data understanding
- Assist with integration of data systems into existing infrastructure
- Develop tools to improve data flows between internal/external systems and the data warehouse
- Automate data collection and analysis processes, data releasing and reporting tools
- Test data system configurations and perform regular tuning to increase efficiency
- Facilitate data cleansing, enrichment and data quality improvements
- Monitor data system performance
- Support the handling and logging of errors
Requirements / Qualifications
- At least 8 years’ experience in the IT industry, with minimum of 5 years of working experience in application maintenance and ETL tools.
- Degree in Computer Science, Computer Engineering or equivalent practical experience
- Knowledge and relevant experience in one or more of the following areas:
- Data visualization tools such as Tableau, OBIEE
- ETL tools such as Informatica & MS-SQL SSIS
- Equipped with key SQL Skillsets on Oracle, Teradata and MS-SQL Server databases
- Experience in Operation/Support role
- Able to work independently and in a team.
- Basic knowledge of cloud fundamentals (AWS/Azure). AWS Cloud Certified Practitioner certificate would be added bonus.
- Well-versed with ITIL processes, with good/concrete working experience under ITIL best practices.
- Good appreciation of IT Security and IT Governance standards and practices.
- Team player good interpersonal skills in interacting with external customers and internal stakeholders (which includes presentation to management).
- Excellent communication, negotiation and professional writing skills.
- Working experience managing Application Maintenance contracts and vendors’ SLAs.
- Knowledge in healthcare domain; or exposure to hospital information / clinical dashboard is an added advantage.
If you are interested in this role and would like to discuss the opportunity further please click apply now or email Chew Kai-Xinn at [email protected] for more information.
Only shortlisted candidates will be responded to, therefore if you do not receive a reply within 14 days please accept this as notification that you have not been shortlisted.
Morgan McKinley Talent Solutions
Morgan McKinley Pte Ltd EA Licence No: 11C5502
EAP Registration No: R2196712
EAP Name: Chew Kai-Xinn
