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.