Azure Data Architect

Title: Azure Data Architect(Contract)- Job#6058

Location: Worcester, MA

Job Description

Our client located in Worcester, MA has an immediate need for an Azure Data Architect to join their team. The Azure Data Architect will assist 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.

Responsibilities

• Work closely with business stakeholders, solution architects, data engineering teams, and platformowners.
• Translate complex business requirements into technical components, evaluates and recommends architectural patterns; and guides the adoption of modern data technologies and standards.
• 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.
• 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.
• Author and maintain source?to?target mappings, transformation logic, business rules, and data integration documentation.
• Partner with business and product owners to define KPIs, metric logic, and shared metric catalogs; ensure consistent interpretation and use across analytics and reporting.
• 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.
• Define data validation rules and test scenarios; support QA, UAT, and production readiness activities.
• Participate in data governance processes, including metadata management, lineage documentation, certified datasets, and reduction of redundant data assets.
• 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

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

Preferred

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

About Delphi-US: Peacemakers in the Talent War

Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation’s best and brightest Technical & Professional Talent and position our nation’s finest employers to further their competitive advantages. Delphi's core technical focus includes Data Sciences & Analytics, Modern AI/ML Model Monetization, Cloud Engineering, Cyber Security, ERP Rescue; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client’s specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results.