Data Analyst - Bryanston

About the position

The Data Analyst will be responsible for designing, developing and maintaining business intelligence (BI) solutions, focusing on Power BI dashboards and SQL server data management. The role involves transforming complex datasets into actionable insights to support decision making across business units.

Key responsibilities:

Data Analysis and reporting
Develop, publish and maintain Power BI dashboards and reports to tack KPIs and business performance.
Write complex SQL queries, stored procedures and scripts to extract, clean and transform data from SQL server databases.
Analyse large, complex data sets to identify trends, anomalies and opportunities for process improvement.
Ensure data accuracy, consistency and reliability across all reporting outputs.

Data Management
Collaborate with DBAs and data engineers to optimize database performance.
Design and maintain ETL processes for integrating data from multiple sources into SQL server / data warehouse.
Support data modelling schema design and performance tuning activities.
Ensure compliance with data governance, privacy and security standards.

Business Partnering
Engage with stakeholders to gather reporting requirements and translate them into technical specifications.
Provide ad hoc analysis to support operational, financial and strategic decisions.
Train and support end users in accessing and interpreting reports.

Continuous Improvement
Automate manual reporting process to improve efficiency.
Stay current with Power BI and SQL server enhancements, recommending new features or approaches.
Identify and implement improvements to reporting methodologies and data pipelines.

Required skills and competencies
Technical skills:
Power BI: advanced DAX, Power Query (M), data modelling, Row-Level Security (RLS), performance optimization.
SQL Server: T-SQL (queries, views, stored procedures, functions), indexing, query optimization, database structures.
Knowledge of ETL tools (eg SSIS, ADF, custom pipelines).
Strong understanding of relational databases, star/snowflake schemas and dimensional modelling.
Familiarity with APIs, Excel and other data visualisation or analysis tools.
Basic exposure to Python/R for analytics (advantageous).

Soft skills:
Strong analytical and problem-solving abilities.
Excellent communication skills (verbal and written).
Ability to translate business needs into data-driven solutions.
Detail-orientated with a focus on accuracy and data integrity.
Capable of managing multiple priorities and deadlines.

Qualifications and Experience:
Education - Bachelor's degree in Computer Science, Information Systems, Statistics, Data Science or related field.
Experience -
4 to 6 years working as a Data Analyst, BI Analyst or similar role.
At least 3 years hands on experience with Power BI in a professional environment.
At least 3 years experience with SQL Server (query development and performance tuning).
Experience working with enterprise level datasets, preferably in financial services, fintech or related industries.
Certifications (preferred but not required)
Microsoft Certified: Data Analyst Associate (Power BI)
Microsoft Certified - Azure Data Fundamentals / SQL Server certifications.

Key Performance Indicators:
Accuracy, timeliness and adoption of delivered reports and dashboards.
Reduction in manual reporting through automation.
Stakeholder satisfaction with insights and reporting.
Data quality improvements and reduce reporting errors.
Contribution to data governance and compliance initiatives.

Working Conditions:
Hybrid/remote options as per company policy.
May require after-hours work during critical reporting cycles (eg month end audits)

Desired Skills:

• degree
• Data extraction
• Data analysis
• Power BI
• MS SQL Server
• Python
• ETL tools
• Dashboard
• Excel
• Data Mining