Data Engineer
LucyRx•Bethesda, OH
•$100,403 - $117,660•Remote
About The Position
LucyRx is seeking a Data Engineer to join their growing data team as they 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 their 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.
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
Nice To Haves
- 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 SQLLoader, 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
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
- 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
Benefits
- Salary: $100,403-$117,660
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
Mid Level
