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.

Overview:
As a Data Architect you will be responsible for ensuring the availability and quality of data needed for analysis and business transactions. This includes working with data scientists and engineers to create a deep understanding of the relevant data domains and relationships, modelling new and existing data in new ways to meet business needs, suggesting techniques for harmonizing disparate data sources and new approaches to analysing the data.

Data Architect will be responsible for the understanding of new data requirements and working in conjunction with the development team to build, test, document and maintain the data solutions that are both scalable and supportable.

The Data Architect should be intimately familiar with all forms of database solutions (Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models) as well as have a practical working knowledge of the data sources and intent of

the system.

Key Responsibilities:

- Data/Information Vision and Strategy, which includes the ability to work with business to identify future uses for Lilly data and anticipated business results and enable processes to support these needs.
- Data Planning/Modelling and Data Lifecycle Design. This includes the ability to develop a technical strategy for future data structure and data integration.
- Develop and provide expertise in enterprise data domains; this includes data relationships, data quality, understanding of business data needs and the associated technology toolsets and methodologies.
- Develop understanding how the enterprise data strategies, platforms, and technologies enable business execution. Use this knowledge to appropriately challenge status quo and drive business-IT collaboration.
- Analyse data from multiple domains; discover trends and associations, synthesize new integration constructs that assist non-expert users to find similar trends and associations.
- Facilitate efficient and scalable data exchange between Lilly and its external partners using industry standards and data integration methodologies.
- Use cutting edge information technologies to organize and analyse data.
- Extend publicly available data sets, ontologies and taxonomies for internal Lilly use.
- Continuously scan the technology environment for new trends and techniques: interface with external consultants and thought leaders as needed.
- Synthesize new scalable approaches for Lilly data integration; derive the supporting arguments, communicate and articulate the reasons for the new approaches to fellow engineers as well as senior management.
- Work with Computer Systems Quality team to validate solutions.
- Identify, troubleshoot, debug, and resolve technical issues.
- Work in Agile Sprints with business facing project teams

Required Technical Skills:

- Bachelor’s degree in computer science or related scientific discipline.
- 7+ plus years of experience designing large scale data models for functional, operational and analytical environments (Conceptual, Logical, Physical and Dimensional).
- 7+ plus years of experience in following disciplines: statistical methods, data modelling, ontology development, semantic graph construction and linked data, relational schema design.
- Demonstrate SQL and data modelling proficiency.
- Experience in AWS cloud-based data solutions.
- Experience with security models and development on large data sets.
- Experience with multiple database solutions (e.g. Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models).
- Demonstrate ability to analyse large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
- Demonstrate ability to communicate with a geographically dispersed group of business and technical colleagues.
- Ability to review and provide practical recommendations on design patterns.
- Experience working directly with business partners for requirement elicitation.
- Experience with Agile Development, Jira, CI/CD and GitHub.
- Excellent oral and written communication skills.
- A high level of intellectual curiosity, external perspective, and innovation interest.
- Strong analytical, problem solving and investigative skills.

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 oth