Data & Interface Engineer - Data Migration - SSIS - SSRS - Azure - APIs - Insurance - Asset Mngmt
Posted 2 days ago by Nexere Consulting Limited
£550 Per day
Inside
Remote
London, UK
Summary: The Data & Interface Engineer role focuses on delivering a data migration project to transition critical business systems to a new SaaS provider. The position requires immediate availability and the right to work in the UK, with a strong emphasis on data migration, system interfaces, and custom report development using SSIS and SSRS. The role is primarily remote, with a contract duration of three months.
Key Responsibilities:
- Conduct data migration from the current vendor using .csv file formats.
- Analyze and identify data elements for transfer and their mapping to the target system.
- Populate data into Excel templates for loading into the target system.
- Develop batch-based system interfaces with other systems, including Finance Ledger and BACS transfer.
- Extract data from the target system's MS SQL database and format it for transfer to receiving systems.
- Create custom reports using SSRS for end users, with a focus on business data.
- Utilize asset management knowledge to enhance reporting capabilities.
Key Skills:
- SQL
- SSIS
- SSRS
- Data Migration
- Azure
- APIs
- Asset Management knowledge
Salary: £550 per day
City: London
Country: UK
Working Arrangements: remote
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
Data & Interface Engineer - Data Migration - SSIS - SSRS - Azure - APIs - Insurance - Asset Management
MUST BE IMMEDIATELY AVAILABLE AND HAVE THE RIGHT TO WORK IN THE UK
KEY SKILLS - SQL, SSIS, SSRS, Data Migration, Azure
3 Month Initial Contract, 90% remote, To start ASAP
My client, who are leaders in their field are looking for a Data & Interface Engineer to deliver a project to the systems which support a critical part of that business to a new SaaS provider. The scope of that project includes migrating selected data elements to the target system, building a number of interfaces to other systems and developing a number of custom reports using SSRS. These are critical tasks which must be delivered to the right level of quality and within a tolerable timeline.
Key Responsibilities and Experience:
Data Migration
- Data is provided from the current vendor in .csv file format
- Analysis is in progress to identify those elements in scope for transfer and their mapping to the target system
- Data is populated into standard excel based templates for load into the target system
- It is expected that this will be an iterative process, culminating in a final cut over of the latest live data prior to entering into parallel running
System Interfaces
- There are a number of batch-based interfaces between the current system and other systems, such as Finance Ledger, BACS transfer, and other reporting systems
- These are in the process of being fully specified in order to replicate them from the target system
- Data will be extracted from the target system MS SQL database and the resulting file formatted as required, then transferred to the receiving system
Custom Reports
- A number of custom reports will be required to provide business data to end users
- SSRS is available for use over the dedicated MS SQL database upon which the target system is built
- Asset Management knowledge would be ideal.