Database & Reporting Engineer

My Client, a well respected global organisation, are looking to take on a Database and Reporting Engineer on a full time permanent basis in Aberdeen, to Analyse, design, develop, maintain, administer, and support databases and dependent reporting including data-management.

In this role, you will:

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 / optimization 

Related support and frequency-based activities.

Areas of Responsibility will include:

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.

Your experience and qualifications should include:

Computing Science degree or equivalent experience

Significant experience delivering database and reporting solutions using MS SQL Server technologies

Implementation and maintenance of data warehouses and business reporting / intelligence solutions

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)

SQL development best-practice, coding standard, and source / version control. This includes monitoring and ensuring compliance to such standards

This role requires someone in the office full time 5 days per week due to the operational requirements of the business.

Sound like the ideal role for you? Do not miss out - Apply today!