Data Engineer

Company Description

IntegriChain is the data and application infrastructure for Life Sciences manufacturers' market access departments. We provide the data, applications, and business process infrastructure for patient access and therapy commercialization. Over 250 manufacturers depend on our ICyte Platform to manage their commercial and government payer contracts, patient services, and distribution channels. ICyte is the first and only platform that combines the financial, operational, and commercial data sets necessary to support therapy access in the era of specialty and precision medicine. With ICyte, Life Sciences innovators digitize their market access operations, freeing resources to focus on more data-driven decision-making. With ICyte, Life Sciences innovators are digitizing labor-intensive processes – freeing their best talent to identify and overcome coverage and availability barriers and to handle pricing and forecasting complexity.

Our headquarters are in Philadelphia, PA (USA), with offices in Ambler, PA (USA); Pune, India; and Medellín, Colombia. For further information, visit, or follow us on Twitter @ and.

Qualifications

• 4-6 years of experience in constructing data pipelines and using tools (Must-have).
• 2+ years of experience with ETL tools like Talend /Jaspersoft ETL tools (Must-have).
• 2+ years experience in SQL programming language (Must-have).
• Skilled in writing stored procedures and SQL queries (Must-have).
• 2+ years experience in Python programming (Must-have).
• Experience in development (Tsql/PL-sql) inclusive of concepts such as Index, Views, Trigger, recursive CTE, pivot/unpivot and creating complex Queries.
• Knowledge of any tool for scheduling and orchestration of data pipelines or workflows (preferred- Airflow) (nice to have).
• 1+ years experience developing modern, industry standard big data frameworks with AWS or other cloud services (Must-have).
• Familiarity with common GitHub developer practices and paradigms.
• Experience working with agile methodologies and cross-functional teams.
• Knowledge in building AWS data pipelines using Python, S3 data lake (nice to have).
• Familiarity with redshift or any other columnar database is preferred.
• Experience with AWS services including S3, Redshift, EMR (nice to have). Knowledge of distributed systems relating to data storage and computing. Knowledge of specialty pharmaceutical and retail pharmacy is a plus.
• Good to have understanding of the Data integration process.
• Ability to communicate effectively with both business and technical teams.

Additional Information

What does IntegriChain offer?

• Mission driven: Work to improve patients' lives!
• Excellent and affordable medical benefits plus non-medical perks including Flexible Paid Time Off.
• Wide-ranging Learning & Development opportunities including over 700+ free development courses for all employees.