Analytics Engineer

Analytics Engineer — AAH Pharmaceuticals

(Sep 2024 – Present)

After a year as Analytics Developer, I moved into a dedicated engineering role — one that let me go deeper into the data platform and take more ownership of the architecture underneath it all.

The shift was a natural one. I wanted to move beyond supporting analysts and start building the foundations they rely on. It also meant working more formally within sprint-based delivery via Jira and version control through Git, which brought a lot more structure to how work gets shipped.

Key things I've worked on:

• Supported the migration and validation of data off expensive legacy systems into our Azure environment. The licensing savings were significant.

• Built Databricks ETL pipelines for the pricing team, covering hundreds of products, with error logging and email notifications built in. What used to take hours now runs in minutes.

• Converted Excel-based business processes into ADF pipelines and Databricks notebooks, creating a single source of truth in Azure SQL that analysts can actually rely on.

• Rebuilt old R-script ETLs using modern Databricks tooling, and went through colleagues' notebooks to improve documentation and readability, which paid off whenever something broke.

• Built pipelines to ingest public data via APIs and scraping, combining it with internal sources for client reporting solutions they could subscribe to.

• Attended a data conference and presented findings internally to help senior stakeholders understand the AI landscape and build the case for investment in data readiness.