Job Description
• Help support and maintain data/data aggregation model and ETL.
• Support in daily data quality monitoring and data issue resolution.
• Support data query from users and investigation.
• Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization.
• Work with various system business analyst and solution analyst to understand solution and process to be able to do reporting, data extract for user.
• User report/dataset support and enhancement follow company process.
• Develop report/dashboard/dataset for business user base on request.
• Assist to support existing reports/dashboard/dataset and also maintain report/dashboard/dataset repository. Support data engineer in key company project / initiative.
Job Requirement
• Experience/Skill:
o Bachelor’s Degree in Computer Science / Engineering with Business degree is a bonus.
o Knowledge of Agile Software Development methodologies
o Problem solving and troubleshooting skills
o Process oriented with great documentation skills
o Excellent oral and written communication skills with a keen sense of customer service
o Supporting, and maintaining ETL job, data warehouse / data lake
o Data visualization on Microsoft PowerBI
o Experience
o Knowledge/Skill:
o Advanced SQL query. Source code version control: Bitbucket
o Data warehousing Data architecture Coding (Java/C#)
o Databases: SQL Server, DB2, Couchbase, MySQL, Oracle, SQLITE
o Operating Systems: Windows / Linux
o Visual Studio, Visual Studio Code, SQL Server Management Studio
o Data replication with SQL Server Integration Services (SSIS).
o ETL with SQL script running on SQL Agent or SSIS Job.
o Change Data Capture (CDC) with SSIS or other technology.
o Apache Kafka topic streaming Data documentation
o Data dictionary, data flow diagram, data architecture
o Service Bus Explorer, Azure Storage Explorer, Postman, Fiddler