Azure Data Architect

Job Title :-Data Architect
Location:-Open For 100% Remote
Duration :- 6+ Months Contract to Hire
US Citizen / Green Card holder Only
W2 Only
Pay Rate Range : $60-68 /hr(W2 Only)

-Focus on P&C industry experience, hands on development (SQL Python)
-Strong experience in data architecture, data modeling, database design across transactional and analytical systems

Position Overview/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.
• The Azure Data Architect ensures that data assets are well designed, secure, interoperable, and aligned with business and technology strategy.
• Working closely with business stakeholders, solution architects, data engineering teams, and platform owners, this role translates complex business requirements into technical components, evaluates and recommends architectural patterns; and guides the adoption of modern data technologies and standards.
• This role is responsible for researching and experimenting with emerging data platforms, defining data integration and governance frameworks, ensuring data quality and consistency, and supporting both legacy systems and modern cloud ecosystems.
• Success requires strong end to end architectural thinking, the ability to analyze and design scalable solutions under evolving constraints, influence across cross functional teams, and clearly communicate complex architectural concepts to both technical and non technical audiences.

• At an intermediate level, delivers the following items:
• Erwin data models – Conceptual, Logical and Physical.
• Technical Approach and Design Documentation.
• Data Context and Flow Diagrams.
• Data Engineering Pipelines.
• Data mapping logic, rules and transformation logic, and business rules.
• Data Migration and Integrations.

• 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.

• Experience with Power BI semantic models, Microsoft Fabric, or Purview / metadata tools.
• Familiarity with Delta Lake, Parquet, Spark/PySpark, and lakehouse architectures.
• CI/CD experience using Azure DevOps.
• Knowledge of event streaming, API integrations, or data quality automation frameworks.
• Experience:
• Degree in business management, computer science, computer engineering, electrical engineering, system analysis or a related field of study
• 6-8 years of overall Information systems, services / consulting experience of which the recent 5 years in data architecture and data related fields.

#LI-NS1
#INDPRO