Senior Developer - Business Intelligence

Job Location : Western Cape, Cape Town

Deadline : April 21, 2025

Summary

• We are seeking a highly accomplished and visionary Business Intelligence Developer to join our team. As a BI Developer, you will report to the Business Intelligence Manager and be responsible for developing and maintaining BI and Reporting solutions.

The Role & Key Responsibilities :

• The Senior BI Developer will be expected to:
• Work with both Business Analysts and business owners to develop new reports and dashboards and enhance existing reports and dashboards.
• Performance tuning of stored procedures and reports.
• Assist the Business Analysts in investigating issues and help them in their data analysis.
• Be on regular after-hour stand-by support for the data warehouse loads.
• Ensure that development standards and processes are followed according to Apex’s best practices.

Skills Required :

• A degree or diploma (3 years) with majors in Information Systems or Computer Science will be a strong advantage.
• A good working knowledge of IT systems in a corporate environment.
• At least 5 years of solid SQL Server development experience, with proficiency in report writing skills, including but not limited to building complex stored procedures, functions, and views.
• At least 5 years’ experience in building integration solutions independently.
• Strong attention to accuracy and detail.
• Strong analytical and problem-solving skills, including the ability to work independently from the business analyst team when appropriate.
• A high tolerance for ambiguity as requirements are not always clear at the start of a project and can change as users and analysts start to see the data.
• Self-starter who can take the initiative to learn new technologies independently, and not just wait to be sent on training.
• Solid time management and communication skills are essential.
• Ability to multi-task and work on multiple project streams simultaneously.
• High personal integrity.
• The below skills are not an absolute requirement but would give the candidate a significant advantage over others:
• Scheduling tools such as Control-M.
• Cloud-based database solutions like Snowflake.
• Cloud-based ETL solutions like DBT.
• A background in Investment and Financial Accounting.