Công Ty Luật TNHH Collectius Cms Lawfirm
Regional Data Engineer
Thông tin chung
Ngày đăng
09/12/2024
Cấp bậc
Chuyên viên- nhân viên
Số lượng tuyển
2
Hình thức làm việc
Toàn thời gian cố định
Yêu cầu kinh nghiệm
1 năm
Mô tả công việc
• Develop and maintain data warehouse, data mart and features store using different DBMS and Data platform (Databricks, SQL Server, Oracle).
• Construct and maintain ETL data pipeline from OLTP and CRM platforms to Data Lake.
• Control and ensure data quality reflecting the truth at each ETL phase by conducting the data reconciliation, logging.
• Optimize and finetune database queries for improved performance and scalability.
• Monitor and improve pipelines performance by identifying and resolving bottlenecks.
• Collaborate with the analytics team to design and build data models supporting business intelligence and reporting requirements.
• Monitor and troubleshoot data warehouse performance issues, including ETL processes, backups, and health check.
• Setup connectivity and integration (connector, gateway, API) with external services for historical to near real-time and real-time operations (dashboard, reporting, scoring).
• Prepare adhoc analysis and visualization to support decision making (via powerBI, Grafana or other BI tools)
• Document and maintain technical specifications for database structures and processes.
Yêu cầu công việc
I. Experience & Expertise
• Prefer bachelor’s degree in computer science, Information Systems, or a related field.
• Minimum one year of experience with different DBMS (Databricks, SQL Server, Oracle).
• Strong SQL and Python skills for query optimization and performance tuning.
• Proficient in data modeling and database design.
• Experience with ETL processes and tools. Prefer experience with Spark/Airflow.
• Familiarity with data warehousing concepts and best practices.
• Good knowledge of verbal and written English language.
II. Personal Characteristics
• Proactive, flexible personality and adaptable for the changes
• Accuracy and self-reliance
• Structural thinking and focus on the results.
• Be able to work as a part of a team and independently.
• Can work under pressure.
• Excellent problem-solving and analytical skills.
III. Nice-To-Have Area
• Additional experience with Hadoop, Dialer adapter, and other operational systems.
• Knowledge of real-time dashboard, reporting, and scoring.
• Understanding of data visualization tools and techniques
Quyền lợi
Benefits according to company policy and regulations of Vietnamese labor law (will be discussed during interview)
