Design, develop, and maintain reliable and scalable data pipelines, including ETL/ELT processes, using Ab Initio for development, workflow orchestration and automation.
Responsibilities
Design, develop, and maintain reliable and scalable data pipelines, including ETL/ELT processes, using Ab Initio for development, workflow orchestration and automation.
Document ETL processes and ensure compliance with company standards.
Participate in code reviews and ensure best practices are consistently followed.
Integrate data from multiple internal and external sources, ensuring efficient and secure data provisioning.
Design and maintain logical and physical data models in collaboration with Data Analysts and Data Architects.
Collaborate with business stakeholders to understand business needs and translate them into clear functional and non-functional requirements and technical solutions.
Design, develop, and maintain data models, data mappings, and transformation logic to enable seamless integration between source and target systems.
Build, test, and maintain ETL/ELT processes and data pipelines on AWS, ensuring data accuracy, reliability, and timely availability.
Develop and optimize SQL queries for data analysis, validation, and troubleshooting across relational databases.
Leverage Python to process, validate, query, and automate data workflows.
Lead end-to-end data operations for patient services, copay and affordability programs, specialty pharmacy, hubs, patient engagement, and related commercial data domains.
Responsibilities
Lead end-to-end data operations for patient services, copay and affordability programs, specialty pharmacy, hubs, patient engagement, and related commercial data domains.
Lead technical workstreams and deliver high-quality technical outputs for complex projects and programs.
Define and validate methods, document results and key assumptions, ensure adherence to applicable standards and controls, and communicate technical progress, impacts, risks, and recommended mitigations to project leads and stakeholders.
Oversee onboarding, validation, reconciliation, monitoring, and delivery of internal and external data sources.
Implement and monitor data lifecycle and quality processes to maintain data accuracy and consistency.
Requirements
Bachelor's degree in Information Systems, Data Management, Computer Science, Engineering, Business Analytics, Healthcare Administration, or a related field
Nice to have: advanced degree
Nice to have: Pharmaceutical or life sciences industry experience
Lead the strategy, roadmap, and delivery of the LillyDirect Pharmacy Covered Entity Data Hub, bridging business, engineering, and compliance teams to deliver secure, scalable, and compliant pharmacy and healthcare data products.
Compensation
$129,000 - $189,200
Responsibilities
Own and lead the product vision, strategy, and roadmap for the LillyDirect Pharmacy Covered Entity Data Hub
Partner with business stakeholders to translate business goals into actionable product capabilities and technical requirements
Define quarterly and annual roadmaps aligned with business priorities, regulatory requirements, and enterprise data strategy
Prioritize initiatives, features, and technical debt using a value-driven approach
Maintain and prioritize the product backlog within Jira
Requirements
Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, Healthcare Informatics, or related field
Seeking a hands-on Senior Data Platform Engineer to build and scale enterprise data services centered on SingleStore Helios and PostgreSQL, combining database architecture with production engineering and data pipeline development.
Compensation
The base pay for this role is expected to be between $180,000 and $250,000. The expected base pay range is based on information at the time this post was generated. This role may also be eligible for other forms of compensation such as a performance bonus and a competitive benefits package.
Responsibilities
Design, develop and optimize SingleStore and PostgreSQL schemas, SQL queries, physical data models, indexing and workload performance.
Build and maintain reliable batch, streaming and CDC ingestion pipelines from relational databases, object storage and other enterprise sources.
Lead technical assessments and migrations of existing applications and data workloads to SingleStore.
Build reusable self-service onboarding capabilities, including APIs, configuration templates, automated provisioning, and pipeline deployment.
Optimize cloud database spend through workload right-sizing, consolidation, scheduling and performance tuning.
Senior Integration Engineer responsible for designing, developing, testing, maintaining, and troubleshooting data integration and EDI solutions on the Platform Products & Services team.
Responsibilities
Design and develop data integration solutions using Boomi, Sterling Commerce EDI, AWS, and Snowflake
Configure middleware components and build reliable data pipelines
Gather business requirements and translate into technical specifications
Conduct code reviews and ensure software quality
Provide technical support and maintenance for existing integrations
Requirements
Four-year college degree in Computer Science, Information Systems, Engineering, or a related field