Richard O'Brien

Data Analyst — Jan 2020 - Present — BC Pension Corporation - Victoria, BC

Led the development of corporate and strategic dashboards for senior leadership and external stakeholders by working closely with various business areas to gather data, define metrics, visualize the data in Power BI, and gather feedback from demos.
Automated quarterly and annual Power BI reports by developing SQL queries to pull data from the data warehouse
Worked closely with the data warehouse team to identify and reconcile data quality issues in reports
Supported the development of a self-service data platform by presenting Power BI and data warehouse content aimed at developing our community of practice’s knowledge of the tool across the organization.
Used Agile and DevOps to continuously develop and improve the reporting capabilities of the analytics team
Used organizational tools (e.g., JIRA & SNOW, Gantt Charts, Kanban) to manage client requests, standard reports, and organizational goals throughout the year.
Provided advice and recommendations to senior staff who were developing their first Power BI dashboards.

Data Analyst — Mar 2018 - Jan 2020 — Ministry of Advanced Education - Labour Market Information Office - Victoria, BC

Built and put 73 industry forecasting models into production using R. These forecasting models were used in combination with an existing macro economic forecasting model.
Worked closely with senior management to develop and design the first public facing Tableau dashboard that allowed the public to find occupations that would be in high demand. Currently, this dashboard has over 29,000 views.
Designed and led the automation of economic products using R, Python, and SQL, ensuring that these products could be reproduced on a regular basis and scaled up in the future.
Analyzed economic data from Statistics Canada to produce dashboards displaying BC’s economic performance.
Supported requests for data in a timely manner and promoted products within the division.
Developed a system for reproducible research and collaborated with colleagues and stakeholders to improve the quality and timeliness of the products being delivered.

Data Analyst — Jan 2018 - Mar 2018 — Key Rehab Services Inc. - Kitchener, ON

Built and automated a procedure to generate a time series dataset from unstructured behavioural data using R.
Provided advice and recommendations to senior management on how to best visualize the data and present it for non-technical audiences.
Quantified changes in clients behaviour using time series data and generated visualizations for reports used to substantiate legal claims.
Developed an understanding how the collection methodology influenced accuracy of results, and flagged errors in data collection that needed further investigation.
Improved the quality of client services by pinpointing clients behaviours that may require intervention through data visualization and statistics. .

Data Analyst — Oct 2016 - Jan 2018 — Balance Assessment Tool, University of Waterloo - Waterloo, ON

Managed and developed data analysis procedure for a research project assessing balance using accelerometers.
Reported and presented processed data through visualization tools and statistics in R.
Investigated and compared the use of advanced statistical models to enhance the accuracy of our findings using R.

Director on the Board of Directors — May 2017 - Mar 2018 — Graduate Student Association - University of Waterloo, Waterloo, ON

Worked with colleagues to provide responsible governance of the organization.
Collaborated with colleagues to shift the organization to a new governance model that was designed to improve the quality of services and make greater use of limited resources.
Develop strategies and collaborated with stakeholders and service providers to enhance brand awareness and organizational services.
Assist with the development of financial budgets and policy reviews and implementations.

Undergraduate/Graduate Researcher — Sept 2014 - Present — University of Waterloo - Waterloo, ON

Led and developed hypotheses, research methodologies, and SOPs for ethical review.
Collected and organized data using qualitative and quantitative tools and surveys.
Outlineed, documented, programmed, and reviewed statistical analysis procedure.
Assisted in the development of course curriculums.
Learnt how to use psychological research equipment, including electrodes, amplifiers, accelerometers, and EEG caps.
Taught a mini-lecture series specifically designed around programming and statistical analysis at the graduate level.
Conducted literature reviews and wrote research reports.

Education — Masters of Science: Neuroscience
2016 – Present — University of Waterloo, Waterloo, ON

Bachelor of Arts: Honours Psychology
2014 – 2016 — University of Waterloo, Waterloo, ON

Bachelor of Arts: Liberal Arts
2010 – 2013 — University of Waterloo, Waterloo, ON