Senior BI Analyst

BlackBull Markets; Auckland; Vor Ort; NZD 120.000 - 180.000; Vollzeit

Zusammenfassung

BlackBull Group in Auckland is seeking a senior data analyst to join the core analytics team. You will report to the CIO and work with the CEO/COO, producing insights used to run the business and partnering with the Data Engineering Lead on reporting datasets.

You will analyse revenue, profitability, trading activity and client behaviour, build dashboards and run recurring reports using SQL, Excel and BI tools, and validate metrics for senior leadership. Experience with Claude AI tools is a plus.

Qualifikationen

• 5+ years in data analysis or BI.
• Advanced SQL: joins, CTEs and window functions.
• Hands-on dbt with production models, tests and docs.
• Strong Excel and BI skills (Power BI/Tableau).
• Experience with a cloud data warehouse.
• Hands-on Claude or similar AI tools for SQL and reporting.
• Ability to align priorities with senior stakeholders.
• Nice to have: brokerage/financial services, Redshift, Git, mentoring.

Aufgaben

• Analyse revenue, profitability, trading activity and client behaviour; explain findings to senior management.
• Build and run dashboards and recurring reports in SQL, Excel and BI tools.
• Track discrepancies, reconcile figures and validate metrics.
• Turn round urgent executive requests with hands-on data preparation when needed.
• Work with Data Engineering on reporting datasets, business logic and data quality.
• Document how metrics are defined and calculated, and onboard new analysts as the team grows.

Kenntnisse

Data analysis

Stakeholder management

Tools

SQL

dbt

Excel

Power BI

Tableau

Redshift

Git

Claude AI

Jobbeschreibung

We’re building our core analytics team, and this role sits at the centre of it. You’ll report to our CIO and work closely with the CEO and COO, producing the analysis and reporting they use to run the business. Day to day, you’ll partner with our Data Engineering Team Lead.

Our stack is Amazon Redshift, dbt and Apache Airflow. AI tools, including Claude, are part of how we work every day.

What you’ll do

• Analyse revenue, profitability, trading activity and client behaviour. Explain what you find to senior management in plain terms.
• Build and run dashboards, recurring reports and ad hoc analysis in SQL, Excel and BI tools.
• Track down discrepancies, reconcile figures and validate the metrics the business runs on.
• Turn round urgent executive requests, including hands‑on data preparation when the answer can’t wait for a pipeline.
• Work with Data Engineering on reporting datasets, business logic and data quality.
• Document how metrics are defined and calculated, and onboard new analysts as the team grows.

What you’ll need

• 5+ years in data analysis or BI. You’ve taken business questions from first ask to a validated answer on your own.
• Advanced SQL: complex joins, CTEs and window functions.
• Hands‑on dbt experience. You’ve built and maintained models in production, with tests and documentation.
• Strong Excel, plus Power BI, Tableau or a similar BI tool.
• Experience with a cloud data warehouse.
• Hands‑on use of Claude or similar AI tools for SQL, analysis and reporting, and the judgement to check their output.
• Confidence with senior stakeholders. You can agree priorities when requests compete.
• Nice to have: brokerage or financial services experience; Redshift or Git; mentoring analysts.

Why this role

Your work goes straight to the executive team. You’ll help define the metrics the business is run on. And with the analytics team still taking shape, you’ll set how it works as it grows.