Accept Cookies? YES
This website uses cookies to store non-personal data in order to function properly.
Privacy laws effective from May 2012 mean that you need to confirm your consent
for us to store a cookie. You can find out more about cookies here.

Search Jobs

Latest News

Event: Back to work.... after time out?

Eduserv, a not for profit IT services provider based in Bath, are hosting a FREE event in collaboration with Women In Technology to support women back to work following maternity leave or a period ..

Read more

Mother IT Saga

When it comes to work and careers, women are the same as men… Almost. 1)      Are we Ambitious? We want to reach the top don’t we Theresa, Angela and Hilla..

Read more

Exercise and the Pub: The Secret to Equality in the Workplace

Some new ideas are helping IT company MirrorSphere buck the trend when it comes to female representation in the technology industry. The Oxfordshire-based business boasts a female directo..

Read more

Inspiring Women in Tech – Alex Depledge

At Baltic, we are passionate about getting Girls into IT. So much so, we invited some of our country’s truly inspiring leading ladies to answer a few of our questions and give an insight into..

Read more

Ladies & Gentlemen of the Board

Infographic                                 ..

Read more

Technology in the Workplace

In today’s modern world, technology is constantly involved in our daily lives, from the moment our cellphone wake us up through a previously set up alarm, until we fall asleep on a meticulous..

Read more

Spotlight Audit Analytics - ETL Developer

Reference  
139389
Location  
Category  
Type  
Permanent
Salary  
Competitive
Salary Frequency  
Annum

What impact will you make? The Opportunity

 

This is your opportunity to join the team which is responsible for the direction, development and support of Deloitte’s Global Audit Analytics platform, a patented and award-winning platform supporting thousands of users and clients.

 

To apply for this role please click here 

 

Role description

 

The team is structured across the UK, India, and five other countries. It is currently undergoing expansion and is looking for a number of developers globally with the appetite to learn and a flair for problem solving.

 

The technology is based around a set of large Microsoft SQL 2012 servers, which hold thousands of databases relating to different clients but with exactly the same data schema. There is a requirement for junior and senior ETL developers who will develop using SSIS to facilitate the extract, transform, and load of data into warehouse from a number of sources (including common financial systems such as SAP, Oracle, Microsoft Dynamics etc).

 

The ETL Developer will be an experienced developer with an ability to take ownership and drive projects to completion.

 

Location

 

You will be based onsite in the Deloitte Cardiff office, home of our key nearshore delivery centre which contributes towards supporting our clients, our services and our business as a whole.

 

Hours

 

This is a permanent role. We do encourage careful consideration of agile ways of working, both formal and informal arrangements that allow for the best outcomes for our people and our clients. If this opportunity is interesting as a permanent role with a degree of flexibility please do discuss with us.

 

Responsibilities

 

Typical tasks will include:

  • Understanding and specifying source data requirements from various ERP systems, working with the content development teams as part of their implementation projects
  • Providing input to the content development teams around data warehouse schema design
  • Implementing SSIS packages to perform data transforms, typically these will include using the following SSIS components such as Lookup, Merge, Sort, Conditional Split, Derived Columns, Aggregates & Pivots, and Custom .NET scripts
  • Creating T-SQL scripts to identify issues with source data (such as duplicate rows, invalid data types etc…)
  • Undertaking quality reviews of packages produced by other team members
  • Performance tuning new and existing packages
  • Investigating data load errors and issues through to resolution
  • Maintaining appropriate documentation and test evidence to support the ongoing availability and compliance of the overall platform
  • Working effectively in diverse teams within an inclusive team culture where people are recognised for their contribution

 

Requirements

 

Essential

  • Proven ability to apply logical and analytical thinking skills to solve complex, technical problems
  • Strong written and spoken English communication, ability to clearly describe issues and propose solutions
  • Good level of skill working with MS SQL and building SQL scripts.
  • Experience building and debugging SSIS packages and using the BIDS suite
  • Knowledge of common data load challenges and issues
  • Experience transforming transactional data structures into OLAP data structures (including consideration of SSIS performance implications)
  • Understanding of different types of dimensional modelling typically used in data warehousing

Desirable

  • Any experience working with transactional financial data or common ERP platforms would be beneficial but not required

 

You are here: Audit

 

We understand our clients' operations, their industry and the issues they face. We understand an audit is not about looking back, but about helping those businesses to plan for a successful future. Together with our team you will build on our distinctive combination of specialist skills, pioneering technology, industry expertise and on-going investment to grow our business and continue to improve the market-defining services we offer.

 

Our Practice offers a wide ranging and challenging number of business areas in which to develop your career. These comprise business assurance within our Corporate Groups, Public Sector and Financial Services Audit groups, and advisory specialisms including Treasury Advisory, Risk Analytics and Technology Consulting.

 

As one of the largest audit practices, joining us will mean working with some of the leading practitioners in the industry, for some of the leading organisations in the world and towards a career goal that is entirely yours to shape.

 

To apply for this role please click here

 

About Deloitte

 

Our Purpose & Strategy

To make an impact that matters for our clients, our people and society - defines who we are and what we stand for. Our purpose provides the foundation for our strategy and our aspiration to be the undisputed leader in professional services: this is not about size, it's about being the first choice. The first choice for the largest and most influential clients, and the first choice for the best talent.

How will this role make an impact that matters with Deloitte?

As typical with our business, the team will work in a highly agile and flexible way, supporting a diverse range of client, business and technical requirements.

 

What do we do?

 

Deloitte offers Global integrated professional services that include Audit and Risk Advisory, Tax, Consulting and Financial Advisory. Our approach combines intellectual leadership, industrial expertise, insight, consulting & problem solving capabilities, technology revolutions and innovation from multiple disciplines to help our clients excel anywhere in the world.

 

What do we value?          

         

At Deloitte we foster a collaborative culture where talented individuals can produce their best work. We value innovative thinking, diverse insights and a genuinely distinctive level of customer service.  We value difference, with respect at the heart of our inclusive culture, and we support agile working arrangements. Hear from some of our people already working at Deloitte in agile ways. We are proud to have received a Best for All Stages of Motherhood special award in 2016 as a Top Employer for Working Families.

 

Your application – what to expect

 

To be considered for this role follow the link to complete our online application form.  We will call you to find out more about you and then if we think we’re the right place for you, we’ll invite you in to meet us face to face - it’s a great chance for us to learn more about each other.

 

It’s your career. Where will it take you?

 

To apply for this role please click here

 

Deloitte LLP is a limited liability partnership registered in England and Wales with registered number OC303675 and registered office at 2 New Street Square, London, EC4A 3BZ. Deloitte LLP is the United Kingdom affiliate of Deloitte NWE LLP, a member firm of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”), its network of member firms, and their related entities. DTTL and each of its member firms are legally separate and independent entities.

 

Requisition code: 139389