Liam Blair Email & Phone Number

Working within a dynamic start-up, I led back-end development projects supporting frontend Tableau/native products.Developed ETL routines to sync data from aws s3 buckets, then push to postgres/redshift databases for dev/production frontends to reduce manual workload.Queuing ETL jobs in Linux terminal (cron) using redis queue and rq-scheduler.Develop projects in Python, adhering to industry best practices and leveraging containerization (Docker) for seamless deployment with unit testing.Operating within Linux (Ubuntu) environments, seamlessly navigating AWS services (including Redshift, S3, and AMC) to ensure optimal data management, complemented by adept utilization of ETL techniques.Design and implement Tableau dashboards to facilitate intuitive data visualization.

Responsible for developing and maintaining the Party BIs suit of Tableau reporting. Creating interactive and insightful reporting for non-technical users showing key business metricsResponsible for maintenance and development Python ETL processes to update and automate reporting refreshes using Tableau API.Providing key data integration and integrity services.Developing, maintaining and scheduling queries in Big Query, Google Analytics Platform via DeBeaver (Hive) and Teradata

Edinburgh, Scotland, United Kingdom

Responsible for facilitating, developing and streamlining the MI & Analytics team's reporting suiteLeading digital transformation strategies by driving the modernisation of the teams reporting solutionsEffective use of Python, VBA and SQL to drive efficiencies through automation and the removal of manual touch points Mentoring and developing junior teams members in technical skills such as VBA, SQL and Python

Led the modernisation of the Data and Analytics teams reporting suite from legacy sources to TableauUsing Tableau to create dynamic and insightful reporting connecting to MS SQL tables and other sources. To produce reports on key metrics such as customer satisfaction and agent performance measures.Effectively utilizing Python, Tableau and MS SQL to build, automate and provide clear and concise reporting. Using Python to streamline ETL processes and develop routines to monitor data issues and alert when data inaccuracies or missing data is encountered.

Advanced VBA programming within Microsoft Access and Excel. Maintenance and development of the Universal Sales Script (USS) tool (an Access based application) used to guide agents on the phone with customers to upsell products/services to customers.Liaise with compliance, script writing teams and other key stakeholders to ensure the USS tool is correctly updated following OFGEM regulations.Development of a number of other Access Applications to streamline business processes.

Provide insight to drive reduction in spending with suppliersDevelop KPI dashboards to track key business metricsAdvanced Excel and VBA programming: building user-orientated applications that automate a number of weekly, monthly reports.Engage with a number of teams and stakeholders during the development of reports to ensure needs are met and efficiencies in processes actualised.

Provide insight/reporting on performance of occupational services. Data extraction and reporting building with MS SQL/MS Access. Advanced Excel and VBA.Development of SLA and KPI report tracking to track important business metrics