ETL Developer/Data Warehouse Analyst

  • NEC Software Solutions
  • Remote
  • Sep 12, 2022
Full time Data Analysis/ Management Databases

Job Description

Company Description

  • NEC Software Solutions is headquartered in the UK and operates around the world.
  • We employ more than 3,000 people in six countries, building software and services to get our customers better outcomes.
  • We traded as Northgate Public Services until 1 July 2021 when we rebranded to align with our owners, NEC. Most of our subsidiary companies did too (APD Communications, i2N, EMIS Care and Charter Systems) but our service design agency still trades as Snook.
  • We’ve been part of global tech company NEC Corporation since January 2018.
  • Find out more about our business on the Corporate Responsibility and Performance pages.

Job Description

You might think you know about NEC (previously Northgate Public Services) and our housing management platform, NEC Housing, but don’t be so sure! Since 2018 we’ve invested over £30m in NEC Housing and we’re continuing to invest over £6m each year to make sure it’s the best in the sector. As a result of its transformation we’re seeing it consistently selected by housing providers as the housing management platform of choice.

We are looking for candidates that have experience in designing and building data warehouses or have strong PL/SQL or ETL knowledge and would like to get more hands on in the design of the solution. If you have good analysis skills in understanding complex database table structures and have designed data extracts or data warehouses we would like to speak to you.

Our Business Intelligence Consultants work as part of the Business Insights team - and they provide expert knowledge around BI Solutions for the NEC Housing Product. They get involved at all stages of the product life cycle, including pre-sales activity, customer support, development projects and consultancy days. Although initially focussing on the Warehouse design and ETL development it really is an opportunity to get involved in the full end to end development cycle of Business Intelligence projects.

The Housing Business Intelligence Roadmap contains a number of levels of reporting. Our BI Team has the responsibility to support and develop this roadmap. Items include:

  • Data Science
  • KPI Dashboards
  • Operational Dashboards
  • Data Warehouse
  • Ad-hoc reporting
  • Customer Bespoke Development.

Qualifications

As you can see, our BI Consultants get involved in all sorts, but here are a few of the more technical responsibilities - if you have experience with any of the below we would certainly like to hear from you!:

  • Wherescape RED Data Warehouse ETL Development
  • Oracle PL/SQL
  • Data Warehouse Design
  • Experience and Understanding of the Business Intelligence Lifecycle - hands on experience
  • Experience of working within the UK Housing and/or Local Government sector.

The below skills are definitely things we can train and upskill you on, but it would be great if you had any of the following:

  • Power BI Report Writing
  • Oracle Advanced Analytics (R and/or Python)
  • Knowledge or experience with NEC Housing.
  • Jaspersoft Studio Report Development
  • Jaspersoft Server Configuration

Additional Information

We pride ourselves in offering an excellent benefits package, including an above average pension scheme. When you join the team at NEC Software Solutions, you are provided with the following:

  • Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost) 
  • 25 days paid holiday with the option to buy/sell 
  • 4 x basic salary life assurance cover funded by NEC (with the option to increase cover at an additional cost)
  • A Group Pension Plan with fantastic employer contributions up to a maximum of 8.5%
  • A selection of flexible benefits to suit your individual needs 

Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required.

All offers are subject to satisfactory vetting and reference checks. 

NEC Software Solutions is an equal opportunities employer, welcoming applications from all communities.

Application Deadline

Aug 08, 2022