Description

Design and manage complex data architectures to support decision support systems and business intelligence applications.

Responsibilities

• Design logical and physical data models using relational, 3NF, canonical, Data Vault, and dimensional techniques.
• Build data warehouse and mart structures, including star/snowflake schemas and slowly changing dimensions.
• Develop data security, access strategies, and governance frameworks.
• Lead strategic roadmap creation and stakeholder collaboration to align architecture with business needs.
• Manage data lifecycles across OLTP and DSS environments using Agile methodologies.

Required Skills

• 5+ years of experience in data architecture and modeling.
• Expertise in Oracle SQL and PL/SQL development.
• Hands-on experience with Data Vault 2.0 and Entity-Relationship diagrams.
• Proficiency in traditional and columnar database design.
• Experience with AWS Big Data and Analytics environments.
• Strong knowledge of Agile frameworks including Scrum, Kanban, RAD, and FDD.
• Proven ability in project management and master data/metadata management.
• Effective verbal and written communication for stakeholder engagement.

Preferred Skills

• Experience with Extreme Programming (XP) methodologies.

Key Skills

Education

Any Graduate