Software Engineer II, Data Solutions

Key Skills

Aartificial intelligence, Amazon RedShift, Effective communication skills, Python Programming, SPARK Programming

Job Description

The GPS Data & Analytics Software Engineer role is accountable for developing data solutions and operations support of the Enterprise data lake. The role will be accountable for developing the pipelines for the data enablement projects, production/application support and enhancements, and support data operations activities. Additional responsibilities include data analysis, data operations process and tools, data cataloguing, and developing data SME skills in Global Product Development and Supply – Data and Analytics Enablement organization.

Key Responsibilities:

• The Data Engineer will be responsible for designing, building, and maintaining the data products, evolution of the data products, and utilize the most suitable data architecture required for our organization's data needs to support GPS
• Responsible for delivering high quality, data products and analytic ready data solutions
• Develop and maintain data models to support our reporting and analysis needs.
• Develop ad-hoc analytic solutions from solution design to testing, deployment, and full lifecycle management.
• Optimize data storage and retrieval to ensure efficient performance and scalability
• Collaborate with data architects, data analysts and data scientists to understand their data needs and ensure that the data infrastructure supports their requirements
• Ensure data quality and integrity through data validation and testing
• Implement and maintain security protocols to protect sensitive data
• Stay up-to-date with emerging trends and technologies in data engineering and analytics
• Work with data/analytic technologies such as MS Excel Macro, Tableau, Cloudera Data Platform (CDP), Domino, Python and AWS/Azure/MS Cloud Products, chatGPT
• Participate in the analysis, design, build, manage, and operate lifecycle of the enterprise data lake and analytics focused digital capabilities
• Develop cloud-based (AWS) data pipelines to facilitate data processing and analysis
• Define data operations support (example: Access management) and experience with the supporting tools
• Build e-2-e data ETL pipelines from data integration -> data processing -> data integration -> visualization
• Proficient in Python, Spark, SQL, AWS Redshift/DBs, S3, Glue/Glue-Studio, Athena, AI.
• Good to have any Metadata platform (Like CDP-Impala or Okera), Neo4J, IAM, CFT & other Native AWS Service familiarity with Domino/data lake principles.
• Familiarity and experience with Cloud infrastructure management and work closely with the Cloud engineering team
• Participate in effort and cost estimations when required
• Partner with other data, platform, and cloud teams to identify opportunities for continuous improvements
• Architect and develop data solutions according to legal and company guidelines
• Assess system performance and recommend improvements
• Responsible for maintaining of data acquisition/operational focused capabilities including: Data Catalog; User Access Request/Tracking; Data Use Request

Required:

• 5-7 years of experience in information technology field in developing AWS cloud native data lakes and ecosystems
• Deeper understanding of cloud technologies preferably AWS and related services in delivering and supporting data and analytics solutions/data lakes
• Proficient in Python, Spark, SQL, AWS Redshift/DBs, S3, Glue/Glue-Studio, Athena, AI.
• 3-5 years of experience with operations and production support, and optimizing the supporting process
• Atleast 1-2 years of experience in an onshore offshore delivery model
• Solid programming skills in Python and Spark and strong proficiency in Cloud – AWS
• Knowledge of data security and privacy best practices

Ideal Candidates Would Also Have:

• Prior experience in global life sciences especially in the GPS functional area will be a plus
• Experience working internationally with a globally dispersed team including diverse stakeholders and management of offshore technical development team(s)
• Strong communication and presentation skills

Other Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Computer Engineering or equivalent is preferred

If you come across a role that intrigues you but doesn’t perfectly line up with your resume, we encourage you to apply anyway. You could be one step away from work that will transform your life and career.

Uniquely Interesting Work, Life-changing Careers

With a single vision as inspiring as “Transforming patients’ lives through science™ ”, every BMS employee plays an integral role in work that goes far beyond ordinary. Each of us is empowered to apply our individual talents and unique perspectives in an inclusive culture, promoting diversity in clinical trials, while our shared values of passion, innovation, urgency, accountability, inclusion and integrity bring out the highest potential of each of our colleagues.

On-site Protocol

BMS has a diverse occupancy structure that determines where an employee is required to conduct their work. This structure includes site-essential, site-by-design, field-based and remote-by-design jobs. The occupancy type that you are assigned is determined by the nature and responsibilities of your role:

Site-essential roles require 100% of shifts onsite at your assigned facility. Site-by-design roles may be eligible for a hybrid work model with at least 50% onsite at your assigned facility. For these roles, onsite presence is considered an essential job function and is critical to collaboration, innovation, productivity, and a positive Company culture. For field-based and remote-by-design roles the ability to physically travel to visit customers, patients or business partners and to attend meetings on behalf of BMS as directed is an essential job function.

BMS is dedicated to ensuring that people with disabilities can excel through a transparent recruitment process, reasonable workplace accommodations/adjustments and ongoing support in their roles. Applicants can request a reasonable workplace accommodation/adjustment prior to accepting a job offer. If you require reasonable accommodations/adjustments in completing this application, or in any part of the recruitment process, direct your inquiries to adastaffingsupport@bms.com. Visit careers.bms.com/eeo-accessibility to access our complete Equal Employment Opportunity statement.