Country:

Malaysia

Cities:

Kuala Lumpur

Area of expertise:

Analytics

Job Description

Responsibilities:

  • Work with the data functional team, key business representatives, application designers and solution architect to understand data landscape, data sources, and end requirements.
  • Create conceptual, logical and physical data models for the to be reporting and analytics solution.
  • Create entity-relationship diagrams for relational systems and dimensional diagrams.
  • Create data models using Data Vault and/or Star-Schema modelling techniques
  • Work with the technical architect and data engineering team to understand database constraints and implementation considerations.
  • Help define and create required metadata.
  • Maintain data models continuously as modifications and enhancements are made.
  • Analyze and recommend aggregations and other measures to improve performance.
  • Support detailed data mapping. 

Qualifications:

  • At least 5+ years’ experience in data modelling
  • Experience in at least four data / analytics project implementations in large (>10000 employees) enterprises.
  • High proficiency in logical data modelling - 3NF, dimensional.
  • High proficiency in physical data modelling for relational databases.
  • High proficiency in data vault and/or star-schema modelling techniques.
  • High proficiency in SQL and cloud data warehouses (ie. Snowflake)
  • Proficiency in a dedicated data modelling tool (ie. Idera, Erwin)
  • Proficiency in big data concept.
  • Undergraduate degree.

Professional Skills:

  • Eagerness to contribute in a team-oriented environment
  • Ability to work creatively and analytically in a problem-solving environment
  • Desire to work in an information systems environment
  • Excellent leadership, communication (written and oral) and interpersonal skills

What we offer you
 
Come for the distinctive experiences you have helping forward-thinking corporations, non-profits, and governments push the boundaries of digital innovation. Stay for the limitless learning opportunities that encourage you to master Microsoft and pursue big ideas. Enjoy ambitious growth for yourself as part of Avanade’s people-first culture with benefits like employee share purchasing, flexible work arrangements, a commitment to diversity and inclusion, and competitive pay.


Apply now

Share this job:

Share Facebook Twitter

About Avanade

Avanade is the leading provider of innovative digital, cloud and advisory services, industry solutions and design-led experiences across the Microsoft ecosystem. Every day, our 56,000 professionals in 26 countries make a genuine human impact for our clients, their employees and their customers. 


We have been recognized as Microsoft’s Global SI Partner of the Year more than any other company. With the most Microsoft certifications (60,000+) and 18 (out of 18) Gold-level Microsoft competencies, we are uniquely positioned to help businesses grow and solve their toughest challenges.


We are a people first company, committed to providing an inclusive workplace where employees feel comfortable being their authentic selves. As a responsible business, we are building a sustainable world and helping young people from underrepresented communities fulfil their potential. 


Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com