Senior Data Engineer

Role Overview

• Design, develop, and maintain robust and scalable data pipelines supporting Foundational Data Products (CoreReg, Substance Mart, DARE, and Asset Mart)
• Integrate data from diverse sources, ensuring consistency, quality, and accessibility across platforms
• Implement best practices in data governance, data quality, and data security
• Partner closely with data scientists, researchers, and cross-functional stakeholders to understand data requirements and deliver impactful solutions
• Optimize data processing workflows for performance and scalability
• Create and maintain comprehensive documentation for data pipelines, data models, and integration processes
• Proactively identify and resolve data-related issues, ensuring reliability and accuracy
• Stay current with the latest technologies and best practices in data engineering and apply them to continuously improve processes

Requirements

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field
• Minimum of 5–7 years of experience in data engineering or a related role
• Proficiency in Databricks with a strong focus on data engineering
• Strong SQL skills and experience with relational databases
• Proficiency in programming languages such as Python, Java, or Scala
• Familiarity with cloud platforms (e.g., AWS, Azure, GCP)
• Experience with data warehousing and data lakehouse solutions (e.g., Redshift, BigQuery, Snowflake)
• Experience with ETL tools (e.g., Glue Studio, Informatica PowerCenter)
• Excellent problem-solving and communication skills; ability to work effectively in a collaborative team environment

Tech Stack

• Amazon Redshift
• AWS
• Azure
• BigQuery
• Cloud
• ETL
• Google Cloud Platform
• Informatica
• Java
• Python
• Scala
• SQL

Benefits

• Health Coverage: Medical, pharmacy, dental, and vision care.
• Wellbeing Support: Programs such as BMS Well-Being Account, BMS Living Life Better, and Employee Assistance Programs (EAP).
• Financial Well-being and Protection: 401(k) plan, short
• and long-term disability, life insurance, accident insurance, supplemental health insurance, business travel protection, personal liability protection, identity theft benefit, legal support, and survivor support.
• Work-life benefits include: Paid Time Off US Exempt Employees: flexible time off (unlimited, with manager approval, 11 paid national holidays (not applicable to employees in Phoenix, AZ, Puerto Rico or Rayzebio employees) Phoenix, AZ, Puerto Rico and Rayzebio Exempt, Non-Exempt, Hourly Employees: 160 hours annual paid vacation for new hires with manager approval, 11 national holidays, and 3 optional holidays Based on eligibility*, additional time off for employees may include unlimited paid sick time, up to 2 paid volunteer days per year, summer hours flexibility, leaves of absence for medical, personal, parental, caregiver, bereavement, and military needs and an annual Global Shutdown between Christmas and New Years Day. All global employees full and part-time who are actively employed at and paid directly by BMS at the end of the calendar year are eligible to take advantage of the Global Shutdown. *Eligibility Disclosure: T he summer hours program is for United States (U.S.) office-based employees due to the unique nature of their work. Summer hours are generally not available for field sales and manufacturing operations and may also be limited for the capability centers. Employees in remote-by-design or lab-based roles may be eligible for summer hours, depending on the nature of their work, and should discuss eligibility with their manager.