Senior Data Analyst
Company Description
Ocorian delivers administration and compliance services for funds, corporate, capital markets and private clients.
No matter where in the world our clients' hold financial interests, or however they are structured or need to be supported, we will provide a tailored and personalised solution that is individual to their needs and fully compliant to the needs of their stakeholders, regulators and the investment itself.
We manage over 15,000 structures for 6000+ clients with a global footprint operating from 20+ 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
Ocorian are hiring a Senior Data and BI Associate as part of the company’s organic growth.
Reporting to the Global Head of Analytics, the post-holder will be part of the Finance Team.
- This role involves providing expert database and BI stack knowledge.
- To perform database and BI stack tasks in accordance with Group standards and industry best practice to support Ocorian data and BI requirements.
- To utilize Microsoft database and business intelligence for delivery of database solutions, dataflow, Tabular data modelling, dashboards, and reporting.
- To maintain and contribute to documentation and knowledge base for subject matter.
- Where the role involves interactions across Ocorian, the ability to work logically and efficiently with excellent communication and reporting skills are necessary.
Main Responsibilities
- To analyse requirements and systems to provided data and BI/reporting solutions to all users at Ocorian.
- To utilize BI tools such as automated data processing, dataflows, and delivery of BI solutions.
- Using preexisting codebase, support and enhance SQL objects, SSAS Tabular data models, SSRS paginated reports, and Power BI dashboards.
- Be a team player and assist other members of the Company including the sharing of knowledge and skills.
- Be proactive, manage expectations and keep stakeholders regularly updated on the progress.
- Where this includes working with colleagues across the business, regularly reporting to the Global Head of Analytics on database and BI task.
- To support the implementation of Group Ocorian information security policies and standards. Ability to follow programming standards, naming conventions, and design best practices.
- To work with Group IT Team for corrective actions, resolution progress, and mitigation of vulnerabilities.
- And any other such duties that might be reasonably required for this role.
#LI-AM1
#LI-Remote
Qualifications
Knowledge, Skills & Experience
- Degree holder
- 5+ years of SQL programming and Microsoft BI stack experience, covering:
- Advanced T-SQL and able to demonstrate knowledge of creating SQL programmability objects (functions and stored procedures), using cursors, loops, CTE, dynamic-SQL, SQL/JSON functionality an advantage.
- Database design and data modelling experience.
- Experience of SQL Server Integration Services creating data flow from various data sources.
- Experience of SQL Server Analysis Services creating and editing Tabular data models with understanding of row level security, knowledge of DAX and advantage.
- Experience of SQL Server Reporting Services, creation of paginated reports, administration of folders/user access, creation of data driven subscriptions.
- Experience gained within a financial services or finance background, with an understanding of front office trust/fund systems and accounting systems.
- Power BI Desktop and Power BI Service administration advantageous.
- The postholder must be diligent and committed to continuous learning, with a positive outlook.
- Excellent people skills with high level of integrity, strong written and oral communication skills, and the ability to work under pressure.
- Ability and willingness to support the future growth and success of the Group.
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 aim high and are always seeking new ways to delight our people and clients
- We are AGILE – We act on our initiative to get things done
- We are COLLABORATIVE – We achieve more working together
- We are ETHICAL – We behave with integrity at all times
Related Jobs
Land your dream job
Get a weekly email with the latest startup jobs.