SQL Reporting Developer

Arrows Group Professional Ltd
19 Oct 2016
17 Nov 2016
Contract Type
The Role:

The successful candidate will join the client's product development team, responsible for creating and maintaining business critical systems that are used to forecast and predict the value of ad space before booking and tracking the sales of that ad space.

As part of that Product Team, you'll work closely with business customers, while delivering on incremental use cases that give direct business benefit.

Your responsibilities will include:

- Working to complete a major transformation project to develop a single Commercial Airtime Sales data warehouse supporting major Commercial system changes.
- Designing, developing, implementing and maintaining a set of reports using SQL Server Reporting Services (SSRS) against data warehouse views and cubes.
- Working closely with stakeholders to determine reporting requirements, perform analysis to understand the development tasks required, and provide time estimates for delivery.
- Converting specifications into reports and business intelligence models.
- Designing the layout of reports and determine the best way to present data to end users.
- Becoming an expert on Commercial data sets and the business meaning and context.
- Sizing database requirements and hardware platform with a 10 year lifetime view but with the possibility of migrating to the cloud at an earlier stage.
- Designing and evolving warehouse database structures to accommodate changing requirements and to support other development team needs.
- Assisting with the development of ETL packages and custom coding needed to load data warehouse from external data sources
- Creating and maintaining support documentation/wiki
- Providing DBA expertise to internal application development teams
- Preparation of test plans, test cases and test scripts for the testing of software component(s), to company guidelines and standards.
- Providing technical support by responding to queries regarding errors, problems, technical questions and new work requests
- Providing training to users and technical support staff as required

You will need to work well with technical and non-technical team members to deliver the right solutions as a team.

As part of a wider engineering community you'll have the opportunity to draw on support from people working in different areas of the business.

Client is looking for someone who:

- Is experienced in developing with and implementing relational and non-relational DBMSs. This must include Microsoft SQL Server but Oracle, MySQL, ProgreSQL, CouchDB, cloud databases and others are an advantage.
- Has specific knowledge of SQL Server 2012 onwards including Enterprise Editions and performance optimisation features.
- Has knowledge of data warehouse and datamart design and ETL processes
- Has experience of using report writing tools, in particular SSRS, and writing SQL to query data from data warehouse views.
- Is experienced in developing business intelligence models in SSAS using different approaches: Multidimensional, Tabular, and Powerpivot.
- Has experience of developing applications in C# / .NET Framework
- Has knowledge of Continuous Integration techniques and application to database development
- Is experienced with Windows Server 2012R2, PowerShell and managing SQL Server databases in development and live environments.
- Excellent verbal and written communication skills
- Excellent problem solving skills
- Ability to operate under pressure and deliver to demanding deadlines
- Ability to deal credibly with business and technical users at all levels of the organisation
- Strong communication skills and a consultative approach coupled with a "can-do" attitude
- Able to take a user-driven view of the product to ensure delivery meets Clients's ambitions for it
- Knowledgeable about software development, and enjoys maintaining their expertise.