Ross is available for hire
Hire RossRoss Loggie
Verified Expert in Engineering
Software Developer
Location
Edinburgh, United Kingdom
Toptal Member Since
March 15, 2021
Ross is a highly skilled database developer and data engineer with years of experience working on a wide range of projects, from small-scale to enterprise-level clients. A quick learner and excellent communicator, Ross prides himself on building strong client relationships and exceeding expectations.
Portfolio
Self-employed
SQL, PL/SQL, Python, Terraform, Amazon, Azure DevOps, Azure...
Baillie Gifford
Oracle, SQL, PL/SQL, C#, Kubernetes, Agile, Scrum, Git, Test Automation...
Inoapps
Oracle, SQL, Oracle PL/SQL, Regex, Oracle Application Express (APEX)
Experience
Availability
Full-time
Preferred Environment
Oracle, SQL, Oracle PL/SQL, PostgreSQL, Python, Bash, Snowflake, CI/CD Pipelines, Kubernetes, Cloud
The most amazing...
...thing I've developed is a data warehouse with comprehensive automated testing to transform the way a finance company used and interacted with their data.
Work Experience
Lead Data Engineer
2017 - PRESENT
Self-employed
- Designed and led a complex recommendations generation back end for an established medical business using MySQL, Snowflake, and Python for ingesting, transforming, and presenting terabytes of data. The product was recently acquired by a multinational.
- Built a complex back end in PostgreSQL and PL/pgSQL to calculate carbon emissions and feed the front end for a carbon emissions measurement and tracking startup.
- Managed an Aurora PostgreSQL database ingesting millions of records daily from blockchain, ETL to Amazon Redshift, and ClickHouse data lakes for BI/ML consumption using Kafka, Debezium, and Python lambdas for a Web3 startup.
- Migrated a large Microsoft SQL Server database to Aurora PostgreSQL for an enterprise client using AWS Database Migration Service (DMS), which involved rewriting (automated, where possible) and tuning thousands of stored procedures.
- Co-developed an ETL solution for a large multinational retail company that dynamically built a database environment based on a template, iterated through workflows calling hundreds of stored procedures, and exported results as files and a database.
- Developed a chemical safety application with an Oracle database back end and Oracle APEX front end, which allowed companies to download safety data sheets and send lists of products via the API to the website.
- Mentored several clients in SQL, PL/SQL, and Oracle APEX over hundreds of hours, from basics to advanced topics. Received excellent feedback from them all.
Technologies: SQL, PL/SQL, Python, Terraform, Amazon, Azure DevOps, Azure, Amazon Web Services (AWS), Azure DevOps Services, Snowflake, PostgreSQL, Oracle, Mentorship, Databases, Oracle Application Express (APEX), Apache Kafka, Apache Airflow, ETL, Git
Senior Data Engineer
2019 - 2024
Baillie Gifford
- Led Snowflake platform setup as part of data mesh implementation for developers and key stakeholders, using Terraform, dbt, and Airflow.
- Led a complex release automation project using Azure DevOps pipelines with Python, Docker, Bash, and Kubernetes. Built an application for testing releases in Oracle APEX to improve development workflow and reduce errors.
- Automated database provisioning, database refreshes, cloning, and data masking, improving developer efficiency.
- Created a data warehouse that ingested data from many sources to be used internally across the business and externally for reporting. Worked on the full lifecycle from conception through design and development to the finished solution.
- Worked closely with accountants on complex regulatory reporting requirements. Participated in regular meetings to gather requirements and discuss progress. Generated an Excel spreadsheet with hundreds of attributes that were calculated using PL/SQL.
- Worked in an Agile environment across multiple projects; participated in and led retrospectives, stand-ups, and other scrum-related meetings.
- Developed relationships with many business users to ensure their needs were met and the information needed could be gathered. Prepared documentation for thorough data governance sign-offs.
Technologies: Oracle, SQL, PL/SQL, C#, Kubernetes, Agile, Scrum, Git, Test Automation, Data Warehouse Design, Data Warehousing, Oracle SQL, Oracle PL/SQL, Data Modeling, Python, Docker, CI/CD Pipelines, Snowflake, Data Build Tool (dbt), PL/SQL Tuning, Unix Shell Scripting
Software Developer
2017 - 2019
Inoapps
- Served as a lead developer on time, writing an application in Oracle APEX that integrated with Oracle Fusion to allow a large oil and gas company to input timesheets across hundreds of projects. Worked directly with the client on-site in America.
- Worked on complex data transformation routines written in PL/SQL for many clients across the construction, oil and gas, and retail industries. Integrated with many vendor systems and Oracle Fusion.
- Developed an ETL routine to pull data out of Primavera and send it to Oracle Fusion for a large oil and gas client dealing with high volumes of data.
Technologies: Oracle, SQL, Oracle PL/SQL, Regex, Oracle Application Express (APEX)
Experience
Consumer Ratings/Review App for an International Beauty Company
An application that I designed and built for an international beauty company that allowed their users to advertise their business, post links to their products and services, and review others'. It included a comprehensive search page for finding articles and saving preferences/searches, a moderation section, an article creation section, and a profile section.
There was a separate application for admins to log in and create and add lookup data, administer users, and various other tasks. There was an integration with the Mailjet API to send emails to users for account verification and marketing. I made use of the Mailjet webhooks to gather statistics on user interaction.
The application was hosted on Oracle Cloud using an autonomous database, with all logic written in PL/SQL. The front end was built using the Oracle APEX framework. Logging in was done with Google Sign-In for the consumer application and a custom authentication scheme for the admin application.
There was a separate application for admins to log in and create and add lookup data, administer users, and various other tasks. There was an integration with the Mailjet API to send emails to users for account verification and marketing. I made use of the Mailjet webhooks to gather statistics on user interaction.
The application was hosted on Oracle Cloud using an autonomous database, with all logic written in PL/SQL. The front end was built using the Oracle APEX framework. Logging in was done with Google Sign-In for the consumer application and a custom authentication scheme for the admin application.
PostgreSQL
Participated in a migration from Microsoft SQL Server to PostgreSQL (Amazon Aurora) for an enterprise-level client in the financial services sector. I transformed thousands of objects, including functions, stored procedures, and triggers, and tuned many of these to improve performance.
I engaged in several other Amazon Aurora and RDS PostgreSQL projects, providing data modeling advice, indexing and query optimization, and general configuration expertise.
I engaged in several other Amazon Aurora and RDS PostgreSQL projects, providing data modeling advice, indexing and query optimization, and general configuration expertise.
Skillset
Languages
SQL, Regex, Python, Snowflake, C#, JavaScript, Bash
Tools
Oracle Application Express (APEX), Git, Terraform, Azure DevOps Services, Apache Airflow
Paradigms
Database Design, ETL, Azure DevOps, Agile, Scrum, Test Automation, REST
Platforms
Oracle, Oracle Database, Windows, Linux, Kubernetes, Docker, Amazon Web Services (AWS), Apache Kafka, Amazon, Azure
Storage
Oracle PL/SQL, PL/SQL, MySQL, PostgreSQL, Database Security, Database Architecture, Oracle SQL, Databases, Amazon Aurora, Oracle Cloud, Database Administration (DBA), Attunity Replicate, JSON, Redshift, ClickHouse, MongoDB
Other
Oracle REST Data Services (ORDS), Query Optimization, PL/SQL Tuning, Mentorship, Data Warehousing, Data Modeling, Data Architecture, Data Warehouse Design, CI/CD Pipelines, Cloud, Data Engineering, Data Build Tool (dbt), Unix Shell Scripting
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring