工作職責:
1?了解業(yè)務的基本需求,設計并構建符合汽車行業(yè)業(yè)務發(fā)展特點的數(shù)據(jù)倉庫。
2??開展業(yè)務調研,梳理業(yè)務流程系統(tǒng),有效構建專題數(shù)據(jù)分析應用,推動業(yè)務增長。
3?參與數(shù)據(jù)倉庫模型設計和ETL開發(fā),及時維護,確保數(shù)據(jù)質量。
4.深入業(yè)務單元流程,發(fā)現(xiàn)難點和應用場景,基于海量數(shù)據(jù)為業(yè)務單元提供更好的服務。
5.?整理公司數(shù)據(jù)資產(chǎn),優(yōu)化數(shù)據(jù)服務,挖掘業(yè)務場景的應用價值??偨Y和沉淀數(shù)據(jù)倉庫構建的方法,并通過支持工具和流程支持每個業(yè)務團隊開發(fā)BI報告
職位要求
1.?在企業(yè)級數(shù)據(jù)模型(錨模型、數(shù)據(jù)庫、星型模型)、數(shù)據(jù)流、主數(shù)據(jù)管理和元數(shù)據(jù)管理設計與實現(xiàn)方面有至少7年經(jīng)驗。
2.?扎實的SQL?Server和ETL開發(fā)經(jīng)驗(SSIS,?ADF),?ETL/ELT開發(fā)和維護能力:Informatica,?SSIS,?Kettle,?Talend作為DW自動化功能。
3.有微軟Azure?Cloud經(jīng)驗,使用PaaS?SQL數(shù)據(jù)倉庫等,了解集群PK、索引、分區(qū)等基本知識。
4.?5年以上Tableau、Power?BI、Qlik?Sense等企業(yè)級數(shù)據(jù)可視化分析實施經(jīng)驗;
5.?熟悉Linux命令和腳本,熟悉開源軟件,如PostgreSQL?DB和Apache氣流。
6.?有Java、c#或Python編程經(jīng)驗者優(yōu)先。
Job?Responsibilities:
1.?Understand?the?essential?needs?of?the?business,?design?and?build?a?data?warehouse?that?meets?the?development?characteristics?of?the?Automobile?industry?business.
2.?Carry?out?business?research,?sort?out?business?process?systems,?effectively?build?thematic?data?analytics?applications,?and?drive?business?growth.
3.?Participate?in?data?warehouse?model?design?and?ETL?development,?and?timely?maintenance?to?ensure?data?quality.
4.?In-depth?of?business?unit?process,?discover?pain?points?and?application?scenarios,?and?provide?better?services?to?business?unit?based?on?massive?data.
5.?Sort?out?the?company's?data?assets,?optimize?data?services,?and?tap?the?application?value?of?business?scenarios.
6.?Summarize?and?precipitate?the?methodology?of?data?warehouse?construction,?and?support?each?business?team?to?develop?BI?reports?through?the?support?of?tools?and?processes
?
Expectations:
1.?With?at?least?7+?years?of?essential?knowledge?and?experiences?in?enterprise?level?Data?model?(e.g.?Anchor?Modeling,?Data?Vault,?Star?Schema),?data?flow,?master?data?management?and?meta?data?management?design?&?implementation.
2.?Solid?experience?on?SQL?Server?Data?Model?and?ETL?development(SSIS,?ADF),?5+?years?of?Expert?knowledge?of?data?profiles?and?data?quality?analysis,?ETL/ELT?development?and?maintenance?ability:?Informatica,?SSIS,?Kettle?and?Talend?as?DW?automation?function.
3.?Experience?with?Microsoft?Azure?Cloud?with?PaaS?SQL?Data?Warehouse?and?managed?instance?as?the?backend?DB?for?Data?Warehouse,?understand?basic?knowledge?like?clustered?PK,?index,?partitions.
4.?5+?years?of?Enterprise?level?Data?visualization?&?analytics?Implementation?experiences?like?Tableau,?Power?BI?and?Qlik?Sense;
5.?Familiar?with?Linux?command?and?scripts,?experience?with?open?source?software?such?as?PostgreSQL?DB?and?Apache?Airflow.
6.?Experience?with?programming?language?such?as?Java,?C#?or?Python?is?a?plus.