Insight Analyst

We process billions of card transactions a year for merchants, banks and software platforms. Since 1924, the firm has grown through acquisitions of independent advisory practices. Most staff have been with the firm for more than eight years.

About the role

Our team is growing and we are hiring an Insight Analyst. 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. You'll own a set of dashboards and the data behind them, and be the go-to person when someone asks why a number looks off. Remote position. Most of the team is in Auckland, but nobody is required to come in. Normal working hours, Monday to Friday. We use Slack, Notion and Google Meet. Cameras on for team calls.

Day to day

• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language
• Field ad hoc requests through a ticket queue and prioritise them with your manager
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Investigate data quality issues and work with data engineering to fix them at the source
• Prepare weekly and monthly KPI reports for department leads
• Support A/B test readouts with basic statistical checks
• Track sales, inventory or service levels against targets and flag misses early
• Clean and reconcile data from CRM, ERP and spreadsheet sources

Qualifications

• 3+ years of experience in a data or reporting analyst role
• Strong SQL (joins, CTEs, aggregations, window functions)
• Bachelor's degree in statistics, economics, business, math or a related field
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Habit of checking your own numbers before anyone else sees them
• Able to juggle several requests and say when a deadline isn't realistic
• Basic statistics: averages vs. medians, distributions, significance

Pay: $74,000 to $96,000 pa

Why work with us

• Health insurance
• KiwiSaver contributions
• Five weeks annual leave after the first year
• Employee assistance programme
• Annual bonus

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at EJC Asset Management.