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.

### **Job Description: 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 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.

Business Units Information and Digital Solutions (IDS) is a global organization strategically positioned so that through information and technology leadership and solutions, we create meaningful connections and remarkable experiences, so people feel genuinely cared for. The Business Unit IDS organization is accountable for designing, developing, and supporting commercial or customer engagement services and capabilities that span multiple Buiness Units (Bio-Medicines, Diabetes, Oncology, International), functions, geographies, and digital channels. The areas supported by Business Unit IDS includes: Customer Operations, Marketing and Commercial Operations, Medical Affairs, Market Research, Pricing, Reimbursement and Access, Customer Support Programs, Digital Production and Distribution, Global Patient Outcomes, and Real-World Evidence.

This position is responsible for providing support for ETL / ELT / File Movement of data.   The key responsibilities will be to process and move data between different compute and storage services, as well as on-premises data sources at specified intervals. The employee will also be responsible for the creation, scheduling, orchestration and management of data pipelines. 

**Position Summary:** 

We are seeking a skilled and experienced Data Architect to design, optimize, and oversee our organization's data systems and infrastructure esp for Customer Support Program. The ideal candidate will play a key role in ensuring the organization’s data is organized, secure, and effectively leveraged for decision-making and innovation. 

---

### **Key Responsibilities:** 

#### **Data Architecture Design & Implementation** 

- Design and implement robust, scalable, and efficient data architectures to support current and future business requirements. 

- Develop and maintain conceptual, logical, and physical data models. 

- Ensure seamless integration of data from multiple sources into a unified structure. 

#### **Data Management & Optimization** 

- Establish and enforce data governance policies, including data quality, privacy, and security standards. 

- Optimize database systems and data pipelines for performance, reliability, and scalability. 

- Conduct data profiling, cleansing, and transformation activities to ensure data integrity. 

#### **Collaboration & Stakeholder Management** 

- Work closely with business stakeholders, analysts, and developers to gather data requirements and translate them into technical solutions. 

- Collaborate with IT and DevOps teams to deploy and manage databases and data solutions. 

- Provide guidance to data engineers, analysts, and other team members on best practices and architectural principles. 

#### **Technology Evaluation & Adoption** 

- Stay updated on emerging data technologies and recommend tools and platforms that align with business needs. 

- Evaluate, select, and implement data storage solutions (e.g., data lakes, data warehouses, cloud solutions). 

- Drive adoption of modern data architecture approaches such as event-driven architecture, real-time processing, or distributed data systems. 

#### **Documentation & Reporting** 

- Develop comprehensive documentation for data structures, processes, and architectural designs. 

- Provide regular updates to management on the status and performance of data systems. 

---

### **Required Qualifications:** 

- Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field with 12+ years of experience

- Proven experience as a Data Architect, Data Engineer, or similar role. 

- Expertise in database management systems (e.g., SQL Server, Oracle, PostgreSQL, MySQL). 

- Proficiency in data modeling tools (e.g., ER/Studio, Lucidchart) and techniques. 

- Hands-on experience with big data technologies (e.g., Hadoop, Spark) and cloud platforms (e.g., AWS, Azure, Google Cloud). 

- Strong understanding of ETL processes, data pipelines, and data integration. 

- Knowledge of data governance, security practices, and compliance standards (e.g., GDPR, HIPAA). 

- Familiarity with modern tools such as Snowflake, Kafka, or Apache Airflow is a plus. 

---

### **Key Competencies:** 

- Excellent analytical and problem-solving skills. 

- Strong communication and interpersonal skills for collaboration with technical and non-technical teams. 

- Ability to handle multiple projects and prioritize effectively. 

- A proactive approach to learning and adopting new technologies. 

---

### **Preferred Skills:** 

- Experience with machine learning frameworks or data science tools. 

- Familiarity with BI tools (e.g., Tableau, Power BI). 

- Certification in cloud or database technologies (e.g., AWS Data Analytics, Microsoft Azure Data Engineer). 

Exposure to AI and Salesforce are added advantage

---

**Join us to shape the data backbone of our organization and drive innovation through advanced data strategies!**

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