Data 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 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.

Job Summary

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 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 are looking for people who are determined to make life better for people around the globe.

Global Data Integration and Analytics program is developing a fully integrated and intuitive data and analytics platform on Cloud. This platform will enable Lilly team members to quickly view, access, and analyze data sets in statistical environments, advanced analytics environments, and BI/visualization tools. Contributors can easily ingest, prepare, and analyze new data sets (cleanse, enhance, publish) for others to utilize.

The position is responsible for providing support to visualization solution assets, accountable for their stability and continuous improvement to enable the growth of the Visualization services. The employee will also be responsible to process and move data between different compute and storage services, creation, scheduling, orchestration, and management of data pipelines.

This position will report to DIA Sr. Team Lead.

Key Objectives/Deliverables

• Responsible for ensuring the availability and quality of data needed for analysis and business transactions. This includes data integration, acquisition, cleansing, harmonization and transforming raw data into curated datasets for data science, data discovery, and BI/analytics
• Responsible for developing, constructing, testing and maintaining data sets and scalable data processing systems
• Data engineers work close with Data Architects and Data Scientists. They work with global business and IT groups beyond the data sphere, understanding the enterprise infrastructure and the multiple source systems
• Ensure ownership of all DIA data and visualization solution assets ensuring their reliability, compliance, and evolution according to the DIA internal and external data availability requirements. Serve as reviewer of validation documentation
• Responsible for the ensuring system validation remains current, including but not limited to design, configuration, SOP, IVI, IR, IQOQs, Test Scripts. Responsible for Source code controls and standards development
• Conduct business analysis, collect business requirements and translate them into BI Solution leveraging best practices
• Identify, troubleshoot, debug, and resolve technical issues
  
  

Basic Requirements

• Minimum 3 years Pharmaceutical Manufacturing experience. Knowledge of GxP, Pharmaceutical manufacturing processes and automations systems
• Minimum 3 years of relevant experience with Data Analytics and Visualization design
• Design right interfaces for Data Visualization
• Extensive knowledge on PowerBI, Tableau or SAP BO, with hands on experience in developing visualizations primarily for Manufacturing domain.
• Strong experience with SQL, Visualization technology and good experience with Cloud Architecture
• Must be a good communicator, efficiently collaborate with Vendors and deliver support and new enhancements
• Strong experience with AWS ETL/File Movement tools (GLUE, Athena, Lambda, Kenesis and other AWS integration stack)
• Strong experience with Agile Development, Cloud formation Template, AWS CodeBuilt, AWS Code Pipeline
• Strong experience with Two or Three AWS database technologies (Redshift, Aurora, RDS, S3 & other AWS Data Service) covering security, policies, access management
• Strong programming Experience with Python and Spark
• Experience with security models and development on large data sets
• Proficiency in designing and building architecture for data visualization tools like Power BI and/or Tableau on AWS/Azure
• Experience in deploying and managing Visualization as a service on cloud platforms. Understanding of DAX Query model and Tableau Data Models
• Strong Experience in Creating Data Models for Visualization tool and Extracting data from AWS cloud storage, AWS data warehouse, AWS database for PostgreSQL, Data Lake and Streaming Data Store and other Data warehouse solutions, API’s
• Experience with custom visuals in Python/R for PowerBI Visualizations and Data Analytics
  
  

Basic Role’s Characteristics

• Demonstrate learning agility
• Demonstrated initiative to build relationships, learn new business processes, identify opportunities
• Customer-oriented with a high level of understanding of impact on production activities
• Spend substantial time communicating and educating – ability and skills to clearly communicate ideas in a persuasive, compelling manner
• Able to work in a multi-cultural environment
• Partners with management on process improvements
• Excellent communication, interpersonal, and influencing skills. Ability to carry on conversations with business customers, upper management, and technical personnel
• Strong problem solving and organizational skills
  
  

Additional Preferences

• Vendor management
  
  

Education Requirements

BE in Computer Science/IT, or Engineering (or equivalent work experience)

Other Information

• Travel may be required to other Manufacturing sites in US and/or Europe
  
  

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