LRL - Senior Data Engineer (AWS)

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.

Company Overview:

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 39,000 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.
 

Position Description:

Medicines Development (LRL @TechLilly) serves as a strategic function within Lilly Research Laboratories partnering with the Medicines Development Unit (MDU). MD (LRL @TechLilly) focuses on taking potential marketable products from Research through product registration and approval. MD IDS focuses on the MDU business needs of the future, enabling improvements through information and technology solutions. The teams define and influence information and business strategies, design and develop solutions to achieve the strategic outcomes, and ensure reliable deployment and support of these solutions.

The Senior Software Engineer will be responsible for designing, developing the cross-functional consumer data requests through delivery while working across solution delivery, support, information consultants and account teams as well as other key partners. Additionally, this role will also engage in transformational and enterprise level efforts to innovate and accelerate our value delivery. The Sr Software Engineer will be responsible for end-to-end process like taking the requirement, prepare the architecture and  start development of cloud components, changing the code, and deploying to production with the help of support team. This will be part of the data foundations development & enhancement.

If you are someone who has a blend of technical and soft skills and is open to wide-ranging responsibilities — this role will be a great fit for you!

Software Engineer Roles & Responsibilities:

• Understands business requirements and effectively translates business needs and process into technical terms, and vice versa. Coach and guides the junior engineers in code review, technical queries, etc.
• Uses standardized processes for requirements definition, analysis, design, construct, and test activities. Elicit business needs, perform data analysis, lead the effort on design and development of AWS python scripts, Glue jobs, Athena, Lambda and StepFunctions.
• Assess and apply query performance tuning or reusability opportunities.
• Applied knowledge of IT Service Management and implementation experience, encompasses all the processes, procedures.
• Produces and maintains project documentation as required, including that of Computer Systems Quality (by following quality-related procedures and utilize tools such as ALM, ServiceNow and Quality Docs).
• Provides and ensures effective impact analysis of changes, with consistency and conformance to Standard Operating Procedures for architecture, data, integrations, and processes.
• Ensure and apply proper data security based on process, business rules and approvals. Ensures Lilly information assets are protected from malicious content and access to information is restricted to authorized personnel only.
• Stay abreast of tools and technologies to influence IT strategy so that it provides best usage opportunities for business.

Required Experience:

• Bachelor’s Degree in Computer Science (or equivalent years of experience). Ability to adapt quickly in a constantly changing environment.

• As a Sr. Software Engineer you must have experience in software development life cycle, spanning project initiation through support. Understanding the development, testing and validation lifecycles.
• Strong Experience in AWS Data Services like Lambda, Glue, S3, Aurora and Pyspark
• Hands on  experience using AWS(Lambda,stepfunctions,Glue,S3, Aurora),Python/Pyspark and SQL.
• Strong Analytical and Problem solving skill.
• Having good SQL experience.
• Demonstrated learning agility both technically as well as business processes and applications
• Demonstrated initiative to build relationships, learn new business processes and identify process improvement opportunities.

Additional Skills/Preferences:

• Previous Pharmaceutical IT experience would an added advantage.
• Demonstrated ability to coordinate cross-functional work teams toward task completion

• Demonstrated ability to learn new technologies quickly
• Excellent oral and written communication skills, presentation skills.
• Excellent self-management skills. Strong problem-solving skills, Process improvement skills
• Organization skills, Self-management. Demonstrated ability to evaluate, facilitate, and drive towards risk-based decision making. Proven team player and the ability to work in a dynamic environment, where needs and priorities can change, with compressed deadlines.

Lilly is a global health care leader that unites caring with discovery to make life better for people around the world. For more than a century, we have stayed true to a core set of values—excellence, integrity, and respect for people—that guide us in all we do: discovering medicines that meet real needs, improving the understanding and management of disease, and giving back to communities. We also are committed to investing in our employees and supporting a culture of well-being —through competitive pay, comprehensive employee benefit programs, and training and development resources.

Lilly is an EEO/Affirmative Action Employer and does not discriminate based on age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability, or any other legally protected status.

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form (https://careers.lilly.com/us/en/workplace-accommodation) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and 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