
Data Engineer
Bristol Myers SquibbResponsibilities
- Design and maintain ETL/ELT pipelines for structured, semi-structured, and unstructured data in cloud lakehouses and data warehouses.
- Develop scalable batch workflows and low-latency real-time streaming ingestion pipelines.
- Implement dimensional modeling, Slowly Changing Dimensions, and efficient lakehouse schemas.
- Build reusable Databricks frameworks and pipelines using Notebooks, Delta Live Tables, and Databricks Asset Bundles.
- Configure and tune Databricks clusters and compute pools for cost, concurrency, and performance.
- Create metric views, business semantic models, and granular access control policies.
- Build AWS-based architectures and automate infrastructure deployment using CloudFormation, custom resources, and GitHub Workflows.
- Implement secure cloud networking and develop integration utilities with AWS CLI and Boto3.
- Optimize storage layout, partitioning, and query execution across Redshift, Athena, and Delta Lake.
- Establish automated data validation, schema enforcement, and data quality testing.
- Own data engineering initiatives from technical design through production delivery and collaborate with architects, analysts, and cross-functional teams.
Requirements
- 3–6+ years of hands-on experience designing, implementing, and operating cloud-based data platforms.
- Expert-level SQL proficiency, including query optimization, complex transformations, and analytical data modeling.
- Strong experience with relational databases, NoSQL stores, Slowly Changing Dimensions, high-volume data, real-time streaming, and unstructured data ingestion.
- Hands-on Databricks experience with Notebooks, Delta Live Tables, Databricks Asset Bundles, cluster configuration, performance tuning, and access control.
- In-depth knowledge of AWS services including S3, Lambda, EC2, Glue, Crawlers, Redshift, Athena, SQS, SNS, and Step Functions.
- Hands-on experience with CloudFormation, custom resources, VPC and subnet networking, and IAM security.
- Advanced scripting experience with Python, Boto3, AWS CLI, and automated GitHub workflows.
- Strong problem-solving, collaboration, communication, process improvement, and complex solution delivery skills.
- BMS states that it hires for skills and capabilities rather than credentials and encourages applicants who do not perfectly match the resume criteria.
Benefits
- Purpose-driven work supporting the discovery, development, and delivery of medicines that address serious diseases.
- Opportunities for growth in a supportive, inclusive environment with wellbeing and comprehensive benefits.
- Work model is assigned as site-essential, site-by-design, field-based, or remote-by-design based on the role’s responsibilities; the specific model is not stated.
- Reasonable workplace accommodations and ongoing support are available for applicants and employees with disabilities.
About Bristol Myers Squibb
At Bristol Myers Squibb, we work every day to transform patients’ lives through science. That work inspires some of the most interesting, meaningful, and life-changing careers you’ll experience. Join us and pursue innovative ideas alongside some of the brightest minds in biopharma, collaborating with a team rich in diversity of experiences, and perspectives. We have built a sustainable pipeline of potential therapies and are leveraging translational medicine and data analytics to understand how we can deliver the right medicine to the right patient, at the right time, to achieve the best outcome. Whether in a scientific, business or supporting function, a career at BMS means you’ll be inspired every day to grow and thrive through opportunities that are uncommon in scale and scope. Here, you’ll be on the cutting edge of powerful innovation in oncology, hematology, immunology, cardiovascular disease, and fibrosis, with colleagues united in the mission to help patients. Through the Bristol Myers Squibb Foundation, we also promote health equity and seek to improve health outcomes of populations disproportionately affected by serious diseases and conditions. Our mission is to give new hope to help patients prevail over serious disease – it drives everything we do. Review our Social Media Community Guidelines at: https://www.bms.com/social-media-community-guidelines.html