Business Intelligence Developer III

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

About Apex

Apex Group Ltd., established in Bermuda in 2003, is a global financial services provider. With over 80 offices in 70 countries worldwide and more than 12,000 employees, Apex Group delivers an expansive range of services to asset managers, financial institutions, private client and family offices. The Group has continually improved and evolved its capabilities to offer a single-source solution through establishing the broadest range of services in the industry; including fund services, digital onboarding and bank accounts, depositary, custody, super ManCo services, corporate services including HR and Payroll and a pioneering ESG Ratings and Advisory solution. Apex Group’s purpose is to be more than just a financial services provider and is committed to driving positive change to address three core areas: the Environment and Climate Change, Women’s Empowerment and Economic Independence, Education and Social Mobility.

Life at Apex isn't just about the work you do, it's about embracing the culture and loving what you do. Every employee plays a part in making Apex who we are today and the more that we grow, the more important that becomes. Whatever your career path or specialism Apex ensures it rewards loyal and dedicated employees. The international nature of our business and global network of offices means that there are opportunities to broaden your life experiences and take both short-term or permanent relocation options.

About the Position

Job Specification

We are seeking a highly accomplished and visionary Business Intelligence Developer to join our team in to help drive out Reporting and BI solutions. As a BI Developer, you will be responsible for the BI and Reporting solutions of a part of our global business. Collaborate with business analysts and cross-functional stakeholders to deliver innovative data-driven solutions. You will leverage your expertise in BI and Reporting to develop and implement ETL, reporting and dashboards solutions. If you are a seasoned BI practitioner with exceptional BI and reporting writing skills and have a proven track record of driving out optimized solutions, we want to hear from you.

Competensies

· Proficient in reporting writing tools such as SSRS, dashboarding tools like PowerBI.

· Solid understanding of relational databases, Microsoft T-SQL.

· Solid understanding of ETL prosesses.

· Understanding of scheduling tools such as control-m.

· Fundermental understandng of basic warehouse concepts.

· Knowledge and understand of performance tuning of complex SQL queries.

Responsibilities

1. Report solutioning

· Work with both Business Analysts and business owners to development of new reports and dashboards and the enhancement of existing reports and dashboards.

2. Performance tuning

· Performance tuning of stored procedures and reports

3. Production Support

· Investigate production reporting issues and help them in business understand their data.

4. ETL Maintenance and Enhancements

· Maintaing and enhance current ETL processes using various ETL tools

5. After Hours Standby Support

· Be on regular after-hour stand-by support for the data warehouse loads.

6. Adherence to standards, processes and procedures

· Ensure that development standards and processes are followed according to Apex’s best practices.

Qualifications and requirements

· A degree or diploma (3 years) with majors Information Systems or Computer Science.

· A good working knowledge of IT systems in a corporate environment.

· At least 3-5 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.

· At least 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.

Preferred skills

· Scheduling tools such Control-m

· Exposure to cloud based BI and ETL solutions and services

· Familiarity with financial services industry regulations and compliance.

What you will get in return:

A genuinely unique opportunity to be part of an expanding large global business. Joining Apex Group will provide you with a platform for professional and personal success and an environment where you can truly make an impact.

Our people are our greatest asset, and we believe learning is central to developing talent, nurturing strong leaders, fostering a supportive company culture and ultimately drives our success.

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 souring model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.