Product Specialist, Data Transformation

Citco GSGS; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in fund administration seeks a Product Specialist to join their Data Transformation team. The role involves creating robust reporting solutions, transforming product visions into user stories, and supporting various technology implementations. Candidates should possess a bachelor's degree in a quantitative discipline and experience with programming, especially SQL and VBA. Join a diverse and inclusive team that values your well-being and offers flexible working arrangements.

Benefits

Training and education support

Flexible working arrangements

Range of benefits

Qualifications

• Experience with SQL and VBA macros preferred.
• Experience with QlikSense, Python, C#/.Net, and HTML is an asset.
• Candidacy/completion of CSC, CFA, CMA or other related certifications is beneficial.

Responsibilities

• Identify, analyze, plan and develop customized client reporting needs.
• Transform high-level vision into detailed user stories.
• Co-ordinate with technology groups for implementation and deployment.

Skills

Analytical skills

Programming languages

SQL

VBA macros

QlikSense

Python

C#/.Net

HTML

Education

Bachelor degree in a quantitative discipline

Job description

Fund Administration is Citco’s core business, and our alternative asset and accounting service is one of the industry’s most respected. Our continuous investment in learning and technology solutions means our people are equipped to deliver a seamless client experience.

As a member of our Data Transformation team, you will be working with some of the industry’s most accomplished professionals to deliver award-winning services for complex fund structures that our clients can depend upon.

Your Role:

As a Product Specialist, you will support the Data Transformation team and all lines of business in creating robust reporting solutions and data products. You will be part of the delivery team to ensure that right functionality is built and delivered in a timely manner. You will transform the high-level vision and requirements of the Product Manager into detailed user stories.

• Correspond with various business groups to identify tactical needs

• Identify, analyze, plan and develop customized client reporting needs using scripting languages (e.g. SQL, BI, etc.)

• Develop peripheral automation for our processes (e.g. VBA macros, SQL scripts etc.)

• Co-ordinate with our other technology groups for implementation and deployment

• QA testing, manage UAT and roll-out of technology

• Support and maintain existing scripts and tools employed by the group

• Ensure there is sufficient documentation for our processes

• Assist with various projects as assigned

About You:

• Bachelor degree in a quantitative discipline, such as computer science, engineering, finance, economics or accounting

• Experience with some programming languages

• Experience with SQL and VBA macros is preferred

• Experience with QlikSense, Python, C#/.Net, and HTML is an asset

• Candidacy/completion of CSC, CFA, CMA or other related certifications is an asset

• Affinity with markets and investments

• Excellent proficiency in English, verbal and written

• Strong analytical skills

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.