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 ResponsibilitiesOracle / 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 RequirementsThe 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.
Salary:
$100,403-$117,660
