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:
1. Analyse, design, develop, maintain, administer, and support databases and dependent reporting including data-management
2. Ensure SQL and Reporting standards compliance including change definition, review, and control of production deployment. Input to associated Change Boards
3. Document and apply source control across the SQL and Reporting estate addressing any gaps identified
4. Own and champion related Business Systems procedures and working mechanisms continuously improving compliance
5. Engage within Business Systems and the wider organisation to recommend and deliver database and reporting solutions
6. Coach Business Systems team members on SQL and reporting technical aspects, coding standards and best-practice
7. Deploy and upgrade database and reporting solutions, supporting technology transition
8. Database planning, administration, and performance tuning / optimisation
9. Related support and frequency-based activities.
Key Areas of Responsibility:
Implementation and support:
10. Databases in Microsoft SQL Server including OLAP-based reporting.
11. Lifecycle management of SQL objects including queries, views, functions, triggers, and stored procedures
12. Business reporting in Excel and SSRS
13. Application databases and associated reporting
14. Maintenance and development of OLAP reporting and data warehouse and related ETL routines (SSIS / SSAS)
15. Work with the business ensuring all reporting and database needs are met.
Frequency-based tasks:
16. Database administration including data growth management, backups, indexing, performance tuning etc
17. Contribution to the execution of month end processing, systems maintenance, and related reporting
18. Contribution to related support.
Essential Qualifications, experience and competencies
19. Computing Science degree or equivalent experience
20. Significant experience delivering database and reporting solutions using MS SQL Server technologies
21. Experience working within an environment requiring a high level of standards compliance and procedural control including related ownership, accountability, and responsibility
22. Implementation and maintenance of data warehouses and business reporting / intelligence solutions
23. Strong interpersonal skills with the ability to build rapport within Hydrasun
24. Ability to convey appropriate technical detail at all levels
25. Microsoft SQL Server database development & administration (SSAS, SSIS, SSRS, SQL Server Agent Jobs, maintenance, backup, performance tuning)
26. Advanced T-SQL (Schema & query design, views, functions, stored procedures)
27. Excellent written and verbal communication skills
28. SQL development best-practice, coding standard, and source / version control. This includes monitoring and ensuring compliance to such standards
29. Documentation and Issue tracking
30. Change control including documentation / definition, proposal, review, and deployment to production.
Desireable Qualifications, experience and competencies
31. Relevant certification
32. Experience of manufacturing, distribution, and sales IT
33. Delivery of database and reporting solutions in an ERP environment
34. Coaching, mentoring and development of co-workers in the areas of database and reporting technologies and solutions
35. Experience with SQL Server 2019 and 2022
36. Implementation of OLAP-based reporting solutions (SSAS Tabular Model)
37. Excel / MS-Query / VBA development
38. GIT source control.