Data Engineer

Key Skills

Java Programming, Python Programming, SQL, AWS, ETL frameworks, Web server, Dash framework

Job Description

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 35,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.

Organization Overview:

At Lilly, we serve an extraordinary purpose. We make a difference for people around the globe by discovering, developing, and delivering medicines that help them live longer, healthier, more active lives. Not only do we deliver breakthrough medications, but you also can count on us to develop creative solutions to support communities through philanthropy and volunteerism.

Responsibilities:

Business Units Information and Digital Solutions (IDS) is a global organization strategically positioned so that through information and technology leadership and solutions, we create meaningful connections and remarkable experiences, so people feel genuinely cared for. The Business Unit IDS organization is accountable for designing, developing, and supporting commercial or customer engagement services and capabilities that span multiple Business Units, functions, geographies, and digital channels.

This role includes data integration, acquisition, cleansing, harmonization and transforming raw data into curated datasets for data science, data discovery, and BI/analytics. The role is responsible for developing, constructing, testing, and maintaining data sets and scalable data processing systems focusing on the Next Best Action/Next Best Engagement Transformation Initiative for our International Business Unit.

This role also works with business and IT groups beyond the data sphere, understanding business needs and requirements, the enterprise infrastructure, and the many source systems. Input is raw datasets. Output is analytics-ready, integrated/curated datasets.

In this role, you will:

• Develop data-centric solutions to advance our business teams across all our global affiliates
• Consult with internal business partners (i.e. global marketing, sales, and medical affairs) to deliver data solutions to meet business needs
• Achieve technical proficiency in the core tools used by the solution services team (i.e. SQL, AWS, Python)
• Work in Agile Sprints with business facing project teams
• Learn business processes and data used by business functions
• Deliver sustainable and repeatable processes for delivery and supportability of our solutions

Key Responsibilities:

• Data Acquisition: gathering and storing data in a location and format that it can be consumed for data preparation and/or downstream business uses.
• Data Preparation: iterative process for exploring, integrating, cleaning, validating, and transforming raw data into curated datasets
• Data Publishing: releasing data in consumable form for (re)use by others.
• Gather business needs and requirements and translates into user stores for technical teams
• Responsible for system testing, ensuring effective resolution of defects
• Ensure adherence to appropriate quality standards and risk-based decision-making for all delivery efforts

Basic Qualifications:

• A Bachelor’s degree in a computer science or information technology related field
• 3 years experience working in data engineering 

Additional Skills/Preferences:

• Certifications or experience in cloud technologies, especially Amazon Web Services (AWS)
• Certifications or experience in Agile project delivery, especially Scaled Agile Framework (SAFe)
• Familiar with data integration methods (ETL, micro-services, API’s, real time/near real time integrations)
• A strong learning agility
• Ability to work independently or with a team
• Proven track record of technical delivery
• Experience working with a diverse and non-collocated global team
• Technical curiosity and desire to innovate
• Excellent interpersonal skills, including the ability to build networks/partnerships with diverse groups of individuals and to work effectively within geographically dispersed team and partners

Company Amenities and Benefits:

In addition to a supportive team, relationships that last, and employee resource groups, Lilly provides several benefits to allow you to be your best self, including:

• Generous retirement programs, such as employer 401k match and a completely employer funded pension program
• Employer sponsored healthcare coverage, including dental, vision, health, life, and disability options.
• On-site fitness centers, an outdoor track and field, and free access to over 30,000 fitness centers nationwide (including many popular national chains)
• A sprawling urban campus located close to stadiums and downtown entertainment, with free on-campus parking
• Campus-based amenities, including cafeterias, coffee shops, Team Lilly lounges featuring shuffleboard and live sports, on-site health services, dry cleaning, and an eye and dental clinic
• Starting with three weeks of paid vacation, two weeks of paid company shutdown (week of July 4th and week between Christmas Day and New Year’s Day), 8 company holidays, and three floating holidays for you to celebrate what matters to you
• A fully paid parental leave program, including 10 weeks for all parents and an additional 10 weeks unpaid
• Access to our employee assistance program, which helps connect to professionals for mental and physical well-being resources
• A hybrid work environment, with your home-base being our corporate campus in downtown Indianapolis. You will have flexibility to work remotely in this position but will need to be able to regularly come into the office to partner with others and collaborate with your team.

For Internal Candidates:

• When applying internally for a position your current supervisor receives notification that you have applied to the position. We encourage employees to discuss the opportunity with their supervisor prior to applying.
• This role can be for candidates outside of the United States.

For All Candidates:

• Qualified candidates must be legally authorized to be employed in the United States. Lilly does not anticipate providing sponsorship for employment visa status (e.g., H-1B or TN status) for this position.