Senior SSRS Developer in City of London, London

Our client

In just over 15 years, our client has grown to over 100 people, with offices in UK, Bulgaria and India. We have become a Microsoft Gold Partner, as well as holding Microsoft Analytics Advanced Specialisation.

We're a Data Analytics Consultancy that works with our clients to deliver information solutions, to help make better informed business decisions. Our integral approach within our team and our clients has led us to be most admired for our people, culture and innovation. We're busier than ever and are growing - it's an exciting time to join us.

But more than anything else, we are a people-first business with a close-knit team and a culture that people really love; and, importantly, a career model that lets you take control of your development and progression.

SUMMARY:

We are looking for an experienced Microsoft-stack reporting and analytics developer, focusing primarily on SSRS (reporting) and SSIS (integration). Experience with migrations to the Azure cloud data platform stack and Power BI is a bonus, as this role will ideally have a part in migrating clients to our cloud data platform stack.

Day to day work of the Senior SQL Server Reporting Services Developer will focus on designing, developing, and maintaining complex reports and dashboards using SQL Server Reporting Services (SSRS), and the maintenance and development of complex SSIS ETL functions to support the ingestion and loading of client Data Warehouses.

The role will also involve close cooperation with business users and clients, to gather and refine requirements, analyse data, and create visually appealing and informative reports to support business decision-making.

Responsibilities:

• Design, develop, and maintain complex reports and dashboards using SSRS
• Gather and analyse business requirements and data to create visually appealing and informative reports
• Collaborate with business and technical users to ensure reports meet their needs and expectations
• Troubleshoot and resolve report issues and performance issues
• Optimize report performance and ensure data accuracy
• Create and maintain documentation for all reports and dashboards
• Stay current with new features and best practices in SSRS and related technologies
• Design, develop and maintain ETL processes using SSIS
• Work closely with the development team to ensure that all data is accurate, timely and consistent
• Performance tuning and optimization of SSIS packages
• Elicit and refine reporting requirements from business users, and ensure reports are delivered to a high standard from conception to production.
• Work with delivery and consulting teams to provide analysis and insight on report design and function, to support transition from SSRS to modern reporting tools (Power BI / Tableau etc).

Requirements:

• 5+ years of experience in SQL Server Reporting Services (SSRS) development
• Excellent client-facing communication and collaboration skills
• Strong knowledge of SQL Server, T-SQL, and data warehousing concepts
• Experience with report design and development using SSRS
• Strong understanding of data visualization and design principles
• Experience with performance tuning and optimization of reports
• Experience with ETL tools such as SSIS
• Strong problem-solving skills and ability to work well in a fast-paced client-facing environment
• Strong experience of a continuous development environment (e.g. Azure DevOps), with focus on build- and release-pipelines, best-practise Dev/Test/UAT/Production environment separation, and QA processes.

Nice to have:

• Experience with Azure (from VM's to cloud data platform)
• Experience with DAX, Power BI or other Business Intelligence tools
• Experience in healthcare or financial industry
• Experience with Agile (scrum) and iterative development and delivery

Disclaimer:

This vacancy is being advertised by either Advanced Resource Managers Limited, Advanced Resource Managers IT Limited or Advanced Resource Managers Engineering Limited ("ARM"). ARM is a specialist talent acquisition and management consultancy. We provide technical contingency recruitment and a portfolio of more complex resource solutions. Our specialist recruitment divisions cover the entire technical arena, including some of the most economically and strategically important industries in the UK and the world today. We will never send your CV without your permission.