Sam Mccomb Email & Phone Number

Belfast, Northern Ireland, United Kingdom

As a Data Engineer at Mintel, I design, implement, and optimise scalable data pipelines using Snowflake and DBT, supporting data-driven decision-making and enhancing business intelligence.𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀 & 𝗔𝗰𝗵𝗶𝗲𝘃𝗲𝗺𝗲𝗻𝘁𝘀:• 𝗘𝗧𝗟/𝗘𝗟𝗧 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: Assisted in building and maintaining efficient ETL/ELT pipelines in Snowflake, improving data accessibility for analytics teams.• 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 & 𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: Worked with DBT to automate data transformations, streamlining workflows and increasing efficiency for the analytics team.• 𝗖𝗼𝗹𝗹𝗮𝗯𝗼𝗿𝗮𝘁𝗶𝘃𝗲 𝗗𝗮𝘁𝗮 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Contributed to the integration of diverse data sources into Snowflake, ensuring real-time data syncing and accuracy across the business.• 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗧𝘂𝗻𝗶𝗻𝗴: Assisted in optimising Snowflake queries and data workflows to enhance system performance and reduce data retrieval times.• 𝗖𝗜/𝗖𝗗 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Contributed to the integration of CI/CD practices for automating deployments of data pipelines, reducing manual intervention and improving deployment consistency.• 𝗖𝗿𝗼𝘀𝘀-𝗧𝗲𝗮𝗺 𝗖𝗼𝗹𝗹𝗮𝗯𝗼𝗿𝗮𝘁𝗶𝗼𝗻: Collaborated closely with data scientists, analysts, and other business units to ensure that data solutions met their requirements and business objectives.• 𝗖𝗼𝗻𝘁𝗶𝗻𝘂𝗼𝘂𝘀 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 & 𝗜𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁: Proactively expanded my knowledge of cloud technologies and data engineering best practices, applying new skills to improve data pipelines and workflows.• 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻𝘀: Played a key role in data migration and integration projects, helping to consolidate and streamline the company’s data infrastructure.

Northern Ireland Water (NIW) is the government-owned entity responsible for water and wastewater services in Northern Ireland, ensuring the provision of clean water and efficient sewage treatment for residents and businesses.Roles and Responsibilities:As NIW's System Administrator, I managed critical systems (Oracle Spatial data warehouse, Ellipse, BUDI stack, FME, and ESRI Enterprise GIS), engaging stakeholders to design, build, and maintain applications for optimal asset data utilisation. Conducted intricate data analysis using GIS and MS Office.• Orchestrated seamless data integration, optimizing workflows for heightened efficiency.Applied spatial modelling and geospatial analytics for actionable insights in strategic decision-making.• Implemented robust data quality assurance, ensuring dataset accuracy and reliability.• Led scalable database design, translating business needs into effective solutions.• Engineered end-to-end data pipelines, automating processes for real-time information accessibility.Key Achievements:• Pioneered NIW's first digital lands dataset, offering insights into carbon capture.(Data engineering, multiple data sources, FME, Esri Enterprise stack)• Developed Oracle APEX application, saving time on repetitive data extracts.(SQL)• Designed a web app using ESRI Enterprise and FME, automating external queries and improving response times by 30%.• Automated Supply Zone Boundaries creation, reducing task duration from two weeks to two days.(SQL, Python, FME, ESRI stack)• Implemented Developer Services workflow, saving 15 minutes per query and eliminating waiting times. • Enhanced Pressured Metered Areas data quality through FME and Oracle automation.• Created various Python scripts for workflow automation, data analysis, and publishing.

Roles and Responsibilities:• Working with established procedures, performing quality control andmonitoring data accuracy by evaluating, updating and maintainingwater and wastewater, infrastructure and non-infrastructure assetdata in the CAR using custom editor applications• Interpret complex information from various data formats (e.g., civilengineering drawings, asset data return forms, MapInfo tables andBUDI files)• Management of critical datasets, which cascade across businesssystems to aid in financial, operational and strategic decision-making.• Assess the integrity and quality of asset data returns against Code ofPractice standards and feedback issues with the quality of datareturns to the Data Supplier

Ballymena, Northern Ireland, United Kingdom

Master Of Science - Msc, Geographic Information Systems

Bachelor Of Science - Bs, Geography

Activities and Societies: Rugby