Software Engineer – Analytical Engineering

BMS interview process typically starts with a timed online aptitude test followed by a technical interview that probes depth in SQL, Python, Spark and data‑modeling scenarios. The final HR round focuses on cultural fit, communication skills and career aspirations. Candidates find the technical round moderately challenging but fair, with emphasis on problem‑solving approach rather than memorisation.

BMS is known for a collaborative, research‑driven culture where employees are encouraged to innovate and take ownership of their projects. The company offers structured career growth, regular learning sessions, and a healthy work‑life balance with flexible timings and remote‑work options where applicable.

Graduation degree (B.Tech/B.E., B.Sc., M.Sc.) in Computer Science, Physics, Mathematics, Data Science, Pharmaceutical Science, Engineering or related fields; Minimum 60% aggregate (or CGPA 6.5/10); Graduation batch 2022‑2026; No active backlogs at the time of application; 1‑3 years of relevant experience in analytical engineering, data modeling or similar roles.

Round 1: Online Aptitude Test (logical reasoning, quantitative, verbal) → Round 2: Technical Interview (SQL, Python, Spark, data modeling, scenario‑based questions) → Round 3: HR Interview (fitment, communication, career goals)

Bristol Myers Squibb (BMS) is a global biopharmaceutical leader with a legacy of discovering, developing and delivering innovative medicines across therapeutic areas such as oncology, cardiovascular, immunology and virology. With a presence in more than 60 countries, BMS combines cutting‑edge science with a strong commitment to patient outcomes, fostering a culture of collaboration, integrity and continuous learning. The company’s Indian operations, headquartered in Hyderabad, serve as a strategic hub for data‑driven decision making, supporting research, commercial, and operational teams worldwide. The role of Software Engineer – Analytical Engineering sits at the intersection of data engineering and analytics. As an analytical engineer, you will transform raw, heterogeneous data into clean, business‑ready datasets that power dashboards, reports, and AI/ML models. You will work closely with data scientists, product owners, and business analysts to design, build, and maintain scalable data pipelines, centralized data layers, and reusable data products. The position offers early‑career engineers a fast‑track to mastering end‑to‑end data workflows while gaining exposure to modern cloud and BI technologies. **Key Responsibilities** 1. Design, develop and maintain ELT pipelines using Spark, Python and SQL to ingest and transform large‑scale datasets. 2. Build and document centralized data models (star/snowflake schemas) that serve multiple analytics use‑cases. 3. Collaborate with AI/ML teams to provide high‑quality, well‑documented data foundations for predictive models. 4. Implement data quality checks, testing frameworks and monitoring using Airflow DAGs. 5. Optimize query performance and storage costs on AWS data services (Redshift, Athena, S3). 6. Create and maintain visualisations and dashboards in Tableau, Power BI or Looker for business stakeholders. 7. Version‑control all code and configuration using Git/SVN and follow Agile sprint cycles. 8. Produce technical documentation in Confluence and support knowledge‑transfer sessions. 9. Participate in code reviews, pair‑programming and continuous improvement initiatives. 10. Engage with cross‑functional teams to gather requirements, translate business questions into data solutions, and present findings clearly. **Tech Stack**: SQL, Apache Spark (PySpark), Python, dbt (preferred), AWS (S3, Redshift, Athena), Apache Airflow, Tableau/Power BI/Looker, Git/SVN, Agile tools (JIRA, Confluence), Oracle, PostgreSQL, CDP Impala. **Growth Path**: Starting as an Analytical Engineer, you can progress to Senior Analytical Engineer, Data Platform Lead, or move into specialized AI/ML engineering or product analytics roles. BMS encourages internal mobility, mentorship programs, and sponsorship for certifications (AWS, dbt, Tableau). **Why Join BMS?** You will be part of a purpose‑driven organization that impacts millions of lives, work with state‑of‑the‑art data technologies, and receive strong support for professional development. The Hyderabad campus offers a collaborative environment, flexible work‑from‑home options, and a balanced work‑life culture that values employee well‑being.