It's fun to work in a company where people truly BELIEVE in what they're doing!
We're committed to bringing passion and customer focus to the business.
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.
Role and Responsibilities
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 and Education Requirements
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
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
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.
What We Do
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.
What It's Like to Work at LucyRx
At LucyRx, we're a fast-moving team dedicated to making healthcare simpler, fairer, and more effective. Joining us means being part of a dynamic, mission-driven group that works collaboratively to challenge outdated industry practices and redefine what's possible in pharmacy benefits. We value accountability, innovation, and a relentless focus on making an impact. Here, you'll find a supportive culture that encourages you to bring your whole self to work, share bold ideas, and grow alongside smart, driven colleagues who are passionate about fixing the PBM industry. If you're ready to roll up your sleeves and make a real difference, we'd love to have you on our team.