ETL Warehouse Developer

Recruiter
Elevate Credit
Location
London (Greater)
Posted
13 Nov 2017
Closes
16 Nov 2017
Contract Type
Permanent
Hours
Full Time


The ideal candidate will have proven experience in delivering SQL Development (including ETL and Data Integration) solutions within the Financial Services and has knowledge of the full Software Development Lifecycle from reading and translating BRs into functional specifications, to the design, build and testing phase and will have delivered the development of Data Interfaces and Data Take On processes Development of Data Warehouse structures through SQL 2014.

•Design, develop, test and implement logic to extract, transform & load data from transactional applications into the DW using SQL and SSIS.

•Help end users understand and query data to accomplish their business purposes

•Partner with Database and Middleware Administrators to achieve great application performance

What experience, skills, qualities or qualifications are we looking for?

•Experience in data modelling, data profiling and ETL tools and software

•Experience building data warehouses as the support for BI presentation tools: SSRS, SQL. SAS and Tableau.

•Experience with designing physical database, data warehouse methodologies, Entity Relationship Modelling / UML and data modelling tools, like Power Designer, ER Win and Rational

•Ability to develop data dictionary, establish meta-data models and data modelling patterns

•Fluent in SQL ad-hoc queries and procedures

•Execute hands-on ETL and BI development delivery tasks, specifically; ETL job development, technical data model design, and universe development

•Ensure data accuracy by thoroughly testing business uses cases for new or changed data marts and ETL processes

•Operationally support and administer ETL components of development and production data warehouse reporting environments

•Utilize dimensional database and data warehouse design skills to create effective models for efficient and robust historical and real-time reporting

•Assist in the evaluation and selection of data warehouse and business intelligence toolsets

•Assist with general EDW database maintenance tasks activities as required

•Develop and maintain ETL, data model, and reporting standards

•Effectively communicate on development and operational support work status and priority setting

•Assist with setting the strategy for and implementation of data modelling work, such as enterprise logical models, conformed dimensions, and data security

•This role may have access to financial and other company confidential data, and as such those working in this role must understand and comply with the Data Use, Information Security, and any other applicable company policies.

•ETL software

•Microsoft SQL Server

•Microsoft SQL Reporting and OLAP Services

•Microsoft SQL Integration Services

•Have a strong understanding of business intelligence, ETL, and data warehouse implementation and support concepts, and technologies.

•Reporting meta-data management

•Creation and manipulation of large data warehouse and data marts

•Relational data modelling

•Dimensional data modelling using the Kimball methodology

•Be willing to learn and support new technologies

•Have strong problem solving, organizational, and decision-making skills

•Have strong communication and interpersonal skills

•Be detail oriented with excellent follow through

•Work well in a team environment

Benefits

Elevate provides a vibrant, happy and healthy working environment. We offer free food, drinks and healthy snack options to keep you going throughout the day.

The company culture and office atmosphere is friendly and informal - we are hard-working and take it seriously and we like to have fun too. There are excellent opportunities for career development and internal progression.

As well as competitive salaries, company bonus potential and generous holiday, we have a flexible benefits package which can offer you a range of core, health, wealth and lifestyle options such as company pension, life assurance and income protection, private medical and dental insurance, gym memberships and much more!

CLOSING DATE: 24th November 2017


This job was originally posted as www.cwjobs.co.uk/job/77295437