Sign in

Data Analyst

Ottawa, Ontario, Canada
August 13, 2018

Contact this candidate


Liam Dodd

Tel: +447***-***-***

Email: L


A data analyst and Mathematics Masters graduate with an analytical and business focussed mind-set. Experience of working with award winning multi-national clients as well as building a data analysis function from scratch within a small business. Developed strong logical reasoning and critical thinking skills and gained a first class final year dissertation. Certified SQL programmer. Looking for a position based in analytics and business intelligence in a customer/client-centric environment. Permanent Resident of Canada. EMPLOYMENT HISTORY

Jun 17 – Jul 18 Deltra Recruitment Data Analyst

Deltra Recruitment is a niche supplier of project, programme and change professionals. Responsible for business intelligence and CRM analysis.

● Researched, selected and implemented a new CRM system, built on Microsoft Dynamics.

● Led the company’s GDPR strategy, from implementing a data retention policy to creating an automated process for candidates to request and receive their own data.

● Created a number of initiatives, increasing the number of logged activities and improving the accuracy of data.

o Calls up by 35-40% across the company due to personalised call lists being provided to consultants.

o Key data fields populated accurately at 75-180% above target due to gamification of admin tasks for consultants.

● Built live dashboards and automated reports, using T-SQL, SSIS, Excel and VBA, to enable managers and directors to make informed decisions on day to day activities and long term strategies regarding clients and consultants. o Developed tailored activity targets for consultants using correlation analysis and a linear regression model on prior activity and revenue generated.

● Sole member of technical staff so demonstrated autonomy and problem solving skills.

Nov 15 – Jun 17 Planning Inc Programmer

An award-winning agency delivering next-generation data marketing solutions. Clients included a multinational FTSE 100 retailer and an award-winning online casino.

● Responsible for developing and programming data-driven digital marketing campaigns, including maintaining the ETL process, using a number of programs such as SQL, SSIS, and Salesforce.

● Gathered requirements and managed expectations directly with clients.

● Created and maintained models to segment and target customers based on activity, value and behaviour.

Oct 14 – Oct 15 Deltra Recruitment Recruitment Consultant Deltra Recruitment is a niche supplier of project, programme and change professionals. Portfolio included clients from the Gaming and Betting industries.

● Established and maintained long term relationships with both clients and candidates.

● Researched current and prospective clients through interviewing candidates and meeting with contacts within the company.

● Coached candidates through the interview process. Nov 13 – Aug 14 Casual Work in Australia Various Roles

● Full time casual work across Australia as part of a year long working holiday, including Brisbane’s largest restaurant and a boutique winery in rural Western Australia.

May 13 – Oct 13 Sesui Customer Relationship Executive

● Built and maintained call routing trees for a varied client base including 112 emergency services and a large flight retailer.

● Dealt with sensitive information and also complied with legal requirements regarding response time to outages and relocations. Sep 12 – May 13 British Gas Business Customer Relationship Executive

● Front line of communication for a personal portfolio of over 1000 sites which involved managing all aspects of customers’ queries from initiation to completion.

● Knowledge of all teams and departments within a very large corporation which required strong interpersonal skills and an excellent telephone manner.

● Expected to comply with strict industry regulations involving the timescales of queries and the handling of complaints.

● Worked as a part of the “Strategic Broker” team, which involved working with and attending meetings with trained energy professionals from other organisations as well as members of the public.


2017 Microsoft Certification 70-461

● Querying Microsoft SQL Server 2012/2014

2008 – 2012 The University of Edinburgh

● MA (Hons) Mathematics and Philosophy, achieved 2:1 classification. 2001-2008 The Marlborough School, Woodstock

● A-levels: Mathematics (A), Further Mathematics (A), Chemistry (B), Physics (B)

● 10 GCSE’s (A-C)


● SQL Server – Intermediate

● SSIS – Intermediate

● VBA- Beginner

● Python – Beginner

● R – Beginner

● Azure - Beginner

● PowerBI - Beginner

Contact this candidate