BI ETL Engineer
迪卡侬亚太IT中心(decathlon)
- 公司规模:50-150人
- 公司性质:外资(欧美)
- 公司行业:计算机软件
职位信息
- 发布日期:2019-01-15
- 工作地点:上海-浦东新区
- 招聘人数:1人
- 工作经验:3-4年经验
- 学历要求:本科
- 职位月薪:1.2-2.5万/月
- 职位类别:软件工程师
职位描述
Skill Set required :
ETL tools
Familiar with PostgreSQL
Strong SQL,PL/SQL experience
Linux shell scripting
Strong understanding on Data Warehouse concepts & technology Performance tuning.
Strong understanding of BI concepts & tools.
Demonstrated ability to write SQL/MDX queries to retrieve/analyze/modify data
Java, Elasticsearch is a plus
Previous experience with AWS, Azure Services and other cloud experience a plus
Big data technologies (as Hadoop, Pig, Hive, Spark, R, Python) is a plus
Job Description:
Project Overview: We are looking for talented people to join our China BI team. The successful candidate will be an experienced database/ETL/BI developer with 5+ years of experience in the I.T industry and can perform business relevant analysis in an applied environment, Omni commerce or retail is prefered.
Responsibilities:
? Development and implementation of Data Integration (ETL) and BI programs within the China BI Data Lake (BDL) project team to support different partners and different initiatives including effective campaign segmentation and analytics, data mining, modeling and profiling to turn disparate points of data into information and actionable metrics
? Work with the technology project teams to implement new functionality to support business needs.
? Implement technical data requirements for integrating Omni data source.
? Develop, maintain and support the data exchange process between production data and BDL to support Omni commerce
? Processing large data files in a LINUX environment.
? Writing scripts, functions and stored procedures using SQL or Oracle PL/SQL.
? Updating databases to ensure data integrity.
? Provide technical support and respond to error reports, problems or questions.
Qualifications:
? Years of experience: 5+ years.
? BS/BA in Computer Science or related discipline required.
? At least 5 years of technical experience with databases, data warehousing and BI tools .
? 3 years of experience with ETL tools like Informatica, Datastage, Talend etc.
? 3 years of experience with reporting and analytics tools – OLAP tools, Business Objects, Tableau
? Candidates with Talend experience will be given a strong preference.
? Experience with Unix/Linux shell scripting, java programming.
? Strong understanding of relational database concepts & technology – data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture.
? Experience with setup, configuration, design best practices, performance optimization, team based development approaches with a leading ETL/BI tool.
? eCommerce, Retail, Supply Chain Management experience preferred, but not required.
? Well organized and able to manage multiple projects in a fast paced demanding environment.
? Attention to detail and quality; excellent problem solving and communication skills.
? Ability and willingness to learn new tools and applications.
? Effective written and verbal communication skills with ability to convey complex technical concepts to business users and management
Decathlon introduction:
In Decathlon, more than 80,000 employee are working hard on full supply chain, working for more than 1,300 stores in 40 countries worldwide to provide outstanding products & services. With our best efforts, we make all sports accessible to as many people as we can.
Decathlon group was build up in 1976 in France, the first time to make all sports under one roof. Decathlon’s mission in in sports mass market. Decathlon is all sports products designer, sports brand owner and sports product retailer, with full of supply chain of R&D, design, brand, production, logistic and omni-channel retail, now we open more than 1300 stores in 40 countries with more than 80,000 team members worldwide.
By Jan,2018 in China, we’ve opened 266 stores in 106 cities, and with e-commerce covering more than 390 cities
Decathlon Asia IT Center-Solution & Technology:
We are Solution & Technology Department.
We are a team of 130+ employees.
We provide professional IT solutions, Services and Support for Decathlon China and Asian countries, including Production, Supply Chain and omni-channel commerce activities.
We master strongly our solutions technically and functionally
We are not only a service department but we are business partner in heart of the digital transformation of Decathlon.
Join us and contribute to the amazing decathlon platform project!
Send your CV(En&CN) send to:
recruitment.edp@decathlon.com
职能类别: 软件工程师
公司介绍
在迪卡侬,超过8万名员工在全产业链的岗位上努力工作,
致力于为全球40个国家,1300多家商场的当地运动爱好者提供出色的产品及服务,
我们尽全力,让***泛的大众,同怀运动愿望,共享运动欢益!
迪卡侬集团于1976年在法国创立,开创了把所有的运动汇集在一个商场内的销售概念。集团致力于大众运动领域,是全球体育用品的设计者和品牌的缔造者,同时也是运动用品的零售商,集团集运动用品研发、设计、品牌、生产、物流及全渠道零售为一体,目前在全球40个国家拥有1300多家商场,员工超过80000人,在中国截至2018年1月,已有266家商场遍布全国106座城市,同时电子商务业务已经覆盖390余个城市。
迪卡侬亚太技术与支持中心简介:
我们是迪卡侬亚太区技术与支持中心,
我们是一个130多人的团队,
我们为迪卡侬中国和亚洲其他国家提供专业的方案,服务和技术支持,业务覆盖工业生产,采购,全渠道零售以及供应链,
我们不断技术能力和项目能力,完善策略,优化流程, 提升客户满意度,
作为技术合作伙伴,我们是迪卡侬集团在数字化和平台转型中的核心推动者。
加入我们吧,一起实现迪卡侬的平台转型!
简历(中英文)发送到:
recruitment.edp@decathlon.com
联系方式
- Email:recruitment.edp@decathlon.comROLES
- 公司地址:迪卡侬中国区总部兰嵩路555号