BI Developer

Permanent - Constantia
Qualifications & Experience 
• Relevant tertiary qualification in Information Systems, Computer Science, Data Analytics, Mathematics, Statistics, or a related field.
• Minimum 5 years' experience as a BI Developer / BI Analyst Developer.
• Strong experience designing and developing end-to-end BI solutions.
• Advanced SQL development and database querying skills.
• Proven experience with ETL development, data integration, and data transformation processes.
• Strong understanding of data warehousing principles and dimensional modelling.
• Experience working with BI visualisation tools such as Power BI or Qlik.
• Strong analytical and numerical ability.
• Proven track record of delivering successful BI and data-related projects.
• Microsoft SQL Server and SSIS.
• Snowflake.
• Talend.
• Power BI.
• Qlik Sense / QlikView.
• Experience within financial services, asset management, investments, or related industries.
• Exposure to cloud-based data platforms and modern data architectures.
Responsibilities
• Gather, analyse and document business and reporting requirements from stakeholders.
• Design, develop and maintain end-to-end BI solutions across the full technology stack.
• Build and maintain robust ETL processes to extract, transform and load data from multiple source systems.
• Develop and enhance data warehouse solutions to support reporting and business intelligence initiatives.
• Create and maintain a centralised, trusted source of business data.
• Design relational and dimensional data models that support reporting and analytics requirements.
• Develop reports, dashboards and visualisations that provide meaningful business insights.
• Analyse data trends and identify opportunities to improve business processes and operational efficiency.
• Ensure data accuracy, integrity and consistency across BI platforms.
• Troubleshoot and resolve data-related issues and performance bottlenecks.
• Collaborate with technical and business teams to deliver scalable and sustainable BI solutions.
• Provide mentorship, guidance and technical support to junior team members.
• Contribute to BI strategy, continuous improvement initiatives and best practices.
Competency
• Technical Competencies
• Strong SQL and database development skills.
• Solid understanding of data warehouse architecture and ETL methodologies.
• High level of data analysis and problem-solving capability.
• Ability to translate business requirements into technical solutions.
• Strong attention to detail and commitment to data quality.
• Excellent problem-solving and troubleshooting skills.
• Ability to work effectively in complex, data-driven environments.
• Strong planning, organising and coordination skills.
• Results-oriented and solutions-driven mindset.
• Excellent verbal and written communication skills.
• Strong stakeholder engagement and relationship-building abilities.
• Ability to interact confidently across different business units and management levels.
• Strong analytical thinking and numerical aptitude.
• Self-motivated with the ability to work independently and as part of a team.
• Continuous learning mindset and passion for leveraging data to drive business decisions.
    © 2024 Rough Diamonds Studio. All rights reserved.