JOB DESCRIPTION This 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 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 adopts an analytical approach to solving problems and displays confidence when communicating ideas.
Identify business needs
- 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
Build data processing systems
- 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 solution
- Support the identification of data sources (both internal and external)
- Perform operational ad-hoc data provision to extract/load data based on stakeholders requirements using ETL tools such as Informatica
Analyse Data
- 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 checks
- Mine data to identify trends, patterns and correlations
- Report Insights
- Develop automated and logical data models and data output methods
- Design data reports and visualisation tools to facilitate data understanding
Optimise solution performance
- 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
- Maintain data processing solutions
- Monitor data system performance
- Support the handling and logging of errors
Requirements: - Minimum 5 years of experience in developing, implementing and maintaining IT systems preferably in the area of a C3 system or Business Intelligence project
- Proficiency in both ASP .Net and Java development tools and environment
- Very strong SQL on relational databases such as MS-SQL, Oracle, etc
- Ability to diagnose and troubleshoot problems in a logical and orderly manner with root cause analysis
- Experience in providing application support for maintenance of IT systems
- Strong analytical skills and ability to work independently
- Experience in healthcare industry is an added advantage
- Degree in Computer Science, Computer Engineering or equivalent
WORK LOCATION
Nearby Transportations
Address
6 Serangoon North Avenue 5 Singapore