Role description:
As a Data Migration Consultant, your role will be to work with our customers to define our Data Migration approach on our Membership solution projects. Your particular focus will be working with the customer to deliver transformed customer data to their new membership system in a timely and efficient manner. You will be involved in the full life cycle of the Silverbear implementation project from requirement gathering, data integration to go-live and everything in-between.
Our Data Migration Consultants are enthusiastic, creative, flexible and motivated team players who can demonstrate ability to interpret business requirements into technical solution. As a member of this project team, you will be experienced in migrating significant data sets from multiple source systems to a single reference system. You will have an understanding of business data, where it can be held, how it can be found and how it can be migrated whether that is on a SQL Server, Oracle database, or smaller databases/spreadsheets.
Communication and collaboration skills are critical to the role, with the use of interpersonal skills to encourage an on-going dialogue with customers and internal stakeholders throughout the project life-cycle. These skills will be key to defining the scope, risk, dependencies and constraints of the project.
Key Responsibilities:
- Close collaboration and communication with our clients and the project team throughout the lifecycle of a project in order to define and deliver successful data migration. Being able to identify, breakdown, and communicate potential issues to all parties involved is critical to the success of a project.
- High level analysis of the client’s existing data and business processes during a discovery process to define the scope of the project, and define a plan for the migration to ensure all data is correctly migrated, and allow for seamless business continuity during project implementation.
- Technical analysis of the client’s data to understand the complexities of the data, their requirements and the data outcomes required to achieve that.
- Manipulation and mapping of the source data to our membership product as part of the ETL process, through the use of complex SQL, SSIS, and C#. This custom development is a significant part of this role.
- Ongoing reflection on the processes being used and how they may best be improved, both at the individual project level and at a team process/best practices level.
- Providing guidance and support to business stakeholders and technical teams on data migration best practices and processes.
- Creating and maintaining documentation of data migration processes and procedures.
- Troubleshooting and resolving data migration issues.
- Data is key for us, and more importantly our customers, a system is only ever as good as its data!!
Required skills, experience, and attributes:
Required (2+ years)
- Skills
- SQL (MSSQL)
- ETL Process
- SSIS
- One of these two:
- MS Dynamics 365
- C#
- Experience
- Strong written and verbal communication skills
- Working directly in customer facing projects
Desirable
- Skills
- MS Dynamics 365
- C#
- .NET Framework 4.5+
- Entity Framework
- Azure power platform
- KingswaySoft’s SSIS Integration Toolkit
- Azure Dev Ops
- Bigger Data set knowledge e.g. SQL Performance tuning etc.
- SSRS
- Experience
- Understanding of Finance and Business-related data structures (e.g. Oracle, Sage, Navision)
- Working with Membership or Charity organisations
- Collaborating as part of a delivery team with a mixed skill set
Performance Metrics / Outcomes
- Successful DM delivery against budget, resource, scope and project timelines
- Identification and successful delivery of DM process improvements
- Execution quality and accuracy
- Client satisfaction
- Mentoring/helping other team members