上海招聘

MS BI Data Warehouse Developer
1. Knowledge Area
？ Minimum 5+ MS BI Development work experience
？ Data Warehouse Design and Implement – proficient
？ SQL Server Integrating Service (SSIS) – proficient
？ SQL Server Analysis Services (SSAS) – proficient
？ SQL Server Reporting Service (SSRS) – proficient
？ T-SQL Creation and Tuning – proficient
？ MDX – proficient
？ Data quality management– proficient
？ OLTP Data Modeling – proficient
？ Ad-hoc Reporting – proficient
？ Indexing Mechanism– basic
？ Data Mining – basic
？ Sharepoint BI, PowerPivot, PowerView, PivotTable, PPS – basic
？ Big Data, Columnar Databases, Mobile BI – Familiar
？ C/C++/C#, .Net Framework – Familiar

2. BI Architect Methodology
？ Star Schema and Snowflake Schema Design – deep understanding
？ MS BI Project Systems Development Life Cycle(SDLC) – deep understanding
？ Agile Mechanism – deep understanding

3. Tools Area
？ SQL Server Business Intelligence Development Studio(BIDS)/SQL Server Data Tool(SSDT) – proficient
？ Microsoft Visual Studio – proficient
？ Microsoft TFS/VSS/SVN – proficient
？ Microsoft Visio – basic

4. Team Work Area
？ Working experience in more than 20 team members – more than 5 years
？ Development Environment and Permission – deep understanding
？ Cooperation among PM Team, Developer Team and Test Team – deep understanding
？ Source code cross review, check in, check out, conflict resolve – deep understanding
？ Release Control, Version Management – deep understanding
？ Bug Management – deep understanding
？ Source code mainline and branch management – deep understanding

5. Language Area
？ English– proficient
？ Mandarin– proficient

6. Other Area
？ Bachelor degree or above and major in Computer Science, Engineering, or related discipline
？ Technical documentation skills, including Functional spec, technical spec, technical standards and best practice etc. – Excellent
？ Ability of communicating with business and IT stakeholders – Excellent
？ Ability of translating business into technology, vice versa – Excellent
？ Ability of Troubleshooting and Problem Solving – Excellent
？ Ability of Innovation – Excellent
？ Ability of managing multiple projects and tasks simultaneously – Excellent
？ Financial business knowledge – Familiar

埃森哲（中国）有限公司诚聘