Hiring for Solutions Architect -Data warehouse

PATH INFOTECH PTE. LTD.; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A leading tech firm in Singapore is seeking an experienced candidate to deliver data warehouse and advanced analytics solutions. Candidates should have strong knowledge of AWS and a background in healthcare informatics. The role emphasizes data modeling, ML, and data visualization skills. Ideal candidates will demonstrate good interpersonal skills and the ability to work under pressure, managing various stakeholders.

Qualifications

• Minimum eight years of experience in providing data warehouse or advanced analytics solutions.
• Experience in data modelling for analytics.
• Thorough understanding of ML and data analysis.

Skills

Data warehouse solutions

Advanced analytics solutions

SQL

R

Python

Data visualization

Event-driven architecture

Healthcare informatics

Interpersonal skills

Education

Degree/master’s in computer science or equivalent

Tools

AWS

Power BI

Tableau

OBIEE

ETL tools

Job description

Qualifications

• Degree/master’s in computer science, Information Technology, Computer Engineering or equivalent.
• Minimum eight (8) years’ experience in providing data warehouse or advanced analytics solutions.
• Experience with

• databases (e.g. Oracle, DB2, MS SQL, MySQL, Teradata, Databricks)
• data repository design (e.g. operational data stores, dimensional data stores, data marts, datalakes)
• data interrogation techniques (e.g. SQL, NoSQL).
• structured and unstructured data analytics.
• statistical computing programming language (e.g. R, Python).
• data quality tools and processes.
• data transformation and terminology equivalence mapping.

• Experience in data modelling for analytics (e.g. star schemas, snowflake schemas).
• Deep understanding of analytical models and methodologies – especially in the context of health analytics for clinical use and clinical safety (e.g. data mining, predictive analytics).
• Experience with data acquisition tools (e.g., ETL, real-time data capture, and change data capture).
• Thorough understanding of ML, data analysis, data visualization, and event-driven architecture.
• Exposure to the development, evolution and adherence to the architectures relevant to the domain.
• Ability to work with a wide variety of report generation software (e.g. Power BI, Tableau and OBIEE) and generate a wide variety of outputs (dashboards, scheduled reports).
• The ability to work towards strict and conflicting deadlines, be able to plan and prioritise in an environment with multiple stakeholders.
• Good interpersonal skills, a detail-oriented & flexible person who can work across different areas within the team.
• Familiarity or experience with health informatics would be preferred.
• An understanding of healthcare data governance, data acquisition and data management would be an advantage.
• Experience in interacting with analytics stakeholders (economists, statisticians, clinicians, policy makers) on a business or domain level would be preferred.

Cloud Exposure (AWS)

1. Strong knowledge and practical experience with AWS.
2. Familiarity with modern cloud application architecture.
3. Exposure to cloud managed services and microservices like Function as a Service, Containers, and managed databases.
4. Experience with setting up load balancers, cloud networks, and virtual servers.
5. Infrastructure as code (IAC): Cloud formation, terraform.
6. AWS identity and access management, integration with active directory.
7. Familiarity with security and access control measures to control privileged access to test and production environment.
8. Certification in AWS Cloud Practitioner or AWS Architect.