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

Data Engineer

Remote startup roles in your inbox