Filter Jobs

Skills:

Data Analysis, ETL, Data Warehousing

Job type:

Full-time

• Data Architecture: Design, develop, and maintain the overall data architecture and data pipeline systems to ensure efficient data flow and accessibility for analytical purposes.
• Data Integration: Integrate data from multiple sources, including point-of-sale systems, customer databases, e-commerce platforms, supply chain systems, and other relevant data sources, ensuring data quality and consistency.
• Data Modeling: Design and implement data models that are optimized for scalability, ...
• Data Transformation and ETL: Develop and maintain efficient Extract, Transform, and Load (ETL) processes to transform raw data into a structured format suitable for analysis and reporting.
• Data Warehousing: Build and maintain data warehouses or data marts that enable efficient storage and retrieval of structured and unstructured data for reporting and analytics purposes.
• Data Governance and Security: Establish and enforce data governance policies and procedures, including data privacy and security measures, to ensure compliance with industry regulations and protect sensitive data.
• Data Quality and Monitoring: Implement data quality checks and monitoring mechanisms to identify and resolve data inconsistencies, anomalies, and issues in a timely manner.
• Collaboration: Collaborate with cross-functional teams, including data scientists, business analysts, and software engineers, to understand their data needs, provide data solutions, and support their analytical initiatives.
• Performance Optimization: Optimize data processing and query performance to ensure efficient data retrieval and analysis, considering factors such as data volume, velocity, and variety.
• Documentation: Maintain documentation of data processes, data flows, data models, and system configurations, ensuring accuracy and accessibility for future reference.
• Bachelor's or master's degree in computer science, information systems, or a related field.
• Strong programming skills in languages such as Python, SQL. C++ is plus.
• At least 3 year experience with data modeling, database design, and data warehousing concepts.
• Proficiency in working with relational databases (e.g., MySQL, PostgreSQL) and big data technologies (e.g., Hadoop, Spark, Hive).
• Familiarity with cloud-based data platforms, such as AWS.
• Knowledge of ETL tools and techniques for data integration and transformation.
• Understanding of data governance, data security, and regulatory compliance requirements.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills to collaborate effectively with cross-functional teams.
• Ability to work in a fast-paced environment and handle multiple projects simultaneously.
• Location: BTS Ekkamai
• Working Day: Mon-Fri (WFA Every Friday).

Skills:

SQL, ETL, Power BI

Job type:

Full-time

• เขียน Script บน SQL Server(Store Procedure).
• หา Debug Script และหาจุดผิดพลาดได้.
• ใช้ SQL Server Integration Services (SSIS) สร้าง Job สำหรับ ทำการดึงข้อมูลจากแหล่งต่าง ๆ มาใช้งานได้ (ETL).
• สร้าง Report BI ตาม Requirement โดย Microsoft SQL Server Analysis Service (SSAS).
• ประสานงานกับฝ่ายต่าง ๆ เพื่อให้ได้ข้อมูลตาม Requirement.
• ทดสอบ Report BI ตามที่ได้รับมอบหมาย.
• สร้าง Roles และกำหนด Authorize ให้กับ User.
• จัดทำคู่มือของและอบรมการใช้ Report BI.
• ปริญญาตรี สาขาเทคโนโลยีสารสนเทศ หรือ สาขาอื่นๆที่เกี่ยวข้อง.
• มีประสบการณ์ Business Intelligence 2 ปีขึ้นไป.
• สามารถใช้ Microsoft SQL ได้ดี.
• หากมีทักษะการสร้าง Report และ เขียน DAX บน Power BI จะพิจารณาเป็นพิเศษ.
• สถานที่ทำงาน.
• CW Tower (MRT ศูนย์วัฒนธรรม).