Design and implement scalable data models, focusing on the transition from raw/bronze data to refined Silver and Gold standard datasets.
Design, validate and own Semantic Modelling to ensure models are optimised for End User Reporting.
Build and optimize ETL/ELT processes to ingest data from a variety of source systems, including ERP and CRM platforms.
Engineer specific logic to parse, flatten, and transform nested JSON data into structured formats suitable for business reporting.
Support ongoing data migration projects (such as "Project Harvest"), assisting in the transition of logic from legacy SQL environments to modern cloud platforms like Microsoft Fabric.
Optimize SQL queries and Power Query transformations to ensure efficient data processing and refresh rates for Power BI Semantic Models.
Validate and monitor data quality throughout the pipeline to ensure that Gold-layer outputs are accurate and reliable for decision-making.
Work closely with the BI team and business stakeholders.
Requirements
Relevant academic qualifications in Computer Science, Data Engineering, or a related quantitative field.
5+ years of experience in data engineering, with a demonstrable track record.
Expert-level proficiency in SQL, Power Query and Python.
Extensive experience with Microsoft Fabric, including Lakehouses, Warehouses, and Power BI environments.
Demonstrated mastery in transforming semi-structured JSON data into relational models.
Deep understanding of dimensional modelling (Star/Snowflake) and Medallion architecture principles.
Advanced ability to troubleshoot complex data discrepancies and optimize slow-running pipelines.
Tech Stack
Cloud
ERP
ETL
Python
SQL
Benefits
Flexibility : Work hybrid (remotely and from one of our inspiring offices) and enjoy a better work-life balance!
Inspiring Workspaces : Our offices are strategically located and designed to fuel your best work.
Free Unlimited Barista Coffee and Booze : Enjoy refreshments from our cafe and beverage bar.
Dynamic Open Spaces : Conducive for productivity and creativity.
State-of-the-Art Security : Ensuring your safety and peace of mind.
Game Rooms : Take a break and unwind with our recreational facilities.
Competitive Compensation : Your talents deserve to be rewarded! We help you negotiate with our clients.
Professional Growth : Access to ongoing training and development opportunities to help you reach your full potential.
A Supportive Community : Join a diverse and inclusive team that's dedicated to your success.
Global Impact : Be part of something bigger and make a difference on a global scale.