Associate - Data Engineer - Global Master Data

<p style="text-align:left">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.</p><p style="text-align:inherit"></p><p><b>What You Will Do</b></p><p>As a Data Engineer you will be located in<b> Indianapolis, IN</b> and 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.</p><p></p><ul><li><p>Design, build, and maintain scalable and reliable data pipelines for batch and real-time processing.</p></li><li><p>Own <b>incident response and resolution</b>, including root cause analysis and post-mortem reporting for data failures and performance issues.</p></li><li><p>Develop and optimize data models, ETL/ELT workflows, and data integration across multiple systems and platforms.</p></li><li><p>Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver solutions.</p></li><li><p>Implement data governance, security, and quality standards across data assets.</p></li><li><p>Lead end-to-end data engineering projects and contribute to architectural decisions.</p></li><li><p>Design and implement cloud-native solutions on AWS (preferred) using tools such as AWS Glue, EMR, and Databricks. Experience with Azure or GCP is a plus.</p></li><li><p>Promote best practices in coding, testing, and deployment.</p></li><li><p>Monitor, troubleshoot, and improve performance and reliability of data infrastructure.</p></li><li><p>Automate manual processes and identify opportunities to optimize data workflows and reduce costs.</p></li></ul><p></p><p><b>How You Will Succeed: </b></p><ul><li><p><b>Deliver scalable solutions</b> by designing robust data pipelines and architectures that meet performance and reliability standards.</p></li><li><p><b>Collaborate effectively</b> with cross-functional teams to turn business needs into technical outcomes.</p></li><li><p><b>Lead with expertise</b>, mentoring peers and driving adoption of best practices in data engineering and cloud technologies.</p></li><li><p><b>Continuously improve systems</b> through automation, performance tuning, and proactive issue resolution.</p></li><li><p><b>Communicate with clarity</b> to ensure alignment across technical and non-technical stakeholders.</p></li></ul><p></p><p><b>Your Basic Qualifications </b></p><ul><li><p>Bachelor’s degree in Computer Science, Information Technology, Management Information Systems or similar stem fields</p></li><li><p>At least 2 years of experience in data engineering</p></li><li><p>1+ years of experience using GitHub and CI/CD pipelines for code deployment.</p></li><li><p>Proven experience in architecting and building high-performance, scalable data pipelines following Data Lakehouse, Data Warehouse, and Data Mart standards.</p></li><li><p>Strong expertise in data modelling (both OLTP and OLAP), managing large datasets, and implementing secure, compliant data governance practices.</p></li><li><p><i><b><span>Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support for or sponsor work authorization or visas for this role, including but not limited to F-1 CPT, F-1 OPT, F-1 STEM OPT, J-1, H-1B, TN, O-1, E-3, H-1B1, or L-1.</span></b></i></p></li></ul><p></p><p><i><b><span>Remote candidates will not be considered </span></b></i></p><p></p><p><b>What You Should Bring:</b></p><ul><li><p>Strong proficiency in <b>SQL and</b> Python.</p></li><li><p>Hands-on experience with <b>cloud platforms</b> (AWS, Azure, or GCP) and tools like Glue, EMR, Redshift, Lambda, or Databricks.</p></li><li><p>Deep understanding of <b>ETL/ELT workflows</b>, data modelling, and data warehousing concepts.</p></li><li><p>Familiarity with <b>big data and streaming frameworks</b> (e.g., Apache Spark, Kafka, Flink).</p></li><li><p>Knowledge of <b>data governance, security, and quality practices</b>.</p></li><li><p>Working knowledge of Databricks for building and optimizing scalable data pipelines and analytics workflows.</p></li><li><p>Experience with <b>CI/CD, version control (Git)</b>, and infrastructure-as-code tools is a plus.</p></li><li><p>A <b>problem-solving mindset</b>, attention to detail, and a passion for clean, maintainable code.</p></li><li><p>Strong <b>communication and collaboration</b> skills to work with both technical and non-technical stakeholders.</p></li><li><p>Domain experience in healthcare, pharmaceutical (Customer Master, Product Master, Alignment Master, Activity, Consent), or regulated industries is a plus.</p></li><li><p>Partner with and influence vendor resources on solution development to ensure understanding of data and technical direction for solutions as well as delivery</p></li><li><p>AWS Certified</p></li><li><p>Databricks Certified</p></li><li><p>Familiarity with AI/ML workflows and integrating machine learning models into data pipelines</p></li><li><p>Experience in leading a small team of data engineers and providing technical mentorship.</p></li><li><p>Ability to collaborate with business stakeholders to translate key business requirements into scalable technical solutions.</p></li><li><p>Familiarity with security models and developing solutions on large-scale, distributed data systems.</p></li></ul><p></p><p><b>About the Tech at Lilly Organization:</b></p><p>Tech at Lilly builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates Tech at Lilly 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 the enterprise.</p><p style="text-align:left">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 (<a target="_blank" href="https://careers.lilly.com/us/en/workplace-accommodation"><span><span><span class="WCO0">https://careers.lilly.com/us/en/workplace-accommodation</span></span></span></a>) 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.</p><p style="text-align:inherit"></p><p style="text-align:left">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.</p><p style="text-align:left"><br />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.</p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:left">Actual compensation will depend on a candidate’s education, experience, skills, and geographic location.  The anticipated wage for this position is</p>$64,500 - $184,800<p style="text-align:inherit"></p><h3></h3><p style="text-align:left">Full-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.</p><p style="text-align:inherit"></p><p style="text-align:left">#WeAreLilly</p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...