Data Warehouse Developer

Organisation
Seasalt Cornwall
Reference
VAC-2341
Sector
Business & Management, IT & Information Services
Location
Falmouth, Cornwall
Salary Details
Competitive
Closing Date
25/10/2017
As data warehouse developer you’ll be responsible for developing and maintaining data warehouse and analytics architecture to meet the current and future reporting and analysis needs of the business.

Job Description

combined_2

You’ll also develop ETL scripts/routines to facilitate the smooth movement of data across the businesses’ full analytics architecture and develop reports using SQL and Excel.

This is a new role within the team offering an excellent opportunity to develop a career within a business systems and intelligence environment, playing a key role in using analytics to influence decision making.

Key responsibilities 

  • Support the translation and integration of reporting requirements into the analytics architecture by working closely with the Senior Data Warehouse (DWH) Developer
  • Assist with the production of DWH, OLAP Cube and ETL functional and technical specifications for development within agreed Programme of Work
  • Create, update and enhance the DWH, OLAP Cubes and analytics architecture to meet current and future reporting and analysis needs
  • Support with the design and implementation of ETL procedures for intake of data from both internal and external sources, ensuring data exceptions/rejections are identified
  • Enable the data team and analysts to query data quickly and efficiently via Excel (OLAP) connectivity
  • For each agreed report, accurately document the requirements in a standard format and agree appropriate reporting tools & delivery formats/timings with the end user
  • Design and create SQL/SSRS reports using Visual Studio reporting services (utilising X++ to ensure all AX reports compatible with Dynamics AX security) and MS Excel Power Pivot
  • Support the users of the reports, ensuring that documentation and training is delivered, working with them to resolve problems and offer solutions where necessary
  • Quality test reports, validate and document outcomes prior to releasing to users
  • Contribute to the upkeep of  the data dictionary/data catalogue and enforce its usage across the business
  • Create processes/tools to aid with the automation of manual data processes and optimisation of user queries
  • Create processes and tools to aid with the cleansing, testing & validation of data within the data model
  • Carry out monitoring, tuning and database performance analysis to aid with system stability

What we’re looking for

You’ll need experience in developing, tuning and maintaining SQL Server database code (SSAS, SSMS) as well as an understanding of relational and multidimensional database design structures. You’ll also have strong report writing experience and be an advanced Excel user.

An excellent communicator and problem solver, you’ll have the ability to work with end users to identify solutions and lessons learnt. We’re also looking for a solid team player, flexible, adaptable and proactive.

Company Description

Many businesses may say it, but at Seasalt our customers truly are right at the heart of everything we do. We promise to never disappoint our customers; we recognise that they are the most important people in our business. Seasalt customers recognise value and it’s our quality that’s made us famous, this won’t change….ever! You can find our products in over 40 shops around England and Wales, or at 350 stockists around the UK, including select John Lewis and Fenwick stores.

Being a Cornish success story is something we're very proud of. Our headquarters are located in our design studio overlooking Falmouth Bay to St Anthony's lighthouse and every day we're inspired to design garments that speak about the place in which we live. Our team includes a diverse range of talent, including graphic designers and fine artists, accountants and logistics experts, textile designers and pattern cutters. 

Other Application Details

In return we offer:

  • Generous Seasalt discount
  • Contributory pension
  • Seasalt Lifestyle – exclusive employee discounts and offers
  • Life assurance
  • Long service enhanced benefits
  • Childcare vouchers
  • Weekly yoga classes
  • Remote medical support
  • Partnerships with local wellbeing centres 

Register  |  Login

European Union - European Regional Development Fund