《如果你想加入科技業 / 熟練SQL應用 / 曾擔任DBA / 歡迎按下主動應徵了解更多》 【Job Description】 ▲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.
月薪60,000元以上
(固定或變動薪資因個人資歷或績效而異)未填寫