Aberdeen (Ref: 1281)
Found in: Talent UK C2 - 2 weeks ago
We are recruiting for a Database & Reporting Engineer within our IT department in Aberdeen, to Analyse, design, develop, maintain, administer, and support databases and dependent reporting including data-management.
Purpose of Job:
Analyse, design, develop, maintain, administer, and support databases and dependent reporting including data-management Ensure SQL and Reporting standards compliance including change definition, review, and control of production deployment. Input to associated Change Boards Document and apply source control across the SQL and Reporting estate addressing any gaps identified Own and champion related Business Systems procedures and working mechanisms continuously improving compliance Engage within Business Systems and the wider organisation to recommend and deliver database and reporting solutions Coach Business Systems team members on SQL and reporting technical aspects, coding standards and best-practice Deploy and upgrade database and reporting solutions, supporting technology transition Database planning, administration, and performance tuning / optimisation Related support and frequency-based activities.Key Areas of Responsibility:
Implementation and support:
Databases in Microsoft SQL Server including OLAP-based reporting. Lifecycle management of SQL objects including queries, views, functions, triggers, and stored procedures Business reporting in Excel and SSRS Application databases and associated reporting Maintenance and development of OLAP reporting and data warehouse and related ETL routines (SSIS / SSAS) Work with the business ensuring all reporting and database needs are met.Frequency-based tasks:
Database administration including data growth management, backups, indexing, performance tuning etc Contribution to the execution of month end processing, systems maintenance, and related reporting Contribution to related support.Essential Qualifications, experience and competencies
Computing Science degree or equivalent experience Significant experience delivering database and reporting solutions using MS SQL Server technologies Experience working within an environment requiring a high level of standards compliance and procedural control including related ownership, accountability, and responsibility Implementation and maintenance of data warehouses and business reporting / intelligence solutions Strong interpersonal skills with the ability to build rapport within Hydrasun Ability to convey appropriate technical detail at all levels Microsoft SQL Server database development & administration (SSAS, SSIS, SSRS, SQL Server Agent Jobs, maintenance, backup, performance tuning) Advanced T-SQL (Schema & query design, views, functions, stored procedures) Excellent written and verbal communication skills SQL development best-practice, coding standard, and source / version control. This includes monitoring and ensuring compliance to such standards Documentation and Issue tracking Change control including documentation / definition, proposal, review, and deployment to production.Desireable Qualifications, experience and competencies
Relevant certification Experience of manufacturing, distribution, and sales IT Delivery of database and reporting solutions in an ERP environment Coaching, mentoring and development of co-workers in the areas of database and reporting technologies and solutions Experience with SQL Server 2019 and 2022 Implementation of OLAP-based reporting solutions (SSAS Tabular Model) Excel / MS-Query / VBA development GIT source control.-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Narrating Decolonisation The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable skills for...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Biodiversity Mapping of University Grounds The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Lease Management The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable skills for future work...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Information Governance The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable skills for...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Student Support (Conduct and Addressing GBV) The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - School Support Assistant The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable skills for...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Chinese Social Media The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable skills for future...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Data Safe Haven The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable skills for future work...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Library of Sanctuary Planning Project The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable...
-
Aberdeen Internship
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAberdeen Internship - Making Careers Advice Fun for Pupils The Aberdeen Internship Programme has operated successfully since 2011. The initiative offers students the opportunity to contribute to defined projects or activities within the University during the summer vacation, within a supervised and supportive environment which helps develop transferrable...
-
Aberdeen (Ref: 1293)
Found in: Talent UK C2 - 2 weeks ago
Aberdeen, United Kingdom Hydrasun Full timeWe are recruiting for an experienced Administrator / Receptionist for our Customer Service team in Aberdeen to provide efficient and effective administrative support. Experience in working with Microsoft excel is essential as the successful candidate will be responsible for running and distributing various reports including daily margin and revenue reports....
-
Campus Librarian
5 days ago
Aberdeen, United Kingdom Scottish Agricultural College Full time**Title**:Campus Librarian **Type**:Full-Time, Permanent **Salary**:£28,412 - £32,996 per annum **Location**: SRUC Aberdeen **Closing Date**: 5 January 2023 **Ref**:ANF/FO/066/21 SRUC is unique in Scotland and one of the largest organisations of its kind in Europe. Our ambitious and exciting vision is to work at local, national and international...
-
Research Fellow in Energy Transition
2 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeResearch Fellow in Energy Transition SAFARI is a long running project at the University of Aberdeen which focuses on the delivery of analogue data for improved understanding of subsurface reservoirs. The key deliverable is a database of 650 virtual outcrops collected from key locations around the World. These are augmented with additional data to improve...
-
Lab Assistant
3 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeLab Assistant We seek a highly motivated laboratory assistant to support on screening rice plants for cold tolerance. The laboratory assistant will be based in the research group of Dr Gareth Norton at the University of Aberdeen. This research group have acknowledged laboratory expertise in molecular biology and plant biology. **School/Section** -...
-
Administration Coordinator
2 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeAdministration Coordinator **School/Section** - Research & Innovation **Staff Category** - Secretarial **Position Type** - Part Time **Duration of Post** - Funding/Activity Limited **Grade** - Grade 4 **Salary From** - £26,444 **Salary** - per annum, pro rata **Location** - Aberdeen **Closing Date** - 22/03/2024 **Ref No** -...
-
Research Fellow
6 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeResearch Fellow The Rowett Institute, University of Aberdeen, is world-leading in nutrition research focusing on some of the key global challenges with regards to healthy and sustainable diets, food safety, and the food supply chain. As part of this research, we are seeking to recruit a post-doctoral researcher in the area of biological mass spectrometry....
-
Aberdeen, United Kingdom University of Aberdeen Full timeLecturer/Senior Lecturer/Programme Leader Roles (Management) With over 528 years of history, the ‘ancient’ University of Aberdeen is among the world’s leading higher educational institutions consistently ranked within the top 200 universities in the world, and in 2019 achieved Scottish University of the Year. With ambitious growth plans for the...
-
Research Fellow
5 days ago
Aberdeen, United Kingdom University of Aberdeen Full timeResearch Fellow **School/Section** - Geosciences **Staff Category** - Research **Position Type** - Full Time **Duration of Post** - Funding/Activity Limited **Grade** - Grade 6 **Salary From** - £35,333 **Location** - Aberdeen **Closing Date** - 09/01/2023 **Ref No** - GEO436R **Documents** - Further Particulars.pdf (PDF, 622.58kb) Salary will be...
-
Aberdeen, United Kingdom University of Aberdeen Full timeLecturer/Senior Lecturer/Programme Leader Roles (Global Communications) With over 528 years of history, the ‘ancient’ University of Aberdeen is among the world’s leading higher educational institutions consistently ranked within the top 200 universities in the world, and in 2019 achieved Scottish University of the Year. With ambitious growth plans for...
-
Aberdeen, United Kingdom University of Aberdeen Full timeLecturer/Senior Lecturer/Programme Leader Roles (Public Health) With over 528 years of history, the ‘ancient’ University of Aberdeen is among the world’s leading higher educational institutions consistently ranked within the top 200 universities in the world, and in 2019 achieved Scottish University of the Year. With ambitious growth plans for the...
