Bio

Hello! I’m Aaron Phaneuf - a husband and father of one. I am a self taught developer bordering on the title of ‘full stack’. I enjoy studying and tutoring mathematics, tinkering with my home server and electronics, coding, reading, and chess.

I have a history of establishing valuable processes and maintaining high standards of data integrity as well as a strong focus on building a solid foundation of reusable data tools and limiting the accumulation of data tech debt.

Skills

Python, Javascript, SQL, CSS, HTML, Django, Vue, Linux, Git, Docker, Nginx, Kubernetes, Proxmox

Applications: Excel, PowerBI, Looker Studio, Jaspersoft, ePlum, Financial Edge, Powerplan, Questica, Brightsign

Point-of-Sale Systems: ECRS, Tessitura, JS, Retalix, AM/PM

Experience

Marketing Analytics Specialist - The Calgary Zoo & Wilder Institute (2020 - Present)

Providing strategic counsel and tactical contributions to both internal and external marketing communications, responsible for developing and implementing effective, measurable strategies that support the goals of the Calgary Zoo. Responsibilities include:

  • Produced and communicated actionable data insights to drive and align with the business strategy, enhancing decision-making processes.
  • Ensured the accuracy and integrity of data across web and digital platforms, as well as within marketing and business development campaigns.
  • Tracked, measured, and reported on key performance indicators contributing to revenue generation and brand recognition.
  • Supported ongoing analysis of marketing programs, including post-campaign digital reports (email, influencer, social media, web).
  • Collaborated with IT and technical teams to define and automate regular tasks and reporting, increasing efficiency and reducing manual efforts.
  • Engaged and cooperated with multiple stakeholder groups across the organization, fostering a collaborative work environment.

Successes include:

  • Promoted from Analyst 1 to Analyst 2 and subsequently to Analyst 3, reflecting growth in responsibilities and expertise.
  • Developed comprehensive dashboards for the Marketing, IT, Education, and Concession teams, enhancing data accessibility and decision-making.
  • Accurately forecasted key portfolio KPIs, such as revenue and attendance, to support strategic planning.
  • Utilized SQL and Python for robust data collection and analysis, driving informed business insights.
  • Delivered detailed reports for executive and leadership teams, supporting high-level strategic decisions.
  • Successfully set up and managed events using the Tessitura point-of-sale system, ensuring smooth operations.
  • Played a key role in the creation and implementation of the auto-renewal program, improving customer retention and revenue stability.
  • Core team member in implementing dynamic pricing and reporting on its success.
  • Assisted in the setup of digital screens and maintained their functionality.
  • Transitioned from Universal Analytics to GA4, ensuring data integrity by backing up UA.
Database Implementation Specialist - Pomme Natural Market (Contract Position: Mar. 2020 - Jul. 2020)
  • Analyzed pricing between point-of-sale systems (and provinces) and suggested implementations.
  • Migrated data between databases.
  • Set up point‑of‑sale for use in‑store.
Pricing Manager - Planet Organic Market (2017 - 2020)

Responsible for leading a team in data entry of new listings, price updates, auditing, and database filing. Data analysis and manipulation skills used to develop a magnitude of custom reports compiling multiple sources of information. Successes include:

  • Automated time costly reports and database pulls.
  • Automated monthly promotions across 11 locations.
  • Developed Aisle Map to analytically map each locations sales, saving the cost of outsourcing.
Pricing Coordinator - Planet Organic Market (2011 - 2017)

Responsible for Data entry of new listings, price updates and database filing. Successes include:

  • Streamlined interoperability between point-of-sale systems.
  • Problem solving within the point-of-sale system.

Certifications

Data Analysis / Visualization

Coding

Networking and Cybersecurity

Education

Bachelor of Science - Mathematics - University of Athabasca, Alberta (2007)

Contact

aaron@phaneuf.me