Data Architect

Job Responsibilities
Conduct one-on-one sessions with business users to gather data warehouse requirements. Analyze database requirements in detail with the project stakeholders by conducting Joint Requirement Development sessions. 
Develop a Conceptual model based on requirements analysis Develop normalized Logical and Physical database models to design OLTP systems for business applications that supports Azure Synapse. 
Create architecture/model for Kafka to process live events and store the documents in MongoDB. Create OLAP/dimensional models for the reporting system by identifying required dimensions and facts using ER Studio. 
Use forward engineering to create a Physical Data Model with DDL that best suits the requirements from Logical Data Model. 
Review the Models and conduct the Peer review to maintain the Data models. 
Work with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models. 
Identify, formulate and document detailed business rules and Use Cases based on requirements analysis. 
Create data models for databases (MongoDB,Azure Synapse, SQL Server, Kafka) using ER Studio. 
Maintain data governance standards using tools like Collibra, Alation and Ataccama for data mapping, data lineage and data quality. 
Work closely with the team within Agile methodology.