Azure Data Architect

Job Summary

The Azure Data Architect plays a critical role in defining, governing, and evolving the enterprise data architecture that enables trusted, scalable, and high-performing data solutions across the organization. Operating within both cloud-native and legacy environments, this role provides advanced technical leadership in data architecture, data modeling, and database management to support analytics, operational systems, and strategic initiatives.

Key Responsibilities

• Accountable for data architecture delivery at the project and domain level; consults with and collaborates with business stakeholders, solution architects, and engineering teams.
• Gather, analyze, and validate business and technical data requirements; translate requirements into conceptual, logical, and physical data models with ownership and authority.
• Design and maintain enterprise data models, database schemas, and message models supporting transactional systems, ODS, data warehouses, and analytics platforms.
• Ensure data architecture and designs conform to enterprise reference architecture, data standards, naming conventions, and compliance rules.
• Define and maintain data integration architectures, patterns, and roadmaps aligned to enterprise data and integration strategy.
• Provide technical leadership for ETL and data integration design and development across Azure Data Factory, Synapse, and Informatica.
• Create and maintain curated analytics datasets and semantic models (SQL views, tables, BI models) to support dashboards and self-service reporting.
• Perform data profiling, reconciliation, and validation using SQL and Python to ensure data accuracy, completeness, and consistency across systems.
• Develop and maintain processes for capturing and managing metadata across operational, integration, and analytical platforms.
• Collaborate with application, infrastructure, and integration teams to ensure end-to-end information flow across systems and platforms.
• Lead or participate in architecture design sessions and architecture reviews; identify risks and recommend mitigation strategies.
• Provide technical coaching and mentoring to data engineers, data analysts, and junior architects; promote modeling and integration best practices.
• Support project planning, estimation, and delivery activities; contribute to technical designs and implementation approaches.
• Proactively research and apply modern data architecture patterns, cloud best practices, and emerging technologies to improve scalability and performance.

Required Skills

• Property and Casualty Insurance Industry experience.
• Strong experience in data architecture, data modeling, and database design across transactional and analytical systems.
• Hands-on experience with Microsoft Azure data services (ADF, Synapse, ADLS, Azure SQL).
• Advanced SQL skills; working knowledge of Python for data validation, automation, and data processing.
• Experience designing and supporting ETL/data integration architectures, including legacy platforms such as Informatica.
• Understanding of enterprise data governance, metadata, lineage, and data quality concepts.
• Ability to translate complex business requirements into scalable, governed data solutions.
• Strong written and verbal communication skills; ability to communicate architectural concepts to both technical and business audiences.

Education Requirements

• Degree in business management, computer science, computer engineering, electrical engineering, system analysis, or a related field of study.

Required Experience

• 6–8 years of overall Information Systems, services/consulting experience, of which the recent 5 years in data architecture and data-related fields.