FTC 12 months
Take a lead role within the Data Warehouse tower within MSAmlin. The role will involve the support of all Data Analysis for the Data Warehouse and ETL solutions to support projects and small change within the suite of Data Warehouse applications and be the Lead within the team.
The role will be engaged in the investigation, evaluation, interpretation and classification of data, in order to define and clarify information structures which describe the relationships between real world entities. Such structures facilitate the development of software systems, links between systems or retrieval activities. They will investigate corporate data requirements, and apply data analysis, data modelling and quality assurance techniques, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). They will provide advice and guidance to database designers and others using the data structures and associated components.
There will be a level of Data Analysis support activity during the development, testing, release and warranty phases of any project and work packages. There will also be an element of support activities for user enquiries and other identified issues that arise within Data Warehouse and ETL environments as required.
The role will work closely with the Datawarehouse Development and Support Managers to ensure that all data solutions are implemented with data quality in mind. The role will also interface directly with the Enterprise Data Architects and the CTO team
Provide consultancy and development estimates with Key assumptions as part of evaluating work packages in support of projects relating to data deliverables and overall project or BAU deliverables
4. The Operating Environment and Context of the Job
Ownership of assigned project work packages and delivery as per schedule agreed with Tower Lead.
Where appropriate to operate as technical lead on a project in support of other less experienced members of the team.
The role is based in London or Chelmsford but covers all aspects of Data Analysis work across the organisation so there will be the requirement to occasionally work from other locations as necessary.
5. Key Competencies:
Ability to work to quality standards and in a structured environment
Ability to work to tight deadlines and under pressure
Data Warehouse - Data Design
Work as part of a team
SQL skills along with full understanding of data design concepts, data modelling, data profiling, Logical Data Model design & adherence, Kimball methodology, quality controlled documentation
Understanding Business Analysis & requirements
Data Analysis Capability
6. Cultural Behaviours:
The behaviours that the job holder must exhibit for desired cultural fit.
Places all our internal and external clients at the centre of decision making; develops propositions that are fair, relevant and useful
Thinks about future possibilities and outcomes that can shape success in original ways
Provides opportunities and support for colleagues to grow and succeed
Able to work as ‘one team’ to gain commitment and results to ensure success for all
Acts with integrity to deliver on commitments, ensuring the same for others
Ambitious and disciplined in setting and achieving goals
7. Key Interfaces: