Job Specifications
Role Overview
We are seeking an experienced Data Engineer to design, build, and maintain our data infrastructure, ensuring the accuracy, security, and quality of data flows within our pharmaceutical environment. This pivotal role involves optimizing data architecture, developing robust ETL pipelines, and collaborating with clinical and R&D teams to unlock actionable insights and maintain regulatory compliance (e.g., HIPAA).
Key Responsibilities
Data Architecture & Modeling: Design and implement scalable database and data warehousing solutions (e.g., data lakes, star schemas) to support analytics, reporting, and machine learning initiatives.
ETL Pipeline Development: Develop, optimize, and monitor robust ETL/ETL workflows to ingest data from diverse sources.
Database Management: Conduct regular performance tuning, optimize complex SQL queries, and implement backup/recovery strategies to ensure data reliability and minimize downtime.
Data Quality & Governance: Implement rigorous data validation, cleansing procedures, and quality checks at each stage of the pipeline, ensuring data integrity and adherence to industry regulations.
Standardization & Mapping: Build and maintain mappers to standardize clinical codes for drugs (ATC), diagnoses (ICD), and other healthcare-specific terminologies.
Collaboration: Work closely with Pharmacy analysts, business stakeholders, and clinical experts to translate complex data requirements into scalable technical solutions.
Automation & Monitoring: Automate data integration and transformation tasks, implement monitoring tools to proactively identify and resolve issues, and establish CI/CD pipelines for production deployment.
Required Skills & Qualifications
Education: Bachelor's or Master's degree in Computer Science, Software Engineering, Bioinformatics, or a related field.
Experience: Proven experience in data engineering, database management, and building complex data pipelines, preferably within the pharmaceutical or healthcare industry.
Technical Proficiency
Languages: Expert proficiency in SQL and strong programming skills in Python and C#.
Databases: Hands-on experience with relational SQL Server, Mongo, and data warehousing solutions (e.g., Snowflake, AWS Redshift, Azure Synapse).
Cloud Platforms: Experience with Azure.
Tools: Familiarity with orchestration tools like N8N.
Domain Knowledge: Understanding of healthcare data standards and regulatory compliance requirements (HIPAA, GxP) is highly desirable.
Soft Skills
Strong analytical, problem-solving, and communication skills, with the ability to articulate complex concepts to non-technical stakeholders.
About the Company
Rivera helps payers take control of one of healthcare’s most complex systems: pharmacy benefits. As the leader in pharmacy payment integrity, we provide independent PBM oversight that brings accountability, transparency, and measurable value to every claim. Our continuous monitoring and analytics solutions uncover discrepancies, missed savings, and contract misalignments that traditional audits overlook. Our technology not only drives recoveries but also prevents issues from recurring, helping payers strengthen PBM performan...
Know more