ID:148531

二少

Data Analyst

  • 公司信息:
  • Amazon
  • 工作经验:
  • 6年
  • 兼职日薪:
  • 500元/8小时
  • 兼职时间:
  • 可工作日驻场(自由职业原因)
  • 所在区域:
  • 上海
  • 浦东

技术能力

用SQL、Power BI、Tableau进行数据分析、数据可视化、数据挖掘以及数据搬运(ETL);
在美国有过电商(Amazon)、网络(Comcast)、对冲基金(AQR)工作经验;
有Tableau、SQL证书。

项目经验

• 根据需求设计dashboard、建立数据库、搬运数据、整合数据、创建报表,并自动化日常操作。
• Design and create KPIs, business metrics and dashboards and schedule refreshments to support business decisions and find root causes of business issues
• Participate in design Business Process to standardize business flow and optimize operation steps of device returns
• Analyze activities performance including billing transactions and non-billing transactions
• Understand business needs, design solution approach and create documents with sequence diagrams to illustrate business operation process and other issues
• Create and optimize SQL queries, views, stored procedures, indexes and table structure and perform error handling to load raw data from different sources into SQL database
• Created SSIS packages with data flow tasks such as Conditional Split, Derived Column, Slowly Changing Dimension and Row Count to maintain historical data in data warehouse
• Develop and deploy SSIS packages to do ETL jobs and schedule the packages in SQL Server Agent
• Create, maintain and analyze ad-hoc and dynamic dashboards on Tableau and deliver Tableau site to fields
• Automate all the processes and design monitoring and ticketing process
• Work with internal and external teams to create documents and templates, and develop solutions to complex business and systems problems
• Create, prioritize and manage the projects on Rally based on Agile method

信用行为

  • 接单
    0
  • 评价
    0
  • 收藏
    0
微信扫码,建群沟通

发布任务

企业点击发布任务,工程师会在任务下报名,招聘专员也会在1小时内与您联系,1小时内精准确定人才

微信接收人才推送

关注猿急送微信平台,接收实时人才推送

接收人才推送
联系聘用方端客服
联系聘用方端客服