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.
Do you enjoy learning new knowledge domains and answering engaging questions?
The Global Services Tech at Lilly team is actively seeking a Data engineer in Indianapolis, IN to partner with internal business and Tech at Lilly partners to accelerate the delivery of data solutions for analytics and business purposes.
A Data engineer onsite in Indianapolis, IN is responsible for designing, developing, and maintaining the data solutions that ensure the availability and quality of data for analysis and/or business transactions. They design and implement efficient data storage, processing and retrieval solutions for datasets and build data pipelines, optimize database designs, and work closely with data scientists, architects, and analysts to ensure data quality and accessibility. Data engineers require strong skillsets in data integration, acquisition, cleansing, harmonization, and transforming data. They play a crucial role in transforming raw data into datasets designed for analysis which enable organizations to unlock valuable insights for decision making.
Engage and partner with cross-functional tech teams across Global Services (finance), third party solution delivery providers, and Data architects to understand the business problem and enhance/develop the appropriate data solution leveraging the modern tech stack
Design and implement highly performant data ingestion/processing pipelines from multiple sources
Develop technical solutions which combine disparate information to create meaningful insights for business partners
Operate with a quality mindset always considering the impact of design decisions on the long-term support and maintenance of data pipelines/jobs
Ensure data integrity, security, and privacy requirements are met
Stay abreast of tools and technologies to influence our strategy so that it provides best usage opportunities for business
A foundational set of knowledge in: communication, leadership, teamwork, problem solving skills, solution / blueprint definition, business acumen, architectural processes (e.g. blueprinting, reference architecture, governance, etc.), technical standards, project delivery, and industry knowledge.
Strong skillsets in data integration, acquisition, cleansing, harmonization, and transforming data
Experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional)
Experience in several of the following disciplines: statistical methods, data modeling, ontology development, semantic graph construction and linked data, relational schema design.
Demonstrated SQL/PLSQL and data modeling proficiency.
Experience with data modeling tools such as, ER*Studio and Erwin or TOAD
Experience in AWS or Azure techstack
Experience in building/integrating APIs
Experience in creating data products using APIs
Experience with security models and development on large data sets
Experience with Microsoft Fabric
Experience with multiple database technologies
Experience with multiple database solutions (e.g. Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models)
Experience with Agile Development, CI/CD, Jenkins, Github, Automation platforms
Experience in implementing effective data loading strategy (CDC, incremental loads)
Demonstrated ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
Demonstrated ability to communicate with a geographically dispersed group of business and technical colleagues
Ability to review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies
Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence
Bachelors Degree in computer science, information technology, Management information systems or related fields.
Or High School Diploma with at least 4+ years of Data Engineer experience
Experience in data integration, acquisition, cleansing, harmonization, and/or transforming data
Ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
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 employment position
Lilly does not anticipate providing sponsorship for employment visa status (e.g., H-1B or TN status) for this employment position.
Must be willing to relocate to the Indianapolis area
Hybrid work schedule
0-10% travel
Additional Preferences:
CDMP Certification
AWS Solution Architect
Understanding of a highly regulated environment that involves data privacy and confidential information requirements
Technology at Lilly builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates our team is that we create new possibilities through tech to advance our purpose – creating medicines that make life better for people around the world, like data driven drug discovery and connected clinical trials. We hire the best technology professionals from a variety of backgrounds, so they can bring an assortment of knowledge, skills, and diverse thinking to deliver innovative solutions in every area of our business.
The Global Services IT team leads digitalization across organizations spanning the enterprise with Finance, Legal, Ethics & Compliance, Corporate Affairs and Human Resources as well delivers best-in-class ERP Solutions. This team leverages technology and analytics to enable transformations across the enterprise.
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 is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status.
Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Women’s Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups.
Actual compensation will depend on a candidate’s education, experience, skills, and geographic location. The anticipated wage for this position is
$64,500 - $158,400Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lilly’s compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.
#WeAreLilly