Senior Data Engineer

GCS Recruitment; Dublin; On-site; EUR 75,000 - 110,000; Full time

Job summary

GCS Recruitment is seeking a Senior Data Engineer in Dublin, hybrid role combining in-office and remote work. You will lead data solution design and delivery using Azure, building a data lake and data warehouse to support data science and business teams.

You will integrate data from IoT sensors, CRM, and billing systems, enabling advanced analytics and Power BI reporting. You will drive end-to-end data architecture, ensure security and HA/DR, and partner with stakeholders to translate complex

Qualifications

• 3+ years of data engineering experience with Azure or AWS
• Experience with Data Warehouse design using Kimball methodology
• ETL experience with SSIS and Azure Data Factory
• Hands-on with SQL Server, Azure Data Lake, and Data Warehousing
• Proficient in Power BI and DAX

Responsibilities

• Lead the design and delivery of data solutions using Azure services
• Build a scalable data platform enabling business growth and insights
• Gather and document technical requirements with stakeholders
• Improve standards, processes, and data workflow efficiency

Skills

Data modeling

Stakeholder communication

Requirements gathering

HA/DR design

Data security

Education

Bachelor's degree in CS/Engineering/Math/related field

Tools

Azure Data Factory

SSIS

SQL Server

Azure Data Lake

Azure Synapse

Databricks

Power BI

T-SQL

PowerShell

Azure API

Job description

Senior Data Engineer

Location: Dublin, Ireland (Hybrid - 3 days in office)

Employment Type: Full-Time

About Us

We're an innovative smart grid technology company building systems that connect and optimise energy assets as part of a Virtual Power Plant, helping accelerate the decarbonisation of the energy system. Our in-house software and hardware platform spans embedded controllers with rich sensor data collection deployed on customer sites, through to backend applications for control, automation, and data analytics - all the way to customer-facing visualisation and reporting tools.

We're a leader in the evolving smart grid space, offering Load Shifting, Demand Response, and Frequency Response services. As the electricity network evolves to intelligently balance producers and consumers of all sizes, we're building the technology to meet the needs of a fast-changing energy landscape - and growing our IT team to support the next stage of our growth.

The Role

We're looking for a Senior Data Engineer to join our Data and Analytics IT team. You'll work in an agile environment to build a Data Lake and Data Warehouse solution supporting our Data Science and Business Management teams - integrating data from external sources, IoT sensors across our install base, and business systems including CRM and billing.

This integrated data will power solutions for energy optimisation, energy trading, and predictive fault detection, as well as Power BI reporting for internal and external stakeholders. You'll play a key role in our Smart Grid Platform's evolution - from analysis and design through to implementation and delivery of industry-leading big data and data warehousing solutions, built on Azure's cloud services.

Ideally, you've taken projects through the full development lifecycle on Azure - from design through to production.

What You'll Do

• Lead the design and delivery of innovative data solutions using the latest Azure ecosystem services
• Apply industry best practices and your own experience to build a data platform that enables business growth
• Liaise with internal and external stakeholders to gather and document technical requirements
• Contribute ideas to strengthen standards and processes, and proactively look for ways to improve solutions and process efficiency

What You'll Bring

• 3+ years' professional experience, including 3+ years with Azure or AWS (Azure Data certification a plus)
• Experience with Data Warehouse design and the Kimball methodology
• ETL experience using SSIS and Azure Data Factory
• Hands‑on experience with SQL Server, SQL Data Warehouse, and Azure Data Lake
• Skill in SQL Server schema design and performance optimisation
• Python programming for data engineering and cleansing (Spark/Databricks experience a plus)
• Experience with Power BI and DAX
• Solid understanding of data security on Azure
• A proven ability to translate complex business requirements into scalable, resilient, end‑to‑end data system designs (HA/DR)
• Familiarity with: SQL Server, ETL design, Azure Data Lake, Azure Data Factory, Azure SQL Server, Azure Synapse
• Core languages: T-SQL, PowerShell, Azure API, DAX

Nice to Have

• Experience in the renewable energy sector
• A third‑level degree in Maths, Physics, Engineering, Computer Science, or a related field
• Commercial experience in data warehousing and business intelligence projects
• Experience with large, complex datasets across multiple languages (T-SQL, Python, R, etc.)
• Experience translating diverse business domains into dimensional designs for analytics and reporting
• Basic exposure to machine learning, data visualisation, or AI techniques, and experience collaborating with Data Science/ML teams
• Data governance experience