Data Analyst needed to migrate traditional excel data into a database system

• Participate in data migration activities • Creation of transformation scripts and tasks • Consult with various stakeholders including subject matter experts to understand the source and target data models • Develop a detailed understanding of data models for projects that are part of current and future migrations • Execute data extraction, cleansing and loading from various systems. • Adhere to company and best practice security standards • Participate in data quality and reconciliation activities Skills and experience • Experience with analyzing data models in both source and target system landscapes and defining appropriate mappings and transformations necessary to successfully migrate the relevant data • First-hand experience working on medium to large scale data migration projects • Hands on experience with migration tools such as SSIS • Expertise in Excel, Microsoft Access/SQL, and the use of APIs •Experience with testing, reconciliation and troubleshooting data lineage issues • Expert knowledge and experience in executing data projects and various data migration techniques and approaches • Experience and understanding of cloud services and applications • Demonstrated experience working in Agile delivery teams. • Demonstrated experience liaising with subject matter experts, understanding of business processes and developing source and target reconciliation reports to enable the business to reconcile migrated data • Excellent problem-solving skills with an ability quickly breakdown problems and find innovative solutions. • Exhibit strong emotional intelligence skills. • Excellent verbal and written communication skills. • Strong analytical skills with the ability to identify, analyze and document data quality issues and facilitate / coordinate the resolution of these issues. • Solid experience specifying ETL source to target mappings, transformations, and reconciliation / validation rules.