Description

You will design and implement data architectures for OLTP and OLAP systems.

This role is on-site.

Responsibilities

• Conduct requirement sessions with stakeholders to define data warehouse needs.
• Develop conceptual, logical, and physical database models for OLTP systems and Azure Synapse.
• Design Kafka architectures for live event processing and document storage in MongoDB.
• Create OLAP and dimensional models using ER Studio.
• Maintain data governance standards for mapping, lineage, and quality using Collibra, Alation, and Ataccama.

Required Skills

• 9+ years of experience in data architecture.
• Expertise in modeling with ER Studio.
• Proficiency with Azure Synapse and SQL Server.
• Hands-on experience with MongoDB and Kafka.
• Experience with AWS environments.
• Ability to perform forward engineering to create Physical Data Models with DDL.
• Bachelor's degree in Computer Science.

Preferred Skills

• Experience collaborating with DBAs, Business Analysts, and developers within an Agile environment.

Key Skills

Education

Bachelor's degree in Computer Science