Data Analytics Systems Engineer

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.

This position is responsible for developing, deploying, and supporting Data Analytics capabilities at the Branchburg Manufacturing facility to meet business and regulatory needs. The role involves creating and maintaining dashboards, managing data lakes and repositories, and ensuring the seamless operation of data analytics tools. The Data Analytics Engineer will play a key role in driving the site's data analytics strategy, enhancing decision-making processes, and supporting continuous improvement initiatives. Additionally, the role includes troubleshooting and updating existing dashboards, assisting with system updates and enhancements, and solving computerized system issues in accordance with corporate standards and guidelines.

Key Objectives/Deliverables:

Manage For Results /Strategic Planning:

• Create, modify, and enhance dashboards and systems to satisfy business information demands. Facilitate changes by delivering feedback from customers to IT teams and communicate any changes applied ensuring operational procedures stay current and relevant.
• Assure adherence of applicable regulatory (i.e. cGXP, CFR, etc.) practices during execution of all work activities. Participate in audits, inspections, and associated readiness activities.
• Oversee and participate in the installation, configuration, and validation of key cGXP dashboards and tools. Develop and execute project plans, ensuring timely and quality delivery of solutions. Manage system customizations, scripts, and user interface enhancements.
• Proven ability to translate user requirements into dashboards and tools that drive business value.
• Design and implement integrations between Systems and Data Lake / Data Hub /Data Repositories to leverage when creating dashboarding capabilties.
• Responsible for daily support of end users, and provide end user training for all dashboards and analytics created.
• Perform the pre-validation assessment of all cGXP systems and dashboards, ensuring that all validation requirements have been met prior to system testing.
• Enable data-driven decision making in pharmaceutical Quality Control and Manufacturing by developing and deploying interactive, easy-to-use dashboards and reports that support self-service analytics, ensure secure and compliant access to critical data, and provide real-time insights to enhance process efficiency, product quality, and regulatory compliance.
• Ensure that the technology solutions being implemented are compliant with all relevant regulations (i.e. 21 CFR Part 11, Sarbanes Oxley, GxP, privacy data practices, local and corporate policies).
• Identify, recommend, and implement automated solutions to address QC laboratory or manufacturing operations. Execute with precision, speed, and simplicity, ensuring compliance with Computer Systems Validation policies, standards, procedures, and practices. Including the use of AI technology for automation and/or simplification of work.  Train and assist business users in proper use of applications and computerized systems.
• Foster professional and inclusive behavior, invite new ideas and differing perspectives among team members, assuring an on-going positive relationship with the customers and other members of the IDS organization. Inspire and recognize teamwork.
• Stay active and current in business technology trends, direction and innovation related to business process and technology areas of focus by participating in external forums, conferences, and other venues as necessary.
• Ensure compliance to corporate and site policies and procedures to be audit ready, mitigate risk, and follow quality management practices. Support and abide by applicable Lilly policies as indicated in the Lilly Red Book and other company policies and procedures. All corporate compliance training requirements must be met as required and defined.

Basic Requirements:

• BS/BA in Computer Science or related field required
• 5+ years IT or equivalent relevant experience.
• Basic understanding of databases (Oracle, SQL, etc.) and operating systems (Windows, etc.).
• 3+ years experience working with data analytics tools such as Power BI, Tableau, Spotfire or equivalent dashboarding tools.

Additional Preferences:

• MS/MBA desirable.
• Minimum of 2+ years in the Life Sciences industry
• Must maintain excellent working knowledge of pharmaceutical regulations (e.g. cGMP’s, 21 CFR Part 11, Computers Systems FDA) and other applicable regulations (e.g. Privacy, OSHA, etc.) related to laboratory and/or manufacturing environment and system applications.
• Ability to work on multiple concurrent project initiatives.
• Experience with managing external (vendor, consultant) business partners
• Previous experience in a regulated environment preferred.
• Effective problem-solving and analytical skills to resolve operational problems.
• Excellent written and verbal communication skills with the ability to develop and present both business and technical presentations.
• Ability to build relationships across dimensions of difference, ask questions and invite others to contribute.
• Speak up with ideas, concerns and to ensure safety of others.
• Demonstrated learning agility, and ability to think creatively, try new ideas and apply learnings.
• Highly motivated, enthusiastic to learn and share ideas and solutions effectively with management and colleagues.
• Strong collaboration with colleagues at all levels.
• Demonstrated success in influencing without authority.
• Strong customer service and teamwork oriented.
• Ability to take initiative, to be assertive, to lead by example and to build high-quality relationships.
• Highly flexible, adapting to changes in priorities, requirements and processes is required.

Other Information:

• Onsite 5 days a week, located at our Branchburg, NJ site. Travel required(10%). 
• Lifting not required. 
• May be required to be on call. 
• Lilly is an EEO/Affirmative Action Employer and 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.

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

$82,500 - $159,500

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.

#Wearelilly