Sr Data Architect

About the Role

Key Responsibilities

• Responsible for designing, building, and managing the organization's data infrastructure.
• Create the blueprint for how data is collected, stored, processed, and used, ensuring it's accessible, reliable, and secure.
• Design the structure and systems that allow the organization to effectively manage and use its data, ensuring it's a valuable asset for decision-making and business operations.
• Create and maintain documentation for database architecture, procedures, and standards.
• Develop and implement a comprehensive data strategy aligned with business goals.
• Design conceptual, logical, and physical data models that represent the structure and relationships of data within the organization.
• Create and maintain the overall data architecture framework, including databases, data warehouses, data lakes, and other data systems.
• Design and implement processes for integrating data from various sources, ensuring data consistency and accuracy.
• Establish data governance policies and procedures to ensure data quality, security, and compliance.
• Evaluate and recommend data management technologies and tools to support the organization's data needs.
• Work closely with stakeholders, including business analysts, data scientists, and IT professionals, to understand data requirements and translate them into technical solutions.

Requirements

• Degree or equivalent and typically requires 7+ years of relevant experience.
• Bachelor's Degree in Computer Science, Information Systems, Engineering, or equivalent experience.
• Minimum 10 years of experience in database engineering/management.
• Knowledge of software development methodologies (e.g., Agile, Waterfall, SDLC, CI/CD).
• 7+ years' experience working with data sources and databases such as Oracle, PostgreSQL, SQL Server, and cloud databases.
• Strong knowledge of industry best practices - code coverage.
• Strong knowledge of database concepts, data modeling techniques, system performance analysis and tuning, and data warehousing concepts.
• Knowledge of various operating systems such as Linux, Unix, and Windows.
• Ability to write complex queries and perform advanced database operations using SQL.

Nice to Have

• Knowledge of cloud technologies like Azure (Data Factory, Data Bricks), AWS.
• Expertise in modern cloud-native database solutions.
• Experience with database migration tools and strategies, including handling zero-downtime migrations and data synchronization.
• Proficiency in infrastructure-as-code and automation tools (Terraform) for database deployment and management.
• Ability to design scalable database architectures that support microservices and distributed systems.
• Experience with various database patterns (CQRS, event sourcing, sharding strategies).
• Understanding of data modeling for both relational and NoSQL databases.

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, Engineering, or equivalent experience.
• Typically requires 7+ years of relevant experience in data management or related fields.

Benefits & Perks

• Competitive compensation package based on performance, experience, skills, and market factors.
• Potential for annual bonus or long-term incentive opportunities.
• Additional benefits as detailed in McKesson's benefits offerings.