Business Intelligence Analyst

About Citco

JOB DESCRIPTION

Citco is a global leader in fund services, corporate governance and related asset services with staff across 80 offices worldwide. With more than $1 trillion in assets under administration, we deliver end-to-end solutions and exceptional service to meet our clients’ needs.

For more information about Citco, please visit www.citco.com

About The Team & Business Line

The Citco Group's Business Intelligence team spearheads the development and management of cutting-edge BI reporting solutions for our Finance and HR Divisions. As a key member of our Product Support team, you'll work alongside dedicated professionals to ensure clients have uninterrupted access to critical information assets.

Responsibilities

Your Role:

We are seeking a highly motivated Business Intelligence Analyst with 3+ years of professional experience to join our growing team. The ideal candidate will have strong skills in Microsoft Business Intelligence (MSBI) solutions — such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and Power BI.

If the candidate does not already have direct hands-on experience with these tools, they must demonstrate the ability and willingness to learn them quickly. This role also requires independence, problem-solving skills, and the ability to handle incoming BI support requests with minimal supervision.

Key Responsibilities

• Design, develop, and maintain ETL processes using SSIS.
• Build and optimize reports, dashboards, and visualizations in SSRS and Power BI.
• Develop and manage data models in SSAS.
• Write, optimize, and maintain SQL queries, stored procedures, and scripts. Gather requirements from stakeholders and deliver BI solutions.
• Handle incoming BI support requests, troubleshooting, and resolve issues.
• Research and implement new BI tools and best practices.
• Support or develop Oracle Fusion Reports (OTBI, BIP) using PL/SQL where required.
• Work independently with minimal supervision .
  
  

Qualifications

About You:

Essential Skills

• 3+ years of experience as a Business Intelligence Analyst or similar role.
• 3 years of SQL experience with advanced query development.
• Proficiency in at least one MSBI tool such as Power BI and a strong aptitude for learning BI technologies quickly.
• Knowledge of data warehousing and modeling.
• Ability to work independently and manage multiple priorities.
• Strong analytical and communication skills.
  
  

Preferred Qualifications

• Familiarity with Oracle PL/SQL.
• Experience with Oracle Fusion Reporting (OTBI, BIP) and a willingness to learn.
• Experience with Power BI Service and Microsoft Fabric components.
• Knowledge of DAX and MDX.
• Agile/Scrum methodology exposure.
  
  

Our Benefits

Your well-being is of paramount importance to us, and central to our success. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We embrace diversity, prioritizing the hiring of people from diverse backgrounds. Our inclusive culture is a source of pride and strength, fostering innovation and mutual respect.

Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.