Jobs · Information Technology · Ohio

Database Architect

McKesson · Columbus, OH · 3 wk ago
Information Technology$104k–$173k/yrFull-time

Role Summary

This role is responsible for designing and evolving the organization’s cloud data architecture as applications are migrated and re-architected from on-premises systems to Azure. The Data Architect will define scalable and secure data solutions leveraging Azure-managed database services (PostgreSQL Flexible Server, Azure SQL) and drive best practices in data modeling, integration, automation, and interoperability (including FHIR where applicable).

Key Responsibilities

  • Data Architecture & Modeling
    • Define reference architectures and reusable patterns that enable consistent adoption across multiple application teams
    • Design and maintain conceptual, logical, and physical data models for modernized applications
    • Define standards for data structures, naming conventions, and data lifecycle management
    • Ensure alignment between application architecture and data design (transactional + domain-driven patterns)
  • Cloud Data Platform Architecture
    • Design and guide implementation of solutions using: - Azure PostgreSQL Flexible Server
    • - Azure SQL / SQL Server
    • - Supporting Azure data services (ADF, Event Hubs, etc.)
    • Establish architecture patterns for high availability, scalability, and disaster recovery
    • Provide guidance on database selection across relational and NoSQL options
  • Modernization & Migration
    • Lead data architecture for on-prem to Azure migration and re-platforming efforts
    • Define strategies for: - Data migration (including near-zero downtime approaches)
    • - Data synchronization and cutover
    • - Schema modernization and decomposition of legacy designs
  • Data Integration & Interoperability
    • Design integration patterns for batch and real-time data movement
    • Support implementation of FHIR-based data structures and interoperability patterns
    • Ensure consistency and quality across distributed data systems
  • Governance, Security & Compliance
    • Establish standards for: - Data security and access controls (AAD, RBAC)
    • - Data classification and protection
    • - Audit and compliance requirements (including healthcare considerations if FHIR is used)
    • Ensure architecture aligns with enterprise governance models
  • Collaboration & Leadership
    • Partner with application teams, DBAs, engineers, and business stakeholders to translate requirements into scalable data solutions
    • Act as a consultative architect, influencing design decisions without creating delivery bottlenecks
    • Produce and maintain architecture documentation, standards, and reference patterns

Minimum Requirements

  • Bachelor’s degree or equivalent experience
  • 4+ years of experience in data architecture, database design, or data engineering

Critical Skills

  • Strong knowledge (4+ years) of cloud-native database platforms (Azure preferred)
  • Hands-on experience (4+ years) with: - Azure PostgreSQL (Flexible Server strongly preferred)
  • - Azure SQL / SQL Server
  • Experience (4+ years) with database migration strategies, including: - Data synchronization
  • - Low/zero-downtime migration patterns
  • Proficiency (4+ years) in: - Terraform or equivalent Infrastructure-as-Code tools
  • - CI/CD pipeline integration for database deployments
  • Solid understanding of: - Data modeling (relational and NoSQL)
  • - Distributed data patterns (sharding, CQRS, event-driven architectures)
  • Experience documenting data architecture standards and procedures

PREFERRED SKILLS

  • Experience with Azure ecosystem services (ADF, Synapse, Data Lake, Cosmos DB)
  • Familiarity with FHIR and healthcare data interoperability standards
  • Experience with: - Liquibase or similar schema/versioning tools
  • - ArgoCD or GitOps deployment models
  • Exposure to domain-driven design and microservices-based data architecture

Benefits

We not only care about the wellbeing of our patients, customers and the communities we serve — we care about you. That’s why we provide our employees with a comprehensive support system for all aspects of Your Care: physical, emotional, financial and social.

Similar jobs

Database Architect

JSM Consulting Inc.New York, United States· 2 wk ago
Information Technologyapply on www2.jobdiva.com

Database Architect

CoverMyMedsColumbus, OH· 1 mo ago
Information Technology$104k–$173k/yrapply on mckesson.wd3.myworkdayjobs.com

Database Architect

JSM Consulting Inc.Albany, NY· 6 mo ago
Information Technologyapply on www2.jobdiva.com

Database Architect

TALENDICANew York, NY· 3 mo ago
Information Technologyapply on candidateportal.ceipal.com

Database Systems Architect

The Goodyear Tire & Rubber CompanyAkron, OH· 4 days ago
Engineeringapply on goodyear.wd1.myworkdayjobs.com