Associate Director – 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.

Eli Lilly Cork is made up of a talented diverse team of over 2,000 employees across 60 nationalities who deliver innovative solutions that add value across a variety of Business Service functions including Finance, Information Technology, Medical, Clinical Trials and more.

Eli Lilly Cork offers a premium workspace across our campus in Little Island, complete with flexible hybrid working options, healthcare, pension and life assurance benefits, subsidised canteen, onsite gym, travel subsidies and on-site parking. Inhouse People Development services, Educational Assistance, and our ‘Live Your BEST Life’ wellbeing initiatives are just some of the holistic benefits that enhance the career experience for our colleagues.

Eli Lilly Cork is committed to diversity, equity and inclusion (DEI). We cater for all dimensions ensuring inclusion of all ethnicities, nationalities, cultural backgrounds, generations, sexuality, visible and invisible disabilities and gender, with four pillars: EnAble, Age & Culture, LGBTQ+ and GIN-Gender Inclusion Network. EnAble, our pillar for people with disabilities and those that care for them, partners with the Access Lilly initiative to make our physical and digital environment accessible and inclusive for all. Together they are committed to promoting awareness to create a disability confident culture both at Eli Lilly Cork and beyond.

Come join our team – Be Creative, Be an Innovator, and most of all, Be Yourself!

The GCOA are responsible for identifying and developing transformative innovation solutions and delivering and measuring business impact primarily in the form of productivity and efficiency to GBS Finance, Finance and other areas of Lilly.

This critical role converts business challenges and opportunities to a technology strategy that maximises technological adoption. The essence of the role is to maximise technology use by our business partners and to ensure that our delivery teams are using the best-in-class technology to solve enterprise problems robustly at scale.

This role involves challenging existing processes and policies to transform existing ways of working. This allows the GCOA to tailor solutions to meet the unique needs of Lilly, ensuring that the organization can effectively leverage technology to achieve its goals.

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 working with Fabric technology for application integration.
• Experience working with financial data (O2C, P2P, GA, Corporate Accounting)
• 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.
• Experience in applying quality and compliance requirements.

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

Read Full Description