SQL Developer (Reporting Developer) – Broadcasting – London

Development

SQL Developer (Reporting Developer) – Broadcasting – SSRS 2016, SQL server 2014, Agile, Agile, CI/CD – London

Length: 1-year contract

Rate: £500 – £600 per day

I am currently working with a Global Broadcasting business based in London who are currently looking to hire an exceptional SQL developer who has exceptional reporting skills for a new long-term project.

The SQL Developer (Reporting Developer) will join the 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.

Responsibilities: SQL Developer (Reporting Developer) – Broadcasting – SSRS 2016, SQL server 2014, Agile, Agile, CI/CD – London

  • Working to complete a major transformation project to develop SSRS reports with data warehouse supporting major Commercial system changes.
  • Designing, developing, implementing and maintaining a set of reports using SQL Server
  • Reporting Services (SSRS 2016) against data warehouse views and cubes. The reports will be rendered in HTML, PDF and Excel.
  • Designing Excel 2016 templates to handle SSRS output and possibly coding in VBA to support end-user manipulation of the Excel data.
  • 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.
  • Working with our established pattern for report development including parameter handling and calling stored procedures on the data warehouse.
  • Designing the layout of reports and spreadsheet and determine the best way to present data to end users.
  • Creating and maintaining support documentation and wikis
  • Preparation of test plans, test cases and test scripts for the testing of software component(s), to company guidelines and standards.
  • Providing technical support on the ATS SSRS reports by responding to queries regarding errors, problems, technical questions and new work requests
  • Providing training to users and technical support staff as required

Technical skills required: SQL Developer (Reporting Developer) – Broadcasting – SSRS 2016, SQL server 2014, Agile, Agile, CI/CD – London

  • Required: SQL Server 2014 or 2016
  • Required: Experience of writing reports using SSRS and writing SQL to query data from data warehouse views and stored procedures.
  • Required: Experience of developing robust end-user Excel spreadsheets to manipulate data

including pivot tables, macros and coding in VBA.

  • Required: Evidence of data base design with data modelling skills, entity relationships, efficient and correct use of keys, indexes, foreign keys, normalisation and normal forms.
  • Required: Evidence of significant writing of optimised, performant SQL either as part of a data tier application such as a data warehouse, or to support a major application. This will include stored procedures, functions, views.
  • Required: Working with Kimball design methodology, snowflake and star schemas.
  • Required: Extensive use of Integration Services (SSIS) as part of a data warehouse or similar to manage the processing of data.
  • Required: Evidence of debugging existing code and tracing data problems.
  • Required: Evidence of refactoring for performance tuning and other optimisations.
  • Nice to have: Use of Enterprise Edition features of SQL Server
  • Nice to have: Experience of Analysis Service (SSAS), design, set up and configuration of cubes, both tabular and multi-dimensional.
  • Nice to have: Working in an Agile team (formal meaning), sharing work around, picking up “tickets” to work on, pair programming.
  • Nice to have: Experience of source code control, writing automated tests, Continuous Integration and Deployment techniques. This may include Redgate SQL Source Control and ReadyRoll tools

Please do send across to me the most up to date copy of your CV to eobiechefu@welovesalt.com.

Due to high calls levels on this, I may not be able to take your phone calls.

Job Reference: 9736273213

Salary:

Salary per: Annum

Job Duration: 1 year

Job Start Date: ASAP

Job Type:

Job Location:

Job Industry:

Apply Now

Here are some related jobs

Development

ETL Developer

A Global Leading Company is currently recruiting for an ETL Developer that has experience with SQL Server, Oracle, Informatica, ETL, Data Analyst and bug fix work. Working from home. £55,000…

£19 - £55000 per annum + Benefits
Development

Java Developer

Contract - Java Developer Duration - 3 Months initial Location - City of London My client are a global bank based in the city at their brand new offices and…

£300 - £350 per annum
Development

Senior Java Developer / Engineer – Java 8 – Digital

Senior / Lead Java Developer - java 8, agile, core java, j2ee, spring, maven, tdd, git My client is a leading digital broadcaster. They are a technology agnostic which means…

£55000 - £80000 per annum + bonus and benefits
×
UK

Upload your CV

Upload your CV and one of our consultants will be in touch with you as soon as possible.






Please let us know where you are, or where you would like to be in the world so we can point you in the right direction.




Cookie Consent×

Salt uses cookies to improve the user experience of our site. Cookies allow you to have a more enhanced journey through the site when searching for a specific job or location. They also allow for social sharing through Facebook, Twitter and LinkedIn. Whose doesn’t like cookies? Unfortunately it’s not those kind of cookies we are referring to but they are there to help us understand how our site is being used and give you a better service. You can find out more about how Salt uses cookies here. By continuing to use the Salt site you are consenting to use our cookies.

OK