Data Engineer

Company Description

Fund services | Corporate | Capital markets | Private client | Regulatory & Compliance

We help clients succeed by unlocking new value through expertise, trust and scale. We deliver solutions that

solve complex challenges faced by asset managers, financial institutions, corporates, high net-worth individuals and family offices.

With a curious mindset, we ask the right questions to get to the right solution, faster. We collaborate to win together, sharing successes and shaping the future of our global business. Our culture of support and recognition provides the tools and opportunities for you to grow, while unlocking the most value for our clients and making your mark with Ocorian.

Expertise: We deliver specialist, tech-enabled solutions for our clients grounded on deep industry expertise.

Trust: We’re a trusted partner to over 8,000 clients globally. We are proud to have long-lasting partnerships with our clients.

Scale: With more than 1,500 colleagues, we operate across 20+ countries, our scale enables us to support our clients globally and locally, providing a seamless client experience across borders and service lines.

Job Description

Purpose of the Role 

As a Data Engineer, your core responsibility is to support the Business Intelligence Team in achieving key deliverables and enhancing data-driven decision-making processes. You will collaborate closely with Operations and Sales Teams in a multi-jurisdictional environment, addressing data requests and issues through insightful analysis and efficient data cleaning exercises.

By fulfilling the below mentioned responsibilities and embodying the technical and business skills, you will play a pivotal role in leveraging data to make informed decisions, supporting the team’s objectives, and contributing to the overall success of Ocorian.

Main Responsibilities 

• Contribute to the daily execution of key deliverables within the Business Intelligence Team
• Collaborate with Operations and Sales Teams to understand and address data requirements and challenges
• Carry out data cleansing exercises, which may extend to jurisdictional and regulatory requirements
• Assist in the documentation of solutions for efficient knowledge transfer and team alignment
• Provide analytical support to the Business Intelligence Team, conducting some exploratory data analysis

#LI-AM1

#LI-Hybrid

Qualifications

Knowledge, Skills & Experience

Technical Skills

• Min 8-10 years experience in basic SQL and BI tools, ideally Power BI would be advantageous
• Proficient in Microsoft Excel, Word, and PowerPoint
• Experience of data cleansing tools and methodologies
• Proficiency in SQL Server Management Studio (SSMS), ensuring alignment with stakeholder requirements and business goals.
• Experience in completing complex T-SQL queries, stored procedures, triggers, and functions to manipulate and retrieve data efficiently.
• Skilled at designing and implementing ETL processes using SQL Server Integration Services (SSIS) for data extraction, transformation, and loading.
• Experience in tabular data modelling with SQL Server Analysis Services (SSAS) for creating cubes, dimensions, and measures to support business analytics and reporting.
• Proficiency in performance tuning and optimization techniques to enhance the speed and efficiency of database queries, ETL processes, and reports.
• Experience in data warehousing concepts, including data modelling, schema design, data cleansing, and data aggregation.
• Skilled in troubleshooting and resolving issues related to database performance, data integrity, and ETL processes.
• Demonstrate an ability to act as a liaison between technical teams and stakeholders, bridging the gap between technical requirements and business objectives to ensure successful project outcomes.

Business Skills

• Demonstrates good written and verbal communication skills
• Exhibits effective interpersonal skills for seamless collaboration in a multi-jurisdictional environment
• Highly self-motivated, proactive and attentive to detail
• Be a team player, fostering a positive and collaborative working environment
• Ambitious to learn and adapt to evolving business and technology landscapes
• Ability to effectively prioritise and execute tasks in a high-pressure environment
• Energy and enthusiasm to support the future growth and success of the business

Additional Information

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 CLIENT CENTRIC – Clients are at the centre of our world, and we’re committed to providing expertise and specialist solutions to meet their most complex challenges.
• We are AMBITIOUS – We aim high. We think and act globally, seizing every opportunity to delight our clients and support our colleagues - wherever in the world they may be.
• We are AGILE – We act on our initiative to get things done for our clients. Our independence gives us the flexibility and freedom to keep things simple, efficient and effective.
• We are COLLABORATIVE – With a curious mindset, we ask the right questions to get to the right solution, for our clients faster. We collaborate to win together and share our successes.
• We are ETHICAL – We behave with integrity at all times and assume positive intent, building trust through responsible actions and honest relationships.