Data Analyst II, Supply Chain

About us

EWJ Technologies builds scheduling and dispatch software for field service companies, from two-truck plumbing outfits to regional HVAC contractors. Our main product is a payroll and timekeeping app for hourly workforces, sold by subscription and supported from Guadalajara. Laptops are MacBook Pros, and you pick your own editor.

The role

We are creating this position because the workload has grown. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. This role is fully remote within Mexico. We do not have many meetings. Most updates happen in writing. We use Slack, Notion and Google Meet. Cameras on for team calls.

Day to day

• Clean and reconcile data from CRM, ERP and spreadsheet sources.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Track sales, inventory or service levels against targets and flag misses early.
• Create forecasts and simple models in Excel or Google Sheets.
• Field ad hoc requests through a ticket queue and prioritise them with your manager.

About you

• 3+ years of experience in a data or reporting analyst role.
• Experience with at least one BI tool such as Tableau, Power BI or Looker.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Able to juggle several requests and say when a deadline isn't realistic.

Compensation and benefits

Rate: MXN 33,000-MXN 38,000 monthly

• Payment in USD.
• Training budget.

Please include your notice period and salary expectations.

Duration: 6 months. Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at EWJ Technologies.