Julian Leiro
About Julian Leiro
Julian Leiro is a Senior Data Analyst at Viking Cruises, with a background in business and data analysis across various industries.
Current Role at Viking Cruises
Julian Leiro holds the position of Senior Data Analyst at Viking Cruises. In this role, he leverages his expertise in developing time series forecasting models to predict inventory and revenue for Viking Cruises' various products, including cruise, air, and hotel extensions. Julian's responsibilities include implementing SQL Server solutions to optimize ETL processes for data modeling. He also creates SSRS reports to assist the Trade Sales team and designs stored procedures for reassignment of guests based on specific booking criteria.
Past Experience at Viking Cruises
Before his current role, Julian worked as a Yield Management Analyst at Viking Cruises from 2018 to 2021 in Woodland Hills, California. During this period, he conducted ad-hoc quantitative analyses to support multiple departments such as Yield Management, Trade Sales, FP&A, Product, Air, and Marketing. His work included complex data analysis and model building to enhance business strategies and decision-making processes.
Previous Positions
Julian Leiro has held various analytical roles throughout his career. He served as a Business Analyst at SoCalGas from 2017 to 2018 in the Greater Los Angeles Area. Prior to that, he was a Business Data Analyst at the Natural History Museum of Utah from 2016 to 2017. Julian has also worked as a Research Assistant at Five Acres—The Boy's and Girl's Aid Society of Los Angeles from 2013 to 2015. Earlier, he was an Undergraduate Research Assistant at the University of San Diego from 2011 to 2013.
Educational Background
Julian earned a Master's Degree in Statistics from the University of Utah, where he studied from 2016 to 2017. Before that, he completed a Bachelor of Arts at the University of San Diego, majoring in Psychology and Philosophy between 2009 and 2013. His advanced education has equipped him with a thorough understanding of statistical methods and analytical techniques, which he applies in his professional roles.
Technical Skills and Contributions
In his role at Viking Cruises, Julian has implemented various technical solutions including SQL Server tables, views, and stored procedures that streamline ETL processes essential for data modeling. He has been instrumental in creating SSRS reports to help the Trade Sales team and designing stored procedures aimed at reassigning guests from canceled cruises to new sailings based on preset booking criteria. Julian's technical contributions are pivotal in maintaining operational efficiency and enhancing decision-making capabilities at Viking Cruises.