Data Architect

\nConduct 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. \nDevelop 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. \nCreate 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. \nUse forward engineering to create a Physical Data Model with DDL that best suits the requirements from Logical Data Model. \nReview the Models and conduct the Peer review to maintain the Data models. \nWork with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models. \nIdentify, formulate and document detailed business rules and Use Cases based on requirements analysis. \nCreate data models for databases (MongoDB,Azure Synapse, SQL Server, Kafka) using ER Studio. \nMaintain data governance standards using tools like Collibra, Alation and Ataccama for data mapping, data lineage and data quality. \nWork closely with the team within Agile methodology. \n

Labor Condition Application (ETA Form 9035 & 9035E) filed with the United States Department of Labor, Office of Foreign Labor Certification for a H-1B non-immigrant worker with the following details:\n1. Number of H1B non-immigrant workers included in LCA: \n1(One)\n2. Job Position: \nData Architect\n3. Wages Offered: \n$131685.00 - $131686.00 per year\n4. Period of Employment: \n09/10/2024 to 09/09/2027\n5. Locations where H1B non-immigrant worker will work:\n1)382 Boston Tpke Suite 201, Shrewsbury, Massachusetts 01545\nComplaints alleging misrepresentation of material facts in the Labor Condition Application and/ or failure to comply with the terms of the Labor Condition Application may be filed with any office of the Wage & Hour Division of the United States Department of Labor.\nThe verification of Labor Condition Application (ETA Form 9035 & 9035E) will be available for all to review.\n\nhttps://us-west-2.graphassets.com/AhL7j39r8QqrJYMwlDWAYz/uxNohAtSAmJ1Mdox6FCo\n