Data Analyst needed to migrate traditional excel data into a database system
Budget: $30 – $250 USD
• 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.
• 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.