[南港]品牌原廠_Data Programmer(KA_823)

[南港]品牌原廠_Data Programmer 年薪百萬以上 意者歡迎投遞履歷至emma.fu@adecco.com Job Description – Data Programmer • Develop data automation in Excel and SQL using functions, macros and VBA as needed • Create new Cost validation programs, SQL databases and maintain existing databases • Create advanced User Interfaces (UI) in Excel • Develop, maintain, and support existing MS Excel VBA applications, and analyze and convert business requirements as needed. • Develop SQL queries and stored procedures to fetch data from different tables in remote databases in remote servers • Create and optimize SQL queries as needed • Analyze complex data to develop automated reporting with VBA, Excel and PowerBI • Develop and organize insightful reports, dashboards with custom visuals, slicers, measures, calculated columns using Data Analysis Expression (DAX) queries • Develop cost data reports that provide insights on different level of visualizations per user requirements • Develop SQL queries and stored procedures to fetch data from different tables in remote databases in remote servers • Perform object-oriented analysis and design, and diligent testing to ensure optimal performance of all assigned systems and system modules. • Developing test plans and software documentation to support code modifications and additions Requirement: Experience in Data programming Fluent English communication