Avanade Inc. Consultant, Data Engineering in Singapore, Singapore

Role Overview:

As a Data Engineering Consultant, you will design and implement projects focused on collecting, aggregating, storing, reconciling, and making data accessible from disparate sources to enable analysis and decision making. This role will also play a critical part of the data supply chain by ensuring that stakeholders can access and manipulate data for routine and ad hoc analysis. Additionally, you will support the full lifecycle of data from ingesting through analytics to action.

Key Role Responsibilities:

Day-to-day you will:

  • Contribute to the planning and delivery of data warehouse and storage architecture.

  • Contribute to the planning and implementation of data design services, providing sizing and configuration assistance, and performing needs assessments.

  • Analyze current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities.

  • Design, develop, customize, and maintain data warehouse schematics, layouts, architectures, and relational databases for data storage and data mining

  • Deliver data to end users using SSRS, Excel, PowerPivot and SharePoint Performance Point

  • Customize data storage and extraction, data mining, database architecture, metadata and repository creation.

  • Create and implement effective metrics and monitoring processes.

  • Participate in the design and development of business intelligence reporting tools.

  • Work with deal teams to provide subject matter expertise and solutioning support for client proposals and RFPs

  • Produce actionable reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems.

  • Program and maintain report forms and formats, information dashboards, data generators, canned reports, and other end-user information portals or resources.

  • Communication skill

  • Understand questions posed

  • Technical expertise – this includes SSIS/SSRS/SSAS, Power BI, Data Warehousing using SQL Server

  • Ability to multitask

  • Ability to lead and handle an offshore team

Key Role Skill & Capability Requirements:


  • Demonstrable experience working with database, storage, collection and aggregation models, techniques and technologies, with the ability to apply such methods to solve business problems.

  • Experience working with statistical and data visualization tools and techniques

  • Experience in structured problem solving assignments and strong project management and people management skills

  • Experience working with SharePoint, PowerPivot, Excel skills (with embedded Pivot Tables & Macros)

  • Power BI (SSAS, SSIS, SSRS) & SQL Skills is a must


Preferred Education Background:

You likely possess a Bachelor's degree in Applied Mathematics, Statistics, or another relevant field. An equivalent combination of education and experience will also suffice.

Preferred Years of Work Experience:

You likely have about 3-5+ years of relevant professional experience.

Scope of Work:

Nature of Work: Executes project/program plans and processes in alignment with established operational objectives.

Scope of Work: Primarily focused on own work, and execution of prescribed work plans.

Complexity: Complex problems primarily within one's occupation / discipline that require personal judgement of contextual factors.

Discretion: Wide latitude in approach to work within established work plans.

Organizational Impact: Work efforts have an immediate impact on Avanade and/or client operations.

Supervision Received: Works under general guidance and direction, but fully independent in own work with latitude for autonomous decision-making related to work process.

Supervision Provided: Supports more junior colleagues on work efforts, with some checking of work.

Knowledge Applied: Applies advanced knowledge of a learned occupation / discipline.

Accountabilities & Metrics:

  • Chargeability target

  • Personal goals

Relevant Additional Details:

This field is reserved for any additional details that may not be globally relevant and consistently vary on a position-by-position basis.

Requisition ID - 52543

Avanade is the leading provider of innovative digital and cloud-enabling services, business solutions and design-led experiences, delivered through the power of people and the Microsoft ecosystem. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation and has 30,000 professionals in 24 countries. Visit us at www.avanade.com.

Category: Analytics

Avanade® Is An Equal Opportunity Employer. Avanade prohibits discrimination and harassment against any employee or applicant for employment because of race, color, age, religion, sex, national origin, gender identity or expression, sexual orientation, disability, veteran, military or marital status, genetic information or any other protected status.

The EEO is the Law poster is available here:


and here:


The Pay Transparency Policy is available here:


Avanade is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation due to a disability for any part of the employment process, please send an e-mail to Avanade at careers@avanade.com or call (206) 239-5610 and let us know the nature of your request and your contact information.

By using this site, you agree that we can place Cookies on your device. See our Job Applicant Data Privacy Statement and Cookies statement.