Enterprise Data Architect
LucyRx•Bethesda, OH
•Remote
About The Position
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.
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
Nice To Haves
- 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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
