职位描述:
Accountabilities 1. Operation, Maintain & Optimize the internal data warehouse and master data platform 2. Solve the business data issues or problems around the DW and MDM 3. Develop and integrate new business data source to DW by ETL and implement the data query requirements 4. Design and implement the data mart or dimensional modeling around business domain 5. Assist in the development & maintenance of BI reports based on Microsoft Power BI and excel service solution Knowledge/ Academic Qualification: - Bachelor's degree or above in computer science or related disciplines Skills: - Versed in SQL Server, SQL language and DB performance optimization. - Master Microsoft BI solution tools (SQL Server, SSIS, SSAS, Power BI and Excel). - Familiar with the knowledge about data warehouse, master data management, multi-dimension data; - Master .Net and C# language. - Plus: master DAX language. - Plus: Have R or Python language in data analysis experience. - Plus: knowledge and experience with big data, machine learning and related technologies. Experience: - At least 3 years’ experience in data warehouse or database maintenance and development. - 2+ years of database experience on DB Performance Tuning (Partitioning/ Index Design), Schema Design, Table Layouts & Materialized Views and Dimensional Modeling. - Experience with business application development by using C# is better. - Plus: projects experiences in related pharmaceutical industry. Competency: - Good Fast-learning Ability. - Strong working responsibility. - Good ability to work independently - Excellent communication and coordination ability. - Good team spirit, able to work under pressure.岗位职责:
任职要求: