Data Analyst - Bryanston
per year
Estimated salary range
per year
Estimated salary range
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)
Submit your application for this position at Catch Recruit
Submit your application for this position