Lilly Data Architect – Senior Level in Bengaluru, India
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 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’re looking for people who are determined to make life better for people around the globe.
The Enterprise Data program is developing a fully integrated and intuitive data and analytics platform. 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.
This position is responsible for leading the development and maintenance of data model designs for information integration and exchange initiatives. The Data Architect works closely with software developers to design and implement database structures based on storage and retrieval needs. A key area of focus will be the review and approval of data designs to ensure consistent data architecture approach across the enterprise.
The 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.
- Competency Summary
Data Architecture is the bridge between strategy and execution (delivering data/information assets to the business). The data architect is expected to work with other architects and business subject matter experts to produce and manage business information models in all their forms, including conceptual models, logical abstractions, Entity-relationships/business ontologies, physical data designs, messaging models to efficiently move data across the data value chain (from ingestion to consumption and disposition). In this effort the data architect is instrumental in ensuring adherence to information principles, capabilities, tools and blueprints as defined by the reference architecture. Additionally, the functional data/information architecture office (governing body) is used as a lens and a filter to identify common patterns, establish reuse, prioritize and execute the data and analytic initiatives with clear line of sight to enterprise strategies and business outcomes.
Key capabilities in this role family include:
Data/Information Vision andStrategy, which includesthe ability to workwith business to identify future uses for Lilly data and anticipated businessresults, andenable processes to support these needs.
Data Planning/Modellingand Data Lifecycle Design. This includes the ability to developa technical strategy for future data structure and data integration.
Note: All data architecture roles should have a foundational set of knowledge in: communication, leadership, teamwork, problem solving skills, solution / blueprint definition, business acumen, architectural processes (e.g. blueprinting, reference architecture, governance, etc.), data standards (e.e.e.g. HL7, CDISC, SDTM), data vocabularies (MedDRA, RxNorm, SNOMED), project delivery, and industry knowledge.
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.
Analyzedata 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 andanalyzedata
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.
*Minimum Position Qualifications *
Bachelor’s Degree in computer science or related scientific discipline.
107 plusyears of experience designing large scale data models for functional, operational and analytical environments (Conceptual, Logical, Physical & Dimensional)
7 plus years of experience withdata design,data warehousing,and data modeling.
7+plusyears’ experience in several of the following disciplines: statistical methods, datamodeling, ontology development, semantic graph construction and linked data, relational schema design.
Demonstrated SQL and datamodelingproficiency.
Experience with datamodelingtools such as, ER*Studio and Erwin or TOAD
Experience in one or more cloud-based data solutions.
Experience with security models and development on large data sets
Experience with multiple database technologies
Experiencewithmultipledatabase solutions (e.g.Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models)
Experience with Agile Development, CI/CD, Jenkins,Github, Automation platforms
Demonstrated ability toanalyzelarge, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
Demonstrated ability to communicate with a geographically dispersed group of business and technical colleagues
Ability to review and provide practical recommendations on design patterns, performance considerations, database versions, and database deployment strategies
Knoweldgableindata functionssuch asData Governance, Master Data Management, Business Intelligence
Previous health care experience
Bachelor’s Degree or relevant degree
Additional Information :
Lilly is an EEO/Affirmative Action Employer, and does not discriminate on the basis of race, gender, protected veteran status, disability or any other legally protected status.
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 ( LillyRecruitingCompliance@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.
At Lilly we strive to ensure our employees are part of a team that cares about them and our shared purpose of making life better for those around the world. How do we do this? We continue to look for ways to include, innovate, accelerate and deliver while maintaining integrity, excellence and respect for people. We hope that you seek to join us on our journey as we create medicine and deliver improved outcomes for patients across the globe!