Allied Technologies PLC
Junior Data Engineer
Contributed to the development of a centralized operational data warehouse designed to bring together sales, inventory, procurement, customer, and equipment-service data from multiple business systems.
My responsibilities included supporting Python-based ETL pipelines that extracted, validated, transformed, and loaded data from Excel files, relational databases, and other operational sources into SQL Server.
I also contributed to dimensional data modelling by helping define fact-table grain, dimensions, and relationships for analytical areas such as sales, inventory, procurement, and equipment servicing.
Through this work, I gained hands-on experience with data integration, ETL development, dimensional modeling, data validation, and SQL Server-based analytical workloads.