Data Pipeline Engineer
Position Overview
iSpecimen seeks a Data Pipeline Engineer to own our data pipeline design, implementation, and maintenance. This position will report to the Chief Information Officer and offers a great growth opportunity for a hard-working individual who has a passion for data, process, automation, and tools. This role is a critical component of our ability to deliver compelling solutions that lie at the intersection of life sciences, healthcare, and online marketplaces.
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.
Responsibilities:
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
Benefits
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.