Enterprise Data – Data Architect

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.

Lilly’s Purpose

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.

Come bring to life technologies to lead in Pharma-tech!

LCCI Tech Team is actively looking for a motivated leader for Enterprise Data Organization who will promote the optimal extraction of data and improve data infrastructure and operations aligned with organizational goals, while fostering operational excellence, compliance, and collaboration across teams and stakeholders. Senior leader and strategic business partner in driving data and analytics services to fuel business driven insights enabling a competitive advantage. Manages an enterprise-wide data function such as Enterprise Data Strategy, Governance, Data Delivery and common data architecture.

The Enterprise Data organization has developed an integrated and intuitive data and analytics platform.  This platform enables Lilly team members to quickly ingest, transform, consume 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.

Key responsibilities include:

• Design and advise on design of high-performance and scalable data pipelines and consumption solutions in AWS adhering to modern data Lakehouse architecture. This includes all the following
  • Optimal storage, retrieval, and processing of data.
  • Data integrity, security, and privacy requirements and best practices
  • Self-healing automation (error and anomaly detection, identification of root cause, and recovery)
• Design reusable components which accelerate enterprise delivery of data for consumption.
• Conduct technology assessments and proof of concepts to understand how to best position technology and capabilities.
• Ensure timely discussion around impediments and risk to supportability and delivery of pipelines.
• Actively participate in regular SAFe Agile framework ceremonies and activities ensuring timely and quality delivery of pipelines.  
• Actively stay informed of industry tools and technologies and strategic applicability to development of robust data pipelines.
• Demonstrated data leadership and technical coaching skills
• Strong partnership with Enterprise Architects across functions.

Basic Qualifications:

• Bachelor’s degree in computer science, information technology, management information systems or equivalent work experience 
• Overall, 10 to 15 years of development experience in the Architecture & Design, Core tools and technologies like SQL, Python, AWS (Lambda, Glue, S3, Redshift, RDS, DMS, Athena, IAM Roles & Policies), PySpark used by the solution services team.
• Solid understanding of cloud computing platforms (AWS or Azure) and AWS Solutions Architect Associate certified (Preferred).
• Understanding of modern data architecture, data lakehouse, data warehousing and/or big data concepts.
• Assumes primary responsibility for implementing data cleansing steps and transformations to support AI/ML models and for building datasets for ML or other statistical models
• 3-5 years of experience in Agile Development and code deployment using Github & CI-CD pipelines.
• Exposure in the design, data modelling, creation and management of large datasets/data models
• Performance tuning, OLTP and OLAP data modeling, Devops implementation
• 5 Years of ETL and ELT solution implementation.
• Strong problem-solving skills and the ability to analyze complex data requirements.

Additional Information:

• Strong Commitment to the Principles of Good Software Design
• Understanding of Cloud / Hybrid data architecture concepts
• Strong Written and Oral Communication Skills
• Ability to analyze, design, and implement components by applying best practices and coding standards
• Strong Commitment and Willingness to Learn

Lilly is a global healthcare leader that unites caring with discovery to make life better for people around the world. For more than a century, we have stayed true to a core set of values—excellence, integrity, and respect for people—that guide us in all we do: discovering medicines that meet real needs, improving the understanding and management of disease, and giving back to communities. We also are committed to investing in our employees and supporting a culture of well-being —through competitive pay, comprehensive employee benefit programs, and training and development resources. 

We’re doing extraordinary things. Join us and you could be, too!

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