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.
Data Engineer
Location
United States
Posted
7 days ago
Salary
$100.4K - $117.7K / year
Seniority
Mid Level
Job Description
Data Engineer
LucyRx
Role Description 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 - 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 Requirements - 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. Salary $100,403-$117,660
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer
ReplyReply designs and implements innovative solutions in the areas: Digital Services, Technology and Consulting.
Role Description Atuação remota!! - Construir e gerenciar pipelines confiáveis de dados envolvendo ingestão/coleta, processamento, integração, armazenamento e disponibilização de dados na organização. - Atuar em uma arquitetura de sistemas distribuídos para o processamento de dados massivos em paralelo (MPP), combinando diversas fontes de dados heterogêneas e colaborando com equipes de análise e ciência de dados na construção de soluções e geração de valor baseadas em dados. Qualifications - Experiência prática com ingestão, integração, processamento e armazenamento de grandes volumes de dados. - Atuação em projetos de Big Data. - Behavior Driven Development (BDD). - Extração de dados em Python e processamento de dados com PySpark. - Experiências em ferramentas ETL's. - Conhecimento em modelagem de dados relacionais e dimensionais (Data WareHouse). - Experiência com bancos de dados SQL. - Experiência com conjunto de ferramentas relacionadas a Big Data na AWS como: EMR, Kinesis, RedShift, S3, Glue, ElasticSearch. - Conhecimento em Kafka. - Conhecimento com Data Lake e Data Ops. Requirements - Certificações AWS (desejável/diferencial). - Conhecimento em ferramentas de provisionamento de infraestrutura em cloud via código tais como: Terraform, CloudFormation (desejável/diferencial). Benefits - Cartão flexível Swile pra você usar como quiser (VA e VR). - Totalpass ou Gympass. - Apoio à Saúde Mental – Psicologia Viva. - Plano de Saúde Bradesco. - Plano Odontológico Bradesco. - Participação nos Lucros. - Auxílio-Creche para nossas mamães. - Incentivo a certificações. - Palestras e Webinars especiais. - Programa RAF de bonificação por indicações. - Seguro de Vida. - Subsídio para Inglês ou Italiano. - Desconto Open English. - Presente de aniversário. - Possibilidade de mudança do país. - Parcerias com Universidades.
Online Data Entry Specialist
Globe Life AOWork for a Fortune 500 company that rewards performance, invests in your growth, and provides a launchpad for a high-earning remote sales career. This isn’t just a job — it’s your path to leadership, income, and long-term success.
Role Description We are actively hiring and scheduling interviews this week for a fully remote Work From Home position. Immediate hiring – secure your spot and get hired. Entry level position for the applicants and full training provided. This is a legitimate opportunity with full training provided and guidance to obtain your Life & Health Insurance license. No prior experience required. We are looking for motivated U.S. residents ready to grow in a long-term remote career. - Communicate professionally with clients - Provide information and guidance - Follow a structured system - Maintain consistent performance Qualifications - Strong communication skills - Reliable internet connection - Self-motivated and coachable - Must be a U.S. resident - Willingness to obtain a Life & Health Insurance license (assistance provided) Benefits - 100% Remote - Full training program - Licensing guidance and support - Advancement opportunities - Supportive leadership team Company Description
Role Description Oxford's client, a global leader in the biopharma industry, is seeking a Data Engineer to support a growing workload within their innovation team. This role will be instrumental in building and maintaining scalable data pipelines, delivering high-quality, production-ready datasets to cross-functional teams including IT and AI. - Design, build, and maintain robust data pipelines within a Snowflake environment - Transform raw global data (including datasets from China and other international regions) into clean, structured, and production-ready outputs - Deliver polished datasets to downstream teams including IT and AI/ML teams - Collaborate closely with AI teams to support data-driven models and workflow automation initiatives - Utilize Databricks to support data processing, analytics, and pipeline orchestration - Structure and optimize data models to ensure usability, scalability, and performance - Partner with IT teams involved in data mining and analytics to ensure seamless data access and usability - Help reduce backlog by supporting and scaling existing data engineering efforts - Ensure data processes align with industry compliance standards and business requirements Qualifications - Exposure to AI/ML workflows, including automation and data pipeline integration - Experience in the biopharma, life sciences, or regulated industries - Proven experience as a Data Engineer in a complex, data-driven environment - Strong hands-on experience with Snowflake - Experience building and maintaining end-to-end data pipelines - Proficiency with Databricks and modern data engineering tools - Solid understanding of data modeling and structuring techniques - Experience working with both structured and semi-structured data - Ability to work independently as a self-starter in a fast-paced environment - Experience working with global datasets and distributed teams Preferred Qualifications - Familiarity with data compliance, governance, and regulatory requirements - Experience supporting or collaborating with AI/ML teams
Role Description Our client is looking for an AI / Data Engineer to design and deliver data platforms, pipelines and AI-enabled solutions for our clients. This is a hands-on consulting and delivery role for someone who can take ownership of ambiguous client problems, shape a practical technical approach, and deliver robust solutions across data engineering, data architecture and AI innovation. You will work with the company’s colleagues, client stakeholders and external technical teams to acquire, structure, transform and expose data through analytics, applications, APIs and AI-enabled experiences. Duties & Responsibilities - Own the delivery of client data and AI engineering work from discovery through design, implementation, testing and deployment. - Work with client stakeholders to understand business problems, clarify requirements and translate them into practical technical solutions. - Design and build data ingestion pipelines from APIs, third-party systems, files, online sources and operational platforms. - Develop scalable warehouse and transformation layers that convert raw data into trusted, reusable client data products. - Apply sound data architecture, modelling, quality, lineage and governance practices. - Identify and implement opportunities to use AI, automation, retrieval and agent-based workflows within client solutions. - Build or support APIs, data access layers and application integrations that make data products usable by reporting tools, software applications and AI experiences. - Contribute reusable technical patterns, documentation and engineering standards across the company. Qualifications - Ownership and Client Problem-Solving: You take ownership of outcomes rather than waiting for fully defined requirements. You are comfortable working through ambiguity, asking the right questions, identifying gaps and helping clients move from a business problem to a practical solution. - AI-First Mindset: You are interested in how AI can improve data collection, enrichment, research, automation, retrieval and decision support. You do not need to be an AI researcher, but you should be comfortable evaluating where LLMs, agents and AI-enabled workflows can create practical value. - Data Engineering and Warehousing Capability: You have strong hands-on experience designing and delivering modern data pipelines and warehouse solutions. You understand ingestion patterns, orchestration, data modelling, transformation layers, quality controls, observability, lineage, performance and security. - Collaborative Delivery Mindset: You work well in a consulting environment, communicate clearly with technical and non-technical stakeholders, and are comfortable sharing ideas, challenging assumptions and working closely with client and internal delivery teams. Requirements - Approximately five to ten years of relevant experience in data engineering, analytics engineering, data platform delivery or related technical consulting roles. - Practical experience with several of the following: - Modern cloud data warehouses such as Snowflake, BigQuery, Redshift, Databricks or Synapse. - SQL, data modelling and transformation frameworks such as dbt. - Cloud platforms, particularly AWS, Azure or GCP. - API integration, external data ingestion and pipeline orchestration. - Data quality, monitoring, observability and governance practices. - Software engineering practices including Git, automated testing and CI/CD. - Building data products for analytics, reporting, APIs or software applications. - Experience with AI orchestration frameworks, LLM tool calling, retrieval workflows, vector search, agent-based systems or related AI technologies. Success in This Role Success will mean delivering reliable, scalable and commercially useful data and AI solutions for the clients. You will combine sound engineering discipline with strong client problem-solving: understanding the real need, designing the right solution, delivering it effectively and helping clients derive measurable value from their data. Kindly regard your application as unsuccessful if you have not heard from the agency within 2 weeks.

