南京招聘

Job Overview工作概况

Build up an integrated BI solution, including collecting and arranging the internal and external data, ETL workflows, processing the BI functions needs of various departments as well as providing data support and reporting services for various departments. Responsible for providing the relevant data for external activities

建立完整的BI解决方案，包括收集整理内外部数据，ETL工作流程，处理各部门的BI功能需求，为各部门提供数据支持和报表服务。同时负责为外部赞助商等提出的场馆活动有关需求提供相关数据及分析。

Line Manager汇报对象

CIO信息技术总监

Job Description工作职责

· Daily BI solution basic support, including: data collection（including interface）, data cleaning, ETL workflow, BI reports and data governance.

日常BI解决方案基础支持，包括:数据收集(包括接口)、数据清理、ETL工作流、BI报表、数据治理。

· Optimize existing databases structures in order best determine how to consolidate and aggregate data in an efficient and scalable way. Design and code all aspects of data solutions, could build out an Operations data warehouse.

优化现有数据库结构，以***地确定如何以高效和可伸缩的方式合并和聚合数据。设计和编写各方面的数据解决方案，可构建一个可操作的数据仓库。

· Create and propose technical design documentation, which includes current and future ETL functionality, database objects affected, specifications, and flows and diagrams to detail the proposed implementation.

创建和建议技术设计文档，其中包括当前和未来的ETL功能、与之相关的数据库对象、规范、流程和图表，以详细说明所提建议的实现。

· Monitor the backlog and ad hoc request queue along with peers to fulfill data & reporting needs for internal and external reporting in a timely manner. Become a subject matter expert in report generating best practices and be able to produce ad-hoc analyses quickly

监控商业智能系统后台日志代码，处理临时增加的报表分析需求，及时为内部及外部报告完成所需数据报告。成为报告生成***实践的专家，并能够快速为临时增加的分析需求生成分析报告。

· Deep understanding of business logic, identify information gaps within the organization by discussing data needs with commercial, finance, operations, and marketing teams

深刻理解业务逻辑，通过与业务部、财务部、运营部和销售团队讨论数据需求来识别组织内的信息缺口，并加以完善。

· Dashboards leveraging PowerBI, Tableau, QlikView and other such business intelligence tools to provide operational insight

利用PowerBI、Tableau、QlikView和其他类似的商业智能工具来提供和运营洞察分析

· Ability to thrive in a fast-paced, rapidly-changing, and often ambiguous environment

能够在快节奏，快速变化的环境中工作

Requirements

· 1+ years of work experience writing and debugging advanced SQL queries (ETL, data modeling, data mining, database design, business intelligence architectures, etc.) with large-scale, complex data sets in a business setting

1年以上编写和调试高级SQL查询(ETL、数据建模、数据挖掘、数据库设计、业务智能架构等)的工作经验，在业务环境中处理大型复杂数据集

· 1+ years of relevant experience in BI solution design and development, dashboarding best practices, data modeling, architecture, and process mapping. Could use BI visualization tools for reporting services, preferably Tableau, QlikView, PowerBI.

1年以上BI解决方案设计和开发、仪表盘***实践、数据建模、架构和流程映射方面的相关经验。可以使用BI可视化工具报告服务，***是Tableau, QlikView, PowerBI。

· Basic knowledge of Big data (HDFS, Event Hub, Spark), and AI (ML, DL, NLP)

具备大数据(HDFS、Event Hub、Spark)、AI (ML、DL、NLP)基础知识

· Experience Data governance and data security, including database security configurations, administration. Knowledge of GDPR, CSL, or other related laws and regulations.

熟悉数据治理和数据安全，包括数据库安全配置和管理。具备GDPR、CSL或其他相关法律法规的知识。

· Bachelor’s or advanced degree in Business, Statistics, Computer Science, Information Systems, or related degree. Excellent both Chinese and English.

商学、统计学、计算机科学、信息系统或相关专业本科以上学历。良好的中英文听说读写能力。

万宝盛华大中华有限公司，1997年服务启航于香港和台湾。迄今服务覆盖上海、北京、广州、深圳等逾20座直营城市。我们的大股东万宝盛华全球（ManpowerGroup Inc. NYSE:***）是全球人力资源解决方案领导者，拥有70年服务经验。凭借万宝盛华全球的声誉及行业经验，万宝盛华大中华深耕本土20余年。2015年，万宝盛华大中华战略联盟中信产业基金，总部落地上海，服务网络覆盖两岸三地130余城市逾两万家企业。我们始终致力于释放人才的发展潜能，凭借灵活用工、人才寻猎、招聘流程外包、人才管理及培训发展等人力资源综合解决方案，广受业界赞誉，屡次荣膺“亚太人力资源领军企业”。