Senior Administrator - Data Analyst - #1791547

EMPLOYMENT TYPE: Permanent

DEPARTMENT: Employer Solutions

DIVISION: Institutional Client Services

WORKPLACE STRUCTURE: Hybrid

Role Overview

PURPOSE OF JOB

The Senior Administrator will be responsible for creating comprehensive reports using Crystal Reports, SQL Developer, and Alteryx. The ideal candidate must possess excellent SQL skills, a good understanding of Alteryx, and experience with Power BI. Strong communication skills are essential to interpret and deliver report requests across the Employer Solutions Division. The role involves collaborating with the business and IT teams, carrying out workflow and mailbox monitoring, and actively participating in team management and day-to-day reporting requirements.

Main Responsibilities And Duties

• Creating and maintaining reports using Crystal Reports and/or SQL, as well as creating stored procedures, functions, and views.
• Develop SQL queries to extract, manipulate and/or calculate information to fulfil data and reporting requirements.
• Use of Alteryx to assist with creating and maintaining reports.
• Assist with reporting requirements for new business take on.
• Attend internal meetings and meetings with external parties.
• Liaising with JTC Employer Solutions in all jurisdictions to produce internal and client reports.
• Work with report requesters to gather data and reporting requirements.
• Understand and complete report writing process.
• Create, maintain and support new and existing complex reports.
• Strong testing discipline.
• Ensuring all processes and procedures are followed and kept up to date.
• Providing support for UAT of Systems Development.
• Assisting in the preparation of regulatory reporting on behalf of the JTC Employer Solutions business.
• Workflow and mailbox monitoring.
• Managing scheduling of new and existing reports.
• To have strong knowledge and understanding of core systems.
• To support team manager in running team and colleagues with the day-to-day team requirements.
• To identify, evaluate and report risks to team manager.
• Ad-hoc project work.
• Maintain SharePoint requests and circulate communications business wide re reporting / scheduling and self-service updates.
  
  

Essential Requirements

• Advanced SQL skills.
• Knowledge of Crystal Report.
• Good knowledge of Alteryx.
• Experience with Power BI.
• Ability to demonstrate strong analytical and problem-solving skills.
• Capacity to work unsupervised and under tight deadlines.
• Strong organizational skills.
• Effective communication skills.
• Completer/finisher with the ability to see tasks through to completion.
• Strong ability to respond and investigate queries.
• Numerate with competent system skills, including advanced knowledge of Excel.
• High level of accuracy and attention to detail while handling significant volumes of data.