Beam Therapeutics · 3 weeks ago
Data Analytics and Integration Specialist
Cambridge, MA
Full-time
Hybrid
Senior Level, Lead/Staff
$100K/yr - $135K/yr
12+ years expBeam Therapeutics is a biotechnology company committed to establishing the leading platform for precision genetic medicines. They are seeking a highly energetic Data Analytics and Integration Specialist to design, build, and maintain integration solutions using the Boomi AtomSphere platform, ensuring seamless data flow between cloud and on-premise systems.
BiotechnologyGeneticsMedicalTherapeutics
Hiring Manager
Sarah Oleson
Responsibilities
ETL Development & Data Integration - Design and implement robust ETL (Extract, Transform, Load) processes to integrate data from diverse sources while ensuring data quality and Strong experience in Boomi development to create, test, and deploy integrations, including data capture, data mapping, transformations, testing and validation
AWS & Cloud Data Management - Manage and optimize AWS-based data pipelines, specifically handling data movement from S3 buckets to Leverage AWS services such as S3, IAM, Lambda, Glue, and others for seamless data processing and storage
Data Modeling and Design - Develop efficient data models and database schemas within Amazon Redshift, considering data redundancy, normalization, and performance optimization
Data Security and Governance - Implement data security measures within Redshift, ensuring compliance with data privacy regulations and access control policies
Documentation & Reporting - Develop technical documentation for data warehouse architecture, data models, ETL processes, and key performance indicators (KPIs)
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or a related field
12+ years of relevant experience
Experience with other ETL Tools
Experience with data visualization tools (e.g., Tableau, Power BI)
Familiarity with data security and privacy best practices
Boomi Integration Development: Hands-on experience developing integrations using Boomi, including data mapping, transformations, testing, and validation
SQL Proficiency: Extensive experience writing complex SQL queries for data manipulation, aggregation, and analysis within relational databases
Amazon Redshift Expertise: Strong understanding of Redshift architecture, data loading mechanisms, and query optimization techniques for managing large-scale data warehouses
AWS & Cloud Data Warehousing: Experience migrating and managing data from S3 buckets to Redshift and working with other AWS services (S3, Lambda, Glue, IAM)
Data Migration & ETL Experience: experience migrating data from SAP to LabVantage LIMS and MES to SAP and Boomi highly preferred
Onsite requirements: Candidates are expected to come onsite 2 days per week and as needed to complete job duties
Company
Beam Therapeutics
Beam Therapeutics is a biotechnology company developing precision genetic medicines through the use of base editing technology.
501-1000 employees
H1B Sponsorship
Beam Therapeutics has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (11)
2024 (9)
2023 (12)
2022 (9)
2021 (7)
2020 (4)
Funding
Current Stage
Public CompanyTotal Funding
$1.19B2025-03-10Post Ipo Equity· $500M
2021-01-19Post Ipo Equity· $260M
2020-02-11Post Ipo Equity· $207M
Leadership Team
John Evans
CEO
Christine Bellon
Chief Legal Officer
Recent News
2025-12-16
2025-12-09
Company data provided by crunchbase