BI Developer

Company Description

Ocorian is a global leader in corporate and fiduciary services, fund administration and capital markets. Wherever our clients hold financial interests, or however they are structured, we provide compliant, tailored solutions that are individual to their needs.

We manage over 17,000 structures for 8000+ clients with a global footprint operating from 18 locations. Our scale offers all our people great opportunities to develop their knowledge and skills and to progress their careers.

Job Description

Purpose of the job

• To assist in the development of business intelligence and management information solutions for Ocorian taking information from the financial, HR, corporate administration systems, and Cloud-based solutions to create a reporting base for the business, the single source of truth
• Delivery of key dashboards and reporting requirements from the BI/MI solutions with appropriate robust security models
• Assist with data cleansing and data loading exercises, which may extend to jurisdictional and regulatory filing requirements
• Documentation of solutions, handover to BAU Teams, and supporting solutions
• Prior experience of creating/supporting ETL, data warehouses and Tabular data models. Ocorian utilises Microsoft SQL Server technologies, including SSIS, SSAS, SSRS and Power BI and the successful candidate should have delivered projects using aspects of this technology stack in recent times
• The individual will be expected to work across all levels of the Business to liaise with key stakeholders to ensure the design, development and documentation meets the requirements of the Business. The role will work extensively with IT functions and the role may be matrix-managed when required with tasks assigned by the BAU BI Team

Main responsibilities

• Design and implement data warehouse solutions and Tabular data models
• Develop dashboards and reporting to meet business reporting needs
• Deliver approved projects within timeframe
• Provide regular updates to management
• Make recommendations for potential improvement or changes
• Promote the use of core systems for data capture aligned to standards and initiatives

Qualifications

TECHNICAL SKILLS

• SQL Server 2016 onwards
• SQL Server BI stack – SSAS / SSIS / SSRS
• Microsoft Power BI
• Experience of data cleansing tools and methodologies

BUSINESS SKILLS

• Demonstrated ability to apply IT in solving business problems
• Good written, oral, and interpersonal communication skills
• Ability to present ideas in business-friendly and user-friendly language
• Highly self-motivated, proactive and attentive to detail
• Ability to effectively prioritise and execute tasks in a high-pressure environment
• Extensive experience working in a team-oriented, collaborative multi-jurisdictional environment
• Experience of working in project teams with mixed skillsets and levels of technical knowledge
• Energy and enthusiasm to support the future growth and success of the business

Additional Information

All staff are expected to embody our core values that underpin everything that we do and that reflect the skills and behaviours we all need to be successful.  These are:

• We are AMBITIOUS - We think and act globally, seizing every opportunity to support our clients and staff - wherever in the world they may be.
• We are AGILE - Our independence from any financial institution gives us the flexibility and freedom to keep things simple, efficient and effective.
• We are COLLABORATIVE - We take the time to understand our clients' needs so that we can deliver personalised solutions every time.