Mô tả công việc

Reporting to: IT Manager - Application Development

Position purpose

Support the team leader and work with the team on developing and implementing IT software solution, in contribution to fulfill business objectives.

Accountabilities:

• Developing and maintain ETL, Data Warehouse, Business Intelligence project. (% of time: 35%)
• Support the team leader on technical analysis to provide the best technical solution as well as support colleagues for solving technical issues to complete the assigned projects / tasks on timely manner. (% of time: 20%)
• Investigate and answer daily enquiries on systems functional as well as problem encountered in order to resolve it in timely manner. (% of time: 15%)
• In charge of unit test on enhancements / new development under responsibility to ensure developed modules are matched with business requirements. (% of time: 20%)
• Assist users/team leader on building test scripts to cover all test cases. (% of time: 10%)

Working relationships:

• Internal interface:  All company employee. Particularly in Operations, Agency Administration, Alternative Distrubution, Actuarial, and Financial Division will be internal clients of this jobholder.
• External Interface: External contacts will include software vendor and consultants.

Challenges:

• Multi task projects, enhancements and production issues to progress concurrently, manage conflicts the resource and time schedule, amongst the various demands.
• The fast growing information technology, demands the jobholder to keep up to date with ever-changing knowledge and skills.
• Work under high pressure.

Yêu cầu công việc

Qualification:

• A Bachelor’s degree in information technology, computer science, engineering, or related field.
• Strong communicator in English (TOIEC at least 450 is bonus point)

Experience

• At least 03 years of experience as a Data/BI Developer
• Experience in the modern data warehouse design on Azure, BigQuery

Knowledge:

• Knowledge of ETL and BI tools such as: SSIS, Power BI[TV[2]  desktop, Power BI Services, Azure Data Factory, Tabular Editor …
• Interact with business analyst to develop database solutions that meet business requirements.
• Thorough knowledge of physical database design and data structures
• Indepth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of database objects including tables, indexes, views and statistics
• Proficiency in SQL with ability to write complex SQL queries and other features
• Troubleshooting any issues that arise with new database applications, and providing solutions to implement
• Analyzing existing databases and data needs of clients to develop effective systems
• Understanding data modeling, data schemas (normalized, flat, star, snowflake, etc..)
• Understanding data and query optimization, query profiling, and query performance monitoring tools and techniques
• Knowledge of CI/CD pipeline, Git collaboration, development process is a plus. (Nice to have)
• Experience with some of the modern relational databases, NoSQL (Nice to have)
• Experience with some of the modern analytic platform such as: Databrick, Synapse analytic (Nice to have)
• Ensure all database programs meet company and performance requirements
• Support application of business intelligence and marketing automation solutions
• Fundamental knowledge in OOP and languages such as: Python, Scala, R, SQL, Jinja… etc
• Experience with Microsoft PowerPlatform: Power Apps, Power automate… (Nice to have)

Skills:

• Programming skill.
• Excellent analytical skills
• Communication skill.
• Analysis skill.
• Team work spirit.