Data Architect

Required Skills & Experience:

• 15+ years of professional experience in Data Architecture/Data Modeler .
• Bachelor’s degree in computer science, Information Systems, Data Science, or a related field.
• Experience in data modeling and database design.
• Proficiency in data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio).
• Strong understanding of relational, dimensional, and NoSQL data modeling techniques.
• Experience with SQL and at least one major RDBMS (e.g., Oracle, SQL Server, PostgreSQL, MySQL).
• Familiarity with data warehousing, ETL processes, and data lake architectures.
• Excellent analytical and communication skills.
• Expertise in Azure ecosystem (Azure Data Lake Storage, Azure Data Factory, Synapse Analytics, Event Hub, Kafka).
• Knowledge of structured streaming and real-time data processing.

Responsibilities:

• Design and maintain conceptual, logical, and physical data models to support business intelligence, analytics, and operational systems.
• Collaborate with stakeholders, data architects, and engineering teams to gather data requirements and translate them into effective models.
• Develop and enforce data modeling standards and best practices to ensure data consistency and integrity across systems.
• Conduct data profiling and analysis to understand source systems and support accurate modeling.
• Create and manage data dictionaries, entity relationship diagrams (ERDs), and metadata repositories.
• Ensure models align with enterprise architecture principles, business goals, and compliance requirements.
• Support data integration and transformation processes by providing clear documentation and data flow guidance.
• Partner with development teams and DBAs to implement models, optimize queries, and improve database performance.
• Participate in code and design reviews to ensure model quality, scalability, and maintainability.
• Assist in establishing and maintaining data governance frameworks, including data lineage, stewardship, and quality metrics