Data Analyst (BI and SQL)

Data Analyst (BI & SQL)

Up to £50K 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.