5 days ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
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.
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.
Seniority level
* Seniority level
Associate
Employment type
* Employment type
Full-time
Job function
* Job function
Information Technology
Referrals increase your chances of interviewing at JTC Group by 2x
Sign in to set job alerts for “Senior Administrator” roles.
Edinburgh, Scotland, United Kingdom 2 weeks ago
Diary Manager and Researcher (Scotland Office) (Ref: 7434)
Edinburgh, Scotland, United Kingdom 2 days ago
Edinburgh, Scotland, United Kingdom 2 days ago
Executive Assistant to Head of Edinburgh Medical School
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 3 days ago
Linlithgow, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 2 weeks ago
City Of Edinburgh, Scotland, United Kingdom 1 day ago
Senior System Administrator Infrastructure
Pensions Administration Training Academy Senior Administrator
Edinburgh, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 23 hours ago
Edinburgh, Scotland, United Kingdom 3 days ago
Edinburgh, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 2 months ago
Business Transaction Banking Manager - BCB Chief Controls Office
SENIOR ADMINISTRATOR (PRINCIPAL'S OFFICE)
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 1 week ago
Livingston, Scotland, United Kingdom 3 weeks ago
Edinburgh, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 2 hours ago
Senior Administrator - Business Operations - New Business Team
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 1 week ago
Edinburgh, Scotland, United Kingdom 3 days ago
Grangemouth, Scotland, United Kingdom 1 week ago
Bathgate, Scotland, United Kingdom 1 day ago
Edinburgh, Scotland, United Kingdom 4 weeks ago
Pensions Administration Training Academy Manager
Edinburgh, Scotland, United Kingdom 2 weeks ago
Edinburgh, Scotland, United Kingdom 5 months ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr