Avanade Hiring! Full Time Data Modeler in Federal Territory - Ricebowl

Summary

We are seeking a talented Data Modeler to join our dynamic team. You will be responsible for data modelling, translating business reporting needs and source-system logic into a structured UDM design covering conceptual, logical, and physical data models to be used as the base guideline by the development team.

Beyond data modelling, you would also support and lead the development work by guiding implementation patterns, doing and reviewing data transformation logic, and helping the team build consistent, reusable, and reliable data assets. Together we do what matters.

Key Responsibilities

• Work with the data functional team, key business representatives, application designers and solution architect to understand data landscape, data sources, and end requirements.
• Translate business reporting needs and source-system logic into a structured UDM design
• 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.
• Lead the development work by guiding implementation patterns
• Develop and review data transformation logic, and help the team build consistent, reusable, and reliable data assets

Skill and experiences

• Minimum 5+ years’ experience in data modelling
• High proficiency in Azure Synapse Studio and SQL Server
• High proficiency in logical data modelling - 3NF, dimensional, physical data modelling for relational databases, dedicated data modelling tool (ie. Idera, Erwin)
• High proficiency in data vault and/or star-schema modelling techniques.
• High proficiency in SQL and cloud data warehouses
• Proficiency in big data concept
• Familiarity with cloud platforms (Azure)
• Strong analytical, problem-solving, and communication skills; ability to work collaboratively in cross-functional teams