SQL Analyst
Up to £45K plus benefits
Birmingham
Role Summary
We are seeking a skilled and motivated SQL Analyst. In this role, you will play a vital part in analysing, creating, implementing, and maintaining data infrastructure, ensuring the seamless operation of corporate IT systems. This is a unique opportunity to contribute to our journey of innovation, efficiency, and customer excellence.
Core Duties
- Design, implement, and maintain on-prem and cloud data infrastructure to support IT services.
- Administer corporate databases, including maintenance, upgrades, and monitoring for resilience and efficiency.
- Develop and implement data pipelines for data warehousing and analytics requirements.
- Perform database administration tasks such as user management, backups, and transaction log management.
- Engage with end-user departments to gather analytics requirements and deliver tailored BI solutions.
- Streamline business processes by creating system interfaces and automation using APIs and web services.
Experience Required
- In-depth knowledge of Microsoft SQL Server (2017 and above), including SSMS, SSRS, SSAS, SSIS, and SQL scripting.
- Expertise in database development, data cubes, and data marts.
- Proficiency with data visualisation tools like Power BI, Tableau, or SAP BusinessObjects.
- Familiarity with cloud data services such as Azure SQL or AWS Redshift.
- Understanding of IT networking technologies (e.g., DNS, DHCP).
- Strong experience in IT, specifically in database administration and data solutions.