Job Description
- Responsible for developing programs and automated processes to cleanse, integrate and evaluate large datasets from disparate sources and implement business logic to build data warehouse to serve business functions including BI dynamic reports and other applications requested by business operation.
- Responsible for working with other stakeholders to support data pipelines, convert data models to data products.
- Obtain and integrate data and information from various sources into the centralized platforms, solutions, and statistical models.
- Write scripts and ingest raw data to build and maintain optimized data pipelines and ETL solutions as business support tools in providing analysis.
- Ensure data assets are organized and stored in an efficient way so that information is easy to access and retrieve.
- Identify and resolve performance and capacity issues.
- Establish and maintain backup and recovery processes.
- Maintain associated non-referential data.
- Manage user rights and permissions.
Your Skills and Experience
- Minimum bachelors degree in computer science, Software Engineering, Business Information System, or Information Technology.
- At least 2 years of working as a data engineer/administrator.
- Experience with database technologies (e.g. SQL, NoSQL), business intelligence (preferably Power BI) and programming languages.
- Expertise in database server specification, performance tuning, analysis and optimization.
- Experience in designing and building dimensional data models, ETL processes, applied data warehouse concepts and methodologies, optimized data pipelines and assisted the architect as needed.
- Experience monitoring complex system and solving data and systems issues having a consistent and algorithmic approach to resolving them.
- Understanding of Information Security principles to ensure compliant handling and management of all data.
- Experience working in Agile teams to support digital transformation projects, having a clear understanding of Agile principles, practices and Scrum methodologies.
- Ability to work with database developers, engineers, and different operations and applications engineering teams to help them to identify, analyze, and resolve database performance issues.
- Deep knowledge of SQL database design.
- Familiarity with big data analysis.
- Excellent critical thinking, organizational and communication skills.
