JOB DESCRIPTION
The Data Engineer will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.
1. Design, implement and maintain reporting databases, data warehouse and OLAP data structures
2. Design, develop, test, deliver, and implement SQL solutions within ETL processes.
3. Manage day to day operations of multiple Microsoft SQL Server/Oracle/DB2 databases.
4. Optimize databases for performance and scalability.
5. Develop, implement and optimize stored procedures and functions using T-SQL
6. Analyse, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, internal and external checks and controls, and outputs.
7. Responsible for problem resolution, database configuration, capacity planning, performance tuning and optimizations.
8. Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections.
9. Design, build, and deploy BI solutions
10. Responsible for on-call emergency response during database failure.
JOB REQUIREMENTS
• Minimum 2 years of experience in Microsoft SQL Server/Oracle
• Demonstrated strength in data modeling, ETL development, and data warehousing
• Experience using business intelligence reporting tools (Tableau, Cognos, PowerBI etc.)
• Comfortable working with development tools such as Git, JIRA, and DevOps
• Experience with Agile development methodology
• Strong team and communication skills
• Previous working experience with Azure Data Factory, Azure Data Warehouse, Azure and Azure Analysis Services, Azure Databricks and PowerBI is a BIG plus
To apply for the job, please email your CV and portfolio in English to trungtin-tt.ha@aia.com