Junior Data Analyst

Advisors, operations, compliance and technology teams total roughly 310 people.

About the role:

We are backfilling a position after an internal move. 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 can work from home anywhere in Australia. We have no office requirement. Standard office hours, Monday to Friday, with flexibility around them. Strong written English is important, since much of our work is async.

Essential duties and responsibilities:

• Create forecasts and simple models in Excel or Google Sheets.
• Present results to managers and answer follow-up questions.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.
• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language.

What you need:

• 1+ years of experience in a data or reporting analyst role.
• Basic statistics: averages vs. medians, distributions, significance.
• Clear written and verbal communication with non-technical stakeholders.
• Bachelor's degree in statistics, economics, business, math or a related field.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Advanced Excel: pivot tables, XLOOKUP, Power Query.

Preferred:

• Dbt or Snowflake.
• Tableau Desktop Specialist or Microsoft PL-300 certification.
• Industry background in retail, healthcare or logistics.
• Google Analytics 4 or Adobe Analytics.

Benefits:

• Superannuation on top of salary.
• Study leave.
• Flexible hours.
• Employee assistance program.

Start: Within 30 days.

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