Business Intelligence Developer

CO_AFSLGO Apex Fund Services Holdings Ltd (AFSHL Group Ops); Cape Town; Hybrid; ZAR 300,000 - 400,000; Full time

Job summary

A leading financial services company is seeking a Business Intelligence Developer in Cape Town. The role involves developing and maintaining BI solutions, working closely with business analysts, and tuning SQL queries for performance. Ideal candidates will have a degree in Information Systems or Computer Science and significant experience with SQL Server. This opportunity offers a hybrid working model alongside competitive remuneration.

Qualifications

• 3-5 years of experience with solid SQL Server development.
• Experience in building integration solutions independently.
• Self-starter with initiative to learn new technologies.

Responsibilities

• Develop and enhance reports and dashboards.
• Maintain and enhance existing ETL processes.
• Be on regular after-hour stand-by support for data warehouse loads.

Skills

Proficient in reporting writing tools such as SSRS

Solid understanding of relational databases

Performance tuning of complex SQL queries

Strong analytical and problem-solving skills

Education

Degree or diploma in Information Systems or Computer Science

Tools

Power BI

Microsoft T-SQL

Job description

Business Intelligence Developer page is loaded

Business Intelligence Developer

Apply remote type Hybrid locations Cape Town time type Full time posted on Posted Yesterday job requisition id JR-0015272

The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion.

That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience.

Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you

Summary of the position

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

Comptencies

• Proficient in reporting writing tools such as SSRS, dashboarding tools like Power Bi.
• Solid understanding of relational databases, Microsoft T-SQL.
• Solid understanding of ETL processes.
• Understanding of scheduling tools such as control-m.
• Fundamental understanding of basic warehouse concepts.
• Performance tuning of complex SQL queries.

Outline of main duties and responsibilities

As a Business Intelligence Developer, you will be expected to:

• Work with both Business Analysts and business owners to develop and enhance reports and dashboards.
• Maintain and enhance existing ETL processes.
• Be on regular after-hour stand-by support for the data warehouse loads.
• Performance tuning of stored procedures and reports.
• Ensure that development standards and processes are followed according to Apex’s best practices.

Skills and experience

• A degree or diploma (3 years) with majors Information Systems or Computer Science will be a strong advantage.
• A good working knowledge of IT systems in a corporate environment.
• At least 2-3 years of solid SQL Server development experience, with profiency in report writing skills. This includes but not limited to building complex stored procedures, functions, and views.
• 3-5 years’ experience in building integration solutions independently.
• Strong attention to accuracy and detail.
• Strong analytical and problem-solving skills, including an ability to work independently from the business analyst team when appropriate.
• A high tolerance for ambiguity as requirements is 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 essential.
• Ability to multi-task and to 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 Control-m
  • Cloud based database solutions like Snowflake
  • Cloud based ETL solutions like DBT
  • A background in Investment and Financial Accounting

Reporting structure

You will report to the team manager of the Business Intelligence Team for Open Ended Funds (SA).

Remuneration level

Remuneration is market related depending on experience.

Disclaimer : Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.

Our Story

About Apex Group

We are dedicated to driving positive change in financial services while fuelling the growth and ambitions of asset managers, allocators, financial institutions, and family offices. Established in Bermuda in 2003, the Group has continually disrupted the asset serving industry through our investment in innovation and talent. Today, we set the pace in asset servicing and stand out for our unique single-source solution and unified cross asset-class platform which supports the entire value chain, harnesses leading innovative technology, and benefits from cross-jurisdictional expertise delivered by a long-standing management team and over 13,000 highly integrated professionals.

We’re a people-powered business, and our people are full of ambition. Together, we’re inspired to lead the new era of data and tech enabled service. Bringing new products and services to market. Sharpening our client focus. Disrupting the market to exceed expectations. Innovating across a range of specialisms. With our focus on making a difference to our people, our planet and our society, you’ll experience more here than you would at most other companies.

Working at Apex

Prepare to accelerate.

We’re a people-powered business with a vision to inspire a new era of service-led FinTech. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster.

Positive change starts with you.

We’re a people-powered business with a vision to inspire a new era of service-led FinTech. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster.

The journey is yours to own.

When you stretch yourself, you grow. We want you to explore ways of working that will see you thrive as part of something bigger. We’ll help you with a solid structure, challenging projects, vibrant networks, supportive colleagues and approachable leaders. All the things you need to own your unique journey.