We’re looking for people who are determined to make life better for people around the world.
Eli Lilly Services India Pvt Ltd
Business Insights & Analytics – First Party Data : Data Engineer
As Eli Lilly strives to achieve its purpose of making life better for patients, we have been building up our in-house ‘Consumer Experience’ function, which will design and execute next-generation marketing campaigns aimed at informing and educating consumers (or patients) directly.
To support the Consumer marketing teams in their decision-making, a data and analytics team has been set up in Indianapolis (HQ) and Bengaluru (LCCI). This team uses works closely with business stakeholders to enable them to make more informed,
data driven decisions. A key area of expansion for the team in 2024 is to help facilitate the implementation of a CDP (customer data platform). As part of this team, we are excited to offer the role of a data engineer who will be an integral part of the implementation and scaling of this CDP.
Create and maintain optimal data pipeline architecture ETL/ ELT into structured data Assemble large, complex data sets that meet business requirements and create and maintain multi-dimensional modelling like Star Schema and Snowflake Schema, normalization, de-normalization, joining of datasets. Expert level experience creating Fact tables, Dimensional tables and ingest datasets into cloud based tools. Identify, design, and implement internal process improvements including automating manual processes, optimizing data delivery and re-designing infrastructure for greater scalability. Setup and maintain data ingestion, streaming, scheduling, and job monitoring automation. Connectivity between Lambda, Glue,
S3, Redshift, Power BI needs to be maintained for uninterrupted automation. Build analytics tools that utilize the data pipeline to provide actionable insight into customer acquisition, operational efficiency, and other key business performance metrics. Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs. Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader Collaborate with the CDP team to ensure seamless data integration into the CDP. Ensure data privacy and compliance with relevant regulations (e.g., GDPR) when handling customer data. Maintain data quality and consistency within the CDP,
addressing data-related issues as they arise.
2-6 years of relevant experience Proven experience working with Customer Data Platforms (CDP) or Data Management Platform (DMP) or CRM tool is preferred. Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases and Cloud Data warehouse like AWS Redshift Data Model development, additional Dims and Facts creation and creating views and procedures, enable programmability to facilitate Automation. Data compression into PARQUET to improve processing and finetuning SQL programming skills required. Experience building and optimizing “big data” data pipelines, architectures and data sets.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with structured and unstructured datasets. Working knowledge of message queuing, stream processing, and highly scalable “big data” stores. Experience supporting and working with cross-functional teams and Global IT. Familiarity of working in an agile based working models.
Experience with relational SQL and NoSQL databases, especially AWS Redshift. Experience with AWS cloud services Preferable: S3, EC2, Lambda, Glue, EMR, RDS highly preferred.
Experience with similar services on another platform would also be considered. Experience with stream-processing systems: Storm, Spark-Streaming, etc.
Bachelor’s or master’s degree on Technology and Computer Science background
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.
▶️ Data Engineer – 1st Party Data