Analytics and Automations Engineer - Supply & Demand, Scommerce

Hammerjack Pty Ltd; Philippines; On-site; PHP 400,000 - 700,000; Full time

Job summary

Hammerjack Pty Ltd is seeking a data/analytics professional in the Philippines to build and maintain SQL- and Python-based solutions that automate reporting and workflows. You will design dashboards, improve data quality, and monitor KPIs to drive visibility for operations and business teams.

The role requires 2-3 years of experience, a quantitative degree, and a proven track record of creating internal tools and automations to solve real-world problems.

Qualifications

• Bachelor's degree in Engineering, Computer Science, IT, Analytics, Economics, or related quantitative field.
• 2-3 years of professional work experience.
• Proven track record of building automations, scripts, or internal dashboards that solve real-world business problems.
• Experience working in ambiguous or fast-changing environment.

Responsibilities

• Build and maintain SQL- and Python-based solutions to drive reporting and automation.
• Identify and execute opportunities to automate repetitive workflows and manual tasks.
• Develop and refine scripts and internal tools to reduce manual data intervention.
• Design and deploy dashboards and trackers for single source of truth visibility for operational and business teams.
• Audit and improve data quality and reporting clarity across funnel stages (sourcing, onboarding, activation).
• Monitor performance KPIs through robust reporting infrastructure.
• Translate ambiguous business problems into structured technical requirements for reporting or automation.
• Design scalable workflows balancing speed and accuracy for high-impact results.
• Maintain a clear-headed approach to address long-term organizational goals.
• Partner with Operations, Commercial, BI, and other stakeholders to resolve blockers and improve funnel performance.
• Investigate root causes of issues to improve systems beyond symptoms.
• Communicate complex technical concepts simply to align on priorities.

Skills

SQL

Python

Excel/Sheets

Data fundamentals

Strategic communication

Ownership mindset

Education

Bachelor's degree in quantitative field

Job description

Job Description:

Solution Development & Automation

• Build and maintain sophisticated SQL- and Python-based solutions to drive departmental reporting and automation.
• Identify and execute high-impact opportunities to automate repetitive workflows and manual operational tasks.
• Develop and refine scripts and internal tools to reduce organizational dependency on manual data intervention.

Analytics & Visibility

• Design and deploy advanced dashboards and trackers to provide single source of truth visibility for operational and business teams.
• Audit and improve data quality and reporting clarity, ensuring that metrics across the funnel-including sourcing, onboarding, and activation stages-are actionable.
• Monitor performance KPIs through a robust and reliable reporting infrastructure.

Process Optimization & Strategy

• Translate ambiguous, messy business problems into structured technical requirements for reporting or automation.
• Design scalable, long-term workflows that balance speed and accuracy to deliver high-impact results.
• Maintain a clear-headed approach under pressure to ensure technical solutions address long-term organizational goals rather than short-term fixes.

Cross-Functional Collaboration & Root Cause Analysis

• Partner with Operations, Commercial, BI, and other cross-functional stakeholders to resolve operational blockers and improve funnel performance.
• Investigate and resolve the underlying root causes of operational issues, moving beyond merely reporting symptoms to proactively improving systems.
• Communicate complex technical concepts simply and effectively to diverse stakeholders to align on priorities and deliverables.

Requirements:

Educational Background & Experiences:

• Bachelor's degree in Engineering, Computer Science, IT, Analytics, Economics, or related quantitative field
• 2-3 years of professional work experience
• Proven track record of building automations, scripts, or internal dashboards that solve real-world business problems
• Experience working in ambiguous or fast-changing environment
  

Knowledge and Skills:

• Advanced SQL: Proficiency in complex data extraction and validation to transform unstructured data into clean, actionable reporting.
• Python: Working knowledge for developing end-to-end automation, reporting, and data workflows.
• Data Fundamentals: Strong mastery of Excel and Google Sheets for rapid prototyping and data management.
• Strategic Communication: Ability to interface with diverse stakeholders and translate technical outputs into business value
• Mindset: Highly self-driven, execution-focused, and possessing a strong ownership mindset to operate independently with minimal instruction.
  

Preferred but not required:

• Experience in Operations, Logistics, E-commerce, BI, or Startups