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.

• 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.
• 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)

• 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.
• 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