Enterprise Data Architect

Role Description

We are seeking an Enterprise Data Architect to own the architecture, reliability, and modernization of LucyRx's operational (OLTP) data systems, as we mature our data platform alongside our growing Snowflake analytics environment. This role focuses on data modeling, architectural separation of concerns, and performance and reliability for our transactional systems, and partners closely with data engineering leadership on the boundary and integration strategy between operational and analytical platforms.

• Own architecture and data modeling strategy for operational (OLTP) systems
• Document architecture decisions, data models, and system data flows
• Lead separation-of-concerns initiatives to reduce cross-system risk and contain the impact of production issues
• Design canonical/master data models for core operational domains, replacing source-specific, duplicated logic
• Own performance, scalability, and reliability of relational database systems and stored procedure/data logic
• Partner with data engineering leadership on the OLTP/OLAP boundary and integration strategy as the platform evolves
• Evaluate and advise on database platform strategy and roadmap, including cloud database options and modernization of legacy procedural logic
• Establish data modeling standards and architectural best practices for operational systems
• Partner with engineering to implement proactive monitoring, alerting, and issue detection for database and pipeline health
• Mentor engineering staff on relational data modeling and performance best practices

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent experience
• 8+ years of experience in data architecture or senior database engineering roles
• Deep expertise in relational database architecture and data modeling for transactional (OLTP) systems
• Strong experience with procedural SQL development and performance tuning at scale
• Demonstrated experience implementing separation of concerns, canonical/master data modeling, or comparable architectural patterns
• Experience evaluating and advising on database platform strategy or migrations
• Strong understanding of data integrity, transactional system design, and production reliability practices

Requirements

• Experience with Oracle database architecture and PL/SQL
• Experience with cloud database platforms (e.g., Oracle Autonomous Database, AWS RDS, Azure SQL)
• Multi-database experience (e.g., SQL Server, PostgreSQL)
• Experience partnering with analytics/BI teams on OLTP-to-OLAP integration, ideally involving Snowflake
• Healthcare, PBM, or other regulated industry experience
• Experience mentoring engineers on architecture and data modeling best practices

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. This is a largely sedentary role; however, some standing, walking, bending, and reaching may be required. Regularly operates in an office setting which involves utilizing a computer, mouse, keyboard, and occasionally operates other standard office equipment such as a printer, copier, and phone. Minimal travel may be required.

Company Description

LucyRx is an independent, next-generation pharmacy benefits manager (PBM) transforming how healthcare works. We’re fixing what’s broken in the PBM industry by putting people first and challenging outdated norms. For too long, traditional PBMs have prioritized profit over patients, and we believe that’s just plain wrong. LucyRx offers bold, innovative solutions powered by LucyIQ, our proprietary AI platform, to deliver actionable insights that lower costs, improve care, and simplify prescription management. While we’re new to the PBM space, LucyRx is built on decades of leadership experience and a commitment to meaningful change. We’re a nimble, remote-first team with a bold mission to redefine pharmacy benefits—and we’re just getting started.