Business Intelligence Analyst
CXP are now part of the Huntswood Group
We are seeking a skilled
Business Intelligence Analyst to transform data into actionable insights that drive strategic and operational decision-making. The ideal candidate will be strong in data querying, analytics, and visualization, with hands-on experience using modern cloud data platforms and BI tools.
Job Responsibilities
- Design, develop, and maintain interactive dashboards and reports using Tableau
- Write complex and optimized SQL queries to extract and transform data from Snowflake and other data sources
- Use Python for data analysis, automation, statistical exploration, and advanced transformations
- Build and maintain scalable data pipelines and transformations using Databricks
- Partner with business stakeholders to understand requirements and translate them into analytical solutions
- Perform data validation, quality checks, and reconciliation to ensure reporting accuracy
- Analyze trends, patterns, and key drivers to support business performance and strategic initiatives
- Document data models, metrics definitions, and BI solutions to ensure transparency and reuse
- Support ad-hoc analysis and data investigations as required
- Experience and skills required
- Strong proficiency in SQL (advanced joins, window functions, performance tuning)
- Experience with Python (Pandas, NumPy, Jupyter, or similar libraries)
- Hands-on experience building dashboards and reports in Tableau
- Practical experience using Databricks for data processing and analytics
- Experience working with Snowflake as a cloud data warehouse
- Solid understanding of data modeling, star schemas, and analytical datasets
- Ability to communicate insights clearly to both technical and non-technical audiences
- Strong problem-solving and analytical thinking skills
- Qualification
BCom degree or studying towards one (a must)
Interview Process
The interview process will consist of a single stage for shortlisted candidates. Successful applicants will meet with the Director of Business Intelligence for a discussion focused on real‑time experience, career goals and aspirations, alongside a structured set of competency‑based interview questions.
Core Behaviours
At Huntswood, our people are dependable, driven, and collaborative — and our values guide the way we show up for our customers, our colleagues, and our clients.
Deliver WOW!
- Own it — take personal responsibility for getting things done, find a way.
- Deliver Unbelievable Service - Create “WoW” moments for your customers every time.
Servant Leadership
- Enable and empower all employees.
- Our people are at the heart of our success.
- Do the right thing
- Be Empathetic
- Be respectful to everyone, always
- Act with integrity, even when no one is looking.
Winning Mindset
- Bring your A‑game every day.
- Passion is contagious- work everyday like it is your first day on the job.
Strive for Greater
- Stay dedicated to continuous improvement.
- Challenge the status quo and bring forward your best ideas.
“It’s not just about what we do, but how we do it — our behaviours are what make us special.”