Data Engineer

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 a Data Engineer to join LucyRx’s growing data team as we transition from an Oracle-centric environment to a modern cloud-based analytics platform. In the near term, this role will focus heavily on Oracle PL/SQL development, database optimization, and supporting migration efforts from our legacy Oracle systems. Over time, the scope will expand to include cloud data pipeline development, ELT/ETL engineering, and analytics enablement on Snowflake. This is an ideal opportunity for a data engineer with strong Oracle/SQL foundations who is eager to grow into a modern cloud data stack. Role and Responsibilities Oracle / PL/SQL — Near-Term Focus Design, develop, and optimize PL/SQL stored procedures, functions, packages, triggers, and views for Oracle databases Perform query optimization, performance tuning, and database indexing to improve database efficiency Develop and maintain ETL processes supporting data integration and reporting in Oracle environments Support migration of Oracle databases to cloud platforms (Oracle Cloud, AWS RDS, or Azure SQL Database) Ensure data integrity, security, and compliance with HIPAA and company standards Troubleshoot and resolve database issues in both on-premises and cloud environments Maintain clear documentation for database processes, migration strategies, and coding standards Data Engineering / Cloud — Evolving Scope Design and build scalable data pipelines for ingestion, transformation, and integration Integrate data from Oracle, SQL Server, and external systems into Snowflake Develop and maintain ELT/ETL processes using Python, SQL, and cloud-native tools Support and extend Fivetran ingestion and identify coverage gaps Design and maintain data models in Snowflake using SQL and dbt (facts, dimensions, metrics) Support BI tools such as Tableau and Power BI with performant, well-documented datasets Implement monitoring, alerting, data testing, and validation across pipelines Contribute to data governance, semantic layer development, and architectural decisions Qualifications and Education Requirements Bachelor’s degree in Computer Science, Information Technology, or related field, or equivalent experience 5–7 years of experience in data engineering, database development, or a related role Strong Oracle PL/SQL skills — stored procedures, functions, packages, triggers, and views Advanced SQL proficiency: complex joins, transformations, query optimization Solid Python experience for scripting, automation, or pipeline development Experience with ETL/ELT pipeline design and development Familiarity with data modeling concepts (dimensional modeling preferred) Experience with cloud data platforms or cloud database environments Exposure to Oracle-to-cloud migration patterns or hybrid legacy/modern environments Strong problem-solving, communication, and documentation skills Preferences Snowflake experience (modeling, query optimization) Experience with dbt for transformation and data modeling Experience with Fivetran or similar ingestion tools Familiarity with Oracle tools such as SQL*Loader, Data Pump, Oracle SQL Developer, or APEX Experience with Oracle 12c/19c and advanced features Exposure to SSIS or other legacy ETL tooling Experience with BI tools (Tableau, Power BI) Healthcare, PBM, managed care, or other regulated industry experience Familiarity with Agile methodologies and CI/CD practices Oracle certification a plus Success Measures (First 6–12 Months) Reliable, optimized PL/SQL codebase with clear documentation Meaningful progress on Oracle-to-cloud migration initiatives Reduction in manual ingestion and data handling processes Standardized pipeline patterns and improved reliability Increased data availability in Snowflake with clear separation from operational systems Reduced discrepancies between reports and source systems Documented data models with growing adoption across reporting teams 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. 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. Salary: $100,403-$117,660 Careers At LucyRx, you won’t just have a job, you’ll have a purpose. As a luminary—a person who inspires, influences, and lights the way forward—you’ll be part of a team reimagining what’s possible in pharmacy benefits. Join a team that’s leading the charge toward a more transparent, accountable, and people-first approach to prescription benefits. If you’re ready to challenge the status quo and illuminate a better path forward, you’re in the right place.