Advisory-Information Technology Risk and Assurance-Senior Consultant (Data Warehouse and Data Mining)(职位编号：GUA00083)
安永华明会计师事务所
- 公司规模：500-1000人
- 公司性质：合资(欧美)
- 公司行业：会计/审计 金融/投资/证券
职位信息
- 发布日期：2012-08-17
- 工作地点：广州
- 招聘人数：若干
- 学历要求：本科
- 语言要求：英语熟练
普通话熟练 - 职位类别：财务分析员 专业顾问
职位描述
Within Ernst & Young's Information Technology Risk and Assurance (ITRA) practice, the database / data warehouse senior consultants assess, review, and design multi-terabyte financial and operational databases that integrate our client's data for analytics, mining, monitoring, and reporting purposes. These databases typically house a hundred million individuals and billions of transactions. The successful candidate will be immersed in the development of database / data warehouse solutions to meet client business objectives.
Responsibilities:
Work directly with project teammates throughout Ernst & Young's ITRA Greater China offices on data management and data risk solutions.
Be the go-to person and mentor more junior resources.
Design, develop, and maintain complex SQL queries for data analysis, extract, and mining.
Design, develop, and assess ETL scripts and data mart extraction processes.
Write user and technical documentation and management reporting.
Assist supervisors with go-to-market strategy and proposals.
Interact with clients from multiple industries and sectors to discuss product requirements for large scale data centric applications.
Develop or assess Database Applications using the latest techniques in ETL, Data Warehousing, and Data Mining using Microsoft SQL server 2008 based tools.
Independently perform project duties, as well as work jointly with other members of the project team.
Develop high quality applications following standard software lifecycle development process Position Requirements Formal Education.
Requirements:
A Bachelor's degree in Computer Science / Mathematics /Statistics / Engineering with at least 3 years' of practical experience in creating large scale data warehouses using SQL server in the areas of data modeling, schema design, script development, data warehousing design, query optimization in a consulting firm.
Experience in SQL database programming on top of Microsoft SQL server, including T-SQL script development - Java/J2EE or C#/.Net programming.
Experience with Microsoft SQL Server, Oracle, or other major RDBMS
Familiarity with at least one leading ETL tool, such as Informatica, Oracle Warehouse Builder or SQL Server SSIS
Familiarity with Data Mining tools such as SaS, SPSS, Tabluea, and Hyperion a plus
Knowledge of software engineering and development methodologies, techniques, and tools, including Configuration Management (CVS), Issue Tracking (TeamTrack; Jira), and the Software Development Lifecycle (waterfall; agile).
Familiar with designing and implementing large databases and data warehouses utilizing both relational and dimensional design concepts
Familiar with BI tool, such as Cognos, Business Objects or Microstrategy.
Experience in Customer Data Integration (CDI) is desirable.
Ability to conduct research into database issues, standards, and products as required.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Self-motivated and attention to details and ability to work with different parties across the company.
Strong interpersonal, communication, customer service orientation and project management skills.
Excellent command of written and spoken English and Chinese.
Responsibilities:
Work directly with project teammates throughout Ernst & Young's ITRA Greater China offices on data management and data risk solutions.
Be the go-to person and mentor more junior resources.
Design, develop, and maintain complex SQL queries for data analysis, extract, and mining.
Design, develop, and assess ETL scripts and data mart extraction processes.
Write user and technical documentation and management reporting.
Assist supervisors with go-to-market strategy and proposals.
Interact with clients from multiple industries and sectors to discuss product requirements for large scale data centric applications.
Develop or assess Database Applications using the latest techniques in ETL, Data Warehousing, and Data Mining using Microsoft SQL server 2008 based tools.
Independently perform project duties, as well as work jointly with other members of the project team.
Develop high quality applications following standard software lifecycle development process Position Requirements Formal Education.
Requirements:
A Bachelor's degree in Computer Science / Mathematics /Statistics / Engineering with at least 3 years' of practical experience in creating large scale data warehouses using SQL server in the areas of data modeling, schema design, script development, data warehousing design, query optimization in a consulting firm.
Experience in SQL database programming on top of Microsoft SQL server, including T-SQL script development - Java/J2EE or C#/.Net programming.
Experience with Microsoft SQL Server, Oracle, or other major RDBMS
Familiarity with at least one leading ETL tool, such as Informatica, Oracle Warehouse Builder or SQL Server SSIS
Familiarity with Data Mining tools such as SaS, SPSS, Tabluea, and Hyperion a plus
Knowledge of software engineering and development methodologies, techniques, and tools, including Configuration Management (CVS), Issue Tracking (TeamTrack; Jira), and the Software Development Lifecycle (waterfall; agile).
Familiar with designing and implementing large databases and data warehouses utilizing both relational and dimensional design concepts
Familiar with BI tool, such as Cognos, Business Objects or Microstrategy.
Experience in Customer Data Integration (CDI) is desirable.
Ability to conduct research into database issues, standards, and products as required.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Self-motivated and attention to details and ability to work with different parties across the company.
Strong interpersonal, communication, customer service orientation and project management skills.
Excellent command of written and spoken English and Chinese.
公司介绍
Ernst & Young is one of the leading global professional services firms in the world. With more than 130,000 staff around the world, we at Ernst & Young are proud of what truly sets us apart in the profession - Our People First culture. Ernst & Young helps you achieve your best by providing great learning and career growth opportunities, by offering ways to help you achieve satisfaction at work and in life, and by looking at each decision with a keen eye towards how it will affect you.
To cope with our expansions in the PRC, we are eager to invite enthusiastic team members to join us.
安永是一家国际性的专业服务机构，全球拥有超过 130,000 名员工。为配合业务发展，诚聘专业人才。
Please forward full resume in English with a cover letter, photocopy of academic certificates, job references, current and expected salary and a recent photo by mail to or by fax to or by email to us.
请将简历寄至本公司。
To cope with our expansions in the PRC, we are eager to invite enthusiastic team members to join us.
安永是一家国际性的专业服务机构，全球拥有超过 130,000 名员工。为配合业务发展，诚聘专业人才。
Please forward full resume in English with a cover letter, photocopy of academic certificates, job references, current and expected salary and a recent photo by mail to or by fax to or by email to us.
请将简历寄至本公司。