Data Engineer (Hybrid)

JOB OVERVIEW

The Data Engineer is responsible for ingesting diverse datasets—specifically converting complex JSON structures into high-quality, relational Gold-standard tables—to ensure accurate, timely, and actionable insights for the business.

• Data Architecture: Design and implement scalable data models, focusing on the transition from raw/bronze data to refined Silver and Gold standard datasets.
• Semantic Modelling: Design, validate and own Semantic Modelling to ensure models are optimised for End User Reporting
• Pipeline Development: Build and optimize ETL/ELT processes to ingest data from a variety of source systems, including ERP and CRM platforms.
• JSON Transformation: Engineer specific logic to parse, flatten, and transform nested JSON data into structured formats suitable for business reporting.
• System Migration: 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.
• Performance Tuning: Optimize SQL queries and Power Query transformations to ensure efficient data processing and refresh rates for Power BI Semantic Models.
• Data Integrity: Validate and monitor data quality throughout the pipeline to ensure that Gold-layer outputs are accurate and reliable for decision-making.
• Collaboration: Work closely with the BI team and business stakeholders

• Education: Relevant academic qualifications in Computer Science, Data Engineering, or a related quantitative field.
• Experience: 5+ years of experience in data engineering, with a demonstrable track record
• Advanced Technical Skills: Expert-level proficiency in SQL, Power Query and Python
• Platform Expertise: Extensive experience with Microsoft Fabric, including Lakehouses, Warehouses, and Power BI environments.
• JSON Specialist: Demonstrated mastery in transforming semi-structured JSON data into relational models.
• Strategic Modelling: Deep understanding of dimensional modelling (Star/Snowflake) and Medallion architecture principles.
• Problem Solving: Advanced ability to troubleshoot complex data discrepancies and optimize slow-running pipelines.

What's in It for You:

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

Ready to Make a Difference?

If you're ready to join a dynamic team and be part of something truly special, we want to hear from you! Apply directly on this job ad, and let's forge a brighter future together!

hammerjack is an equal-opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.