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.
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:
The Global QLTS (Quality, Labs, TS/MS) Information and Data Solutions (IDS) team delivers and maintains applications that support the Global Quality Assurance, Lab and TS/MS organizations at Lilly. This team is part of the broader Manufacturing and Quality (M&Q) IDS organization that continues to transform as we look to the digital plant of the future and support manufacturing operational excellence and productivity efforts maximizing the use of technology and analytics. Significant investment and usage of data and analytics in the making of medicine is occurring where capabilities from simple visualizations to predictive and prescriptive analytics and machine learning are rapidly emerging across the global manufacturing landscape.
The Global QLTS IDS team works in partnership with the Global Quality business central and site representatives to define business needs and provide solutions for Manufacturing Quality. This team is responsible for the support and solution delivery of IT tools that support the Global Quality business application portfolio, such as TrackWise, Quality Intelligence Dashboards, Cold Chain, and Notification to Management, Global Lab business application portfolio, such as LIMS, LES, ELN, CDS, and Lab intelligence solution and Global TS business application portfolio, such as iAPR, Stature and global process monitoring solutions.
A key role in the Global QLTS organization is the Senior Data Engineer position. The Senior Data Engineer will have primary responsibility for conceptual and physical data modeling, data analysis and design, data integration, data visualizations and assist in the definition and implementation of information management capabilities for the Global Quality, Labs and TS assets.
Key Objectives/Deliverables:

• Assist Business Process Architects in gathering business rules and requirements.
• Partner with subject matter experts to deliver data visualization solutions to drive business decisions and performance monitoring.
• Develop conceptual data models / logical data models based on the business rules and requirements including data flow diagrams (understanding the data elements, cardinality, etc), building data pipe-lines in denodo, organization of data views in logical format.
• Influence and/or leverage common terminology and standard naming conventions/definitions for data objects
• Work with subject matter expert to develop Logical Data Marts (within solutions like Denodo, Tableau, or Power BI) for data reporting and visualization. Primary is Power BI and secondary is Tableau. (Note: Crystal Reports is not something that we are looking at and Physical modelling is more of a secondary skill)
• Lead definition and implementation of information management capabilities, such as meta data management, master data management, and a data catalog
• Analyze and assess the impact of system changes to the logical and physical data models. Work with application teams and not drive the changes in source applications.
• Work with application teams to develop and optimize queries from databases/APIs to meet business and technical requirements(Example: Work with TrackWise team or any other application teams in QLTS)
• Ensure compliance to Lilly privacy and security standards and Quality rules.
• Drive our data classification and categorization efforts for IT assets and champion these decisions.
• Partner with Business Process Architects, third party solution delivery providers, and Solution Architect to review and approve integration test scripts, and review and approve test output.
• Assist in data acquisition, data preparation, and data publishing for QA IT assets.
• Assist in integration testing across all endpoints of our QA data assets.
• Represent Global QLTS IDS in broader data governance and information management forums within the M&Q organization and enterprise.
• Influence data analytics opportunities to surface data across our assets and deliver valuable insights.
• Optional/Additional Skills:Participate in strategic conversations in how to leverage AI and Machine Learning capabilities to drive additional productivity and operational gains.
• Be an active learner. Stay abreast of tools and technologies to influence IT strategy so that it provides best usage opportunities for business.

Basic Requirements:

• At least 5-8 years of work experience in IT, solution delivery, and operations.
• At least 5-8 years experience working with ETL Technologies like Informatica, database technologies (On premises/Cloud), PL/SQL, database modeling, Oracle/AWS/Azure, Denodo, Netezza (Optional), Postgres and SAP HANA, (being able to navigate a DB and propose optimisation wherever needed)
• Data profiling skills are required to explore and understand a new source.(Example: Be more domain centric, understand the entity relationship, understand business data and map to the relevant relationships)
• Expertise with analytics/business intelligence solutions, including Tableau and Power BI
• Knowledge of Microsoft Power Platform (Power BI, Power Automate, Power Apps)
• Strong SQL development skills (Example: May be experience with tools like SQL Developer/ TOAD or any other tool)
• Strong Data literacy, such as knowledge of data modeling concepts (i.e., cadinality, aggregation, etc), data architectures for info integration, data visualization, & data warehousing
• Ability to work with business owners to define key business requirements and convert to technical and data specifications.
• Expertise in the design, data modeling creation, security, and management of data models
• Experience working in GxP regulated environments and complying with internal computer systems quality policies and procedures. Experience with Computer Systems Validation.
• Demonstrated ability to establish trusting relationships with business partners.
• Demonstrated ability to influence, and drive integration points across cross-functional teams.
• Strong written and oral communication.
• Demonstrated interpersonal, self-mgmt, collaboration, project mgmt, and problem solving skills.

Additional Preferred Requirements:

• Strong domain knowledge in SAP and/or Quality Management systems -TrackWise and Labs
• Working knowledge of DevOps solutions
• Experience in working in Scrum - agile methodologies, coding standards, code reviews, source management (GitHub), build processes
• Experience with Service Now toolset for incident, problem, and change management
• Pharmaceutical or healthcare industry experience

Education Requirements:
Bachelors Degree (or equivalent work experience) in computer science, information technology, or management information systems.
Other Information:
Travel to US or other Lilly entities may be required.
After hours support due to manufacturing 24/7 operations may be required
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