Eli Lilly and Company
Data Engineering Intern · Consumer Data Engineering, Business Insights & Analytics
- Defined AI-assisted development standards for BI&A's agentic data product initiative: standards that hold up in a regulated, Protected Health Information: any health data that can be tied to a person. Regulated under HIPAA in the US, so systems that touch it have strict rules about access, handling, and audit.-sensitive environment, with Writing a precise, reviewable specification of what a system should do before any code is written, then building (and having AI build) against that spec rather than against a conversation. at the core.
- Evaluated spec-driven development frameworks (Superpowers, GitHub Spec Kit, and the An open-source framework for AI-assisted software development. It gives AI agents defined roles (analyst, architect, developer, and so on) and structured workflows so they build from specs and stories rather than free-form prompts. Docs →) for enterprise fit and for fit with the team's existing day-to-day workflows, and made the recommendation the team adopted.
- Architected and built a BMad module for the team's A cloud platform for storing and processing large datasets, built around Apache Spark. Widely used for enterprise data engineering. data product pipeline, covering the full cycle: vendor intake, Comparing a new data source against the existing table structure to see what fits as-is and what needs a new column or table., spec generation, story creation, review, and User Acceptance Testing: the final check where the people who requested the work confirm it does what they asked, before it goes to production. sign-off. It replaced a manually maintained, non-version-controlled Excel source-to-target mapping with a human- and machine-readable spec that lives in Git, can be updated by AI, and holds transformation logic out by design, so the spec stays a stable interface between requirements and the downstream Extract, Transform, Load: the code that pulls data from a source, reshapes it, and writes it into the destination tables. implementation.
- Estimated by the team's leads to cut data product delivery time by two to four weeks, by catching mapping discrepancies at spec review rather than at UAT, where a catch sends the modeling team back through a full rework cycle.
- Built with BMad's own module-builder tooling; packaged, validated, and wrote cross-platform install scripts for macOS, Linux, and Windows. Delivered on a review branch as a working Minimum Viable Product: a first working version with the core functionality in place, built to be tested and extended rather than to be final. for the team to carry forward.
- Wrote and produced a narrated explainer for the module with Remotion and ElevenLabs, storyboarded across nine scenes with an automated layout audit so the design reference couldn't drift from the video.
- Worked on a globally distributed agile team of 20+ engineers, tracked in Jira, across roughly 11 vendor sources covering prescription claims, call records, and medication dispense history. Day-to-day in GitHub and Claude Code, with conventional commits and PR review throughout.