hammerjack

Data Engineer

hammerjack

full-time

Posted on:

Location Type: Hybrid

Location: Makati City • Philippines

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

CloudERPETLPythonSQL

About the role

  • 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.
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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPower QueryPythonETLELTdata modelingdata migrationdata quality validationdimensional modelingJSON transformation
Soft Skills
troubleshootingcollaborationcommunicationproblem-solvinganalytical thinking