Website Apex Group
Apex Group Ltd., established in Bermuda in 2003, is a global financial services provider. With 85 offices in 42 countries worldwide and 10,000 employees upon the close of announced acquisitions, Apex delivers an extensive range of services to asset managers, capital markets, private clients and f… read moreamily 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 and super ManCo services, business services including HR and Payroll and a pioneering ESG Ratings and Advisory service for private companies. 20 Reid Street, 3rd Floor, Williams House, Hamilton, P.O. Box 2460 HMJX HM12, BM
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 processes.
Understanding of scheduling tools such as control-m.
Fundamental understanding of basic warehouse concepts.
Knowledge and understanding of performance tuning of complex SQL queries.
Responsibilities
Report solutioning
Work with both Business Analysts and business owners to development new reports and dashboards and the enhancement of existing reports and dashboards.
Performance tuning
Performance tuning of stored procedures and reports
Production Support
Investigate production reporting issues and help business their understand their data.
ETL Maintenance and Enhancements
Maintaining and enhance current ETL processes using various ETL tools
After Hours Standby Support
Be on regular after-hour stand-by support for the data warehouse loads.
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 proficiency 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 but not essential
Scheduling tools such as Control-m
Exposure to cloud based BI and ETL solutions and services
Familiarity with financial services industry regulations and compliance.
go to method of application »
Apply via company website ( https://www.apexgroup.com/ ) or