Data Engineer

About the role

We are seeking a Data Engineer to join LucyRx’s growing data team. This role will focus on Oracle PL/SQL development, database optimization, and migration efforts, with future responsibilities expanding to cloud data pipeline development, ELT/ETL engineering, and analytics enablement on Snowflake.

Responsibilities

• 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

Qualifications

• 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