IT Engineer
Posted
Summary
BI/data analytics role at TF-AMD Penang (semiconductor assembly & test): builds interactive dashboards and reports, develops T-SQL/PL/SQL stored procedures and SSIS ETL pipelines, ensures data quality, and joins a rotational 24/7 on-call rotation. Stack includes SQL Server, Oracle, Tableau/Power BI, and Python.
Job Responsibilities:
- Collaborate with cross-functional business and technical teams to gather, understand, and translate business requirements into effective reporting and data analytics solutions.
- Design, develop, and maintain professional, interactive dashboards and reports using data visualization tools, presenting meaningful insights through charts, graphs, tables, and other visual formats.
- Analyze, monitor, and optimize reporting processes to ensure data accuracy, performance efficiency, timely report delivery, and ease of accessibility for end users.
- Develop and implement data quality checks to ensure data accuracy and consistency.
- Design and implement custom data mapping, transformation rules, and business logic using ETL (Extract, Transform, and Load) tools to convert raw data into meaningful information for reporting and analysis.
- Develop T-SQL and PL/SQL store procedures, views, functions and build SSIS or others ETL packages using integration design, data architecture, and high-performance techniques.
- Provide 24x7 standby on call support through a rotational on-call support arrangement.
- Conduct user training, provide technical guidance, and maintain comprehensive documentation.
Required Qualifications:
- Bachelor's Degree in Information Technology, Computer Science, Software Engineering, Data Analytics, or an equivalent qualification.
- Minimum of 1–2 years of relevant working experience in data analysis, reporting, or Business Intelligence (BI). Fresh graduates with strong technical knowledge and relevant academic projects are encouraged to apply.
- Must have experience with RDBMS like Microsoft SQL Server and Oracle Database.
- Advanced proficiency in SQL programming
- Experience with data visualization tools such as Tableau or Power BI
- Knowledge or experience in ETL development and data integration tools, particularly Microsoft SQL Server Integration Services (SSIS) or equivalent platforms
- Strong programming knowledge in Python or other scripting languages for data processing and automation
- Understanding of statistical analysis, data modeling, and analytical techniques to support business decision-making
- Good knowledge of database design, data warehousing concepts, data structures, and data management principles
- Ability to work with large datasets, perform data analysis, identify data patterns, and troubleshoot complex data-related issues
- Excellent interpersonal, communication and presentation skills in both verbal and written.
- Strong analytical, problem-solving, and critical-thinking skills with excellent attention to detail and accuracy
- Ability to work independently, prioritize tasks, and manage multiple assignments within tight deadlines
- Adaptability and ability to work effectively in a fast-paced, multicultural, and multinational working environment
- Willingness to participate in a rotational 24/7 standby on-call support arrangement when required
Skills
Sign in to read and join the discussion.