Hybrid - Data Developer - AWS Database/SQL/Python

Job Purpose

As the part of Data developer, you will responsible for:

• Maintain and design relational databases to support enterprise application and physical data modelling according to project requirements for data acquisition and security as well as customer-defined deliverables.
• Develop strategies for data modeling, design and implementation to meet stated requirements for Metadata management, Operation Data Stores, Data Lake, Data Warehouse, Data Marts and Extract Transform Load environments in batch processing and real-time injection.
• Create and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
• Carrying out day-to-day support for reporting system.

Major Accountabilities

1. Produce Technical Specification documentation for the assigned works
2. Take part in designing, coding and testing database
3. Manage delivery of tasks within a given timeline
4. Support other tasks as required by supervisor.
5. Review and interpret ongoing business report requirements
6. Build appropriate and useful reporting deliverables
7. Provide timely scheduled management reporting

Technical skills:

• Proficient with some of the modern relational databases such as Oracle, DB2, and SQL Server
• Hand-on experiences on designing and developing ETL solution by using SSIS or other ETL tools
• Strong in writing T-SQL, PL/SQL
• Good understanding of Data Modelling, processing and warehouse techniques
• Skilled at optimizing large complicated SQL statements
• Capable of troubleshooting common database issues
• Knowledge at reporting development with Microsoft SSIS and SSRS

Soft skills:

• Analytical thinking
• Good interpersonal and communication skills
• Time management
• Planning

Education: University or College degree in IT or equivalent.

Experience: at least 02 years of experience in Data Developer.

- Professional working environment.
- Healthcare and wellness programs.
- Internal and external training courses.