IBU Solution Services Cloud-Data-Engineer at Lilly Bangalore

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.

Job Title: IBU Solution Services Cloud-Data-Engineer at Lilly Bangalore

(Engineer II - Software Configuration & Development)

Contact Name: Shubhra Verma

Contact Details: Shubhra.verma@lilly.com

Detailed Description:

Lilly International Business Unit is accountable for “Delivery” and “Operational" Excellence of the application portfolio and services consumed by the commercial affiliates within the international geography. Working across 120+ countries, IBU (International Business Unit (Lilly International)) delivers multi-channel, digital, web, mobile, productivity and analytics services and solutions; supports the operations of the multi-channel content (marketing tactics production) and provides service management (support) to those services through a diverse and high-performing team located across 19 countries.

The IBU Solution Services Cloud Engineer is responsible for the “Technical Excellence” of the cloud application and service portfolio for Lilly International. Technical Excellence is defined as the ability to foresee and eliminate an issue before it has the potential to jeopardize security, schedule, budget, sustainability, and most importantly, client satisfaction.

Job Description:

As a Cloud Data Engineer, you will play a crucial role in designing, implementing, and maintaining our cloud-based data infrastructure. You will collaborate with cross-functional teams to ensure data availability, reliability, and security, enabling data-driven decision-making and insights.

Key Responsibilities:

• Design and develop data pipelines to extract, transform, and load (ETL) data from various sources into cloud-based data storage solutions.
• Implement data integration solutions using cloud services such as AWS (Amazon Web Service)
• Incorporate deep data management expertise into solutions, including permissions, recovery, security, and monitoring.
• Validate and qualify solutions. 
• Identify, troubleshoot, debug, and resolve technical issues.  
• Work with business and IT groups to understand source systems and enterprise infrastructure offerings.
• Work with data from multiple data sources to build integrated views that will drive decisions.
• Collaborate with data scientists, analysts, and software engineers to understand data requirements and ensure the availability of quality data.
• Optimize and tune data pipelines for performance and scalability.
• Implement data security and access controls to protect sensitive information.
• Monitor, troubleshoot, and resolve data pipeline and infrastructure issues.
• Stay current with emerging data engineering technologies and best practices.
• Document data engineering processes and standards.
• Work with stakeholders to define data architecture and modelling requirements.
• Provides technical leadership and consultancy to IBU Solution Services in close partnership with IBU Architect to ensure the delivery of cloud solutions is aligned with the Enterprise IT (Information Technology) architecture.
• Creates and reviews system designs to leverage existing standards, to evaluate alternative technologies and to build a cost-effective solution.
• Develops a deep expertise on cloud platforms/technologies used by IBU Solution Services to assist system custodians with life cycle management or complex changes.
• Reviews source code provided by External Service Providers.
• Ensures coding standards or technical implementation guides are in place for IBU cloud platforms or technologies and educates External Service Providers to ensure they are followed.
• Helps to establish a DevOps to improve the quality, security, automation capabilities and stability of our cloud solutions.
• Identifies synergies and reuse opportunities to improve efficiency and cost savings.
• Identifies and drives proof of concepts for emerging technologies at Lilly and helps the IBU Solution Services team prepare for the adoption of these technologies.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field (master’s preferred).
• Proven experience as a data engineer, preferably in a cloud environment.
• Strong experience with AWS ETL/File Movement tools (GLUE, Athena, Lambda, Kinesis, and other AWS integration stack)
• Strong experience with Agile Development, CI/CD, Jenkins, GitHub, Automation platforms
• Strong experience with AWS database technologies (Redshift, Aurora, RDS, S3 & other AWS Data Service) covering security, policies, access management.
• Strong programming Experience with Lambda, Python and Spark
• Experience with Apache Airflow, Ansible & other automation stack.
• Familiarity with data modeling, data warehousing, and data architecture best practices.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration skills.
• Ability to work in a fast-paced and dynamic environment.

Technical Experience:

Must Have

Postgres SQL

PL/SQL (Procedural Language / Structure Query Language)

AWS Glue / Lambda

Python / Py Spark

AWS S3 / Redshift / Aurora DB / Athena

Airflow

Good to Have

Power BI / Tableau

Agile

AWS CI/CD / EMR / Kinesis / Step Function

AWS Glue Catalogue

AWS CloudTrail

Informatica

Oracle / MS SQL / Postgres SQL

Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( Lilly_Recruiting_Compliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. Any other correspondence will not receive a response.

Lilly does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

#WeAreLilly