Data Pipeline Engineer

Position Overview

Company Overview

Headquartered in Lexington, MA, iSpecimen is a public company (Nasdaq: ISPC) that has developed and operates the iSpecimen Marketplace, an online platform connecting healthcare organizations that have access to patients, specimens, and data with the researchers who need them. iSpecimen was recently acknowledged by Fast Company as one of 2023’s most innovative companies. Learn more here:


Data Pipelines

  • Own the design, implementation, configuration, and maintenance of our scalable external and internal clinical data and business intelligence data pipelines
  • Design, implement, and maintain the necessary mapping, transformations, and quality checks to support our clinical data normalization and harmonization and business intelligence dimensional modelling and reporting needs
  • Architect data pipeline solutions to enable monitoring of performance and variance
  • Document standard operating procedures for the configuration and operation of our data pipeline tools
  • Provide domain expertise including continuing to learn about and evangelize for best practices in data pipelines and evaluating tools for ability to contribute to business value
  • Develop data quality checking engine that can proactively identify data quality problems that occur during data ingestion and transactional data processing

Integration Projects

  • Work as part of our Supplier onboarding team to understand the unique characteristics of each project and designing, implementing, and support each data pipeline solution
  • Become an expert in the configuration of our solutions to support each project’s needs

Software Development Process and Support

  • Work with both internal and external teams to ensure high quality delivery and operations
    Collaborate with product, engineering, quality assurance, and data teams to identify critical test scenarios
  • Act as a data advocate within the Scrum team to raise the bar on process and deliverables
  • Actively participate in product grooming sessions including estimating testing effort
  • Analyze business processes and understand software engineering and devops approaches
  • Participate in managing the product support process including working with users to make sure issues and resolutions are understood
  • Deep understanding of the need to properly secure data and manage data integrity

Education, Work Experience, and Attributes

  • Minimum five years of experience designing, implementing, and maintaining data pipelines
  • Expertise in healthcare data
  • Experience with SQL and data modelling
  • Experience with cloud data warehouse (e.g. Snowflake) and ETL / ELT tools (e.g. Matillion, Fivetran)
  • Experience working on an agile Scrum team
  • Experience with source code control (e.g. git, bitbucket)
  • Knowledge of relevant data privacy and security regulations including HIPAA
  • Experience with Data Governance a plus
  • Experience with business intelligence, analytics, and reporting tools a plus
  • Bachelor’s degree or higher in Computer Science, Engineering, or equivalent
  • Interest in and passion for creating innovative products
  • Positive, can-do attitude
  • Excellent verbal and written communication skills


iSpecimen offers a generous suite of comprehensive benefits. These include, but are not limited to, 10 paid holidays per year; discretionary (unlimited) paid time off for vacation, sick, or personal use; health insurance and health savings accounts; stock incentive plan; and a 401(K) retirement plan.

iSpecimen is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, alienage or national origin, ancestry, citizenship status, age, pregnancy, disability, sex, marital status, veteran status, sexual orientation, genetic information, arrest record, gender identity, or any other characteristic protected by applicable federal, state or local laws.