Description

You will design and implement data architectures to support OLTP and OLAP systems.

Responsibilities

• Conduct requirement development sessions with stakeholders to gather data warehouse needs.
• Develop conceptual, normalized 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 by identifying dimensions and facts using ER Studio.
• Maintain data governance standards for data 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