[Remote] Data Migration Consultant
Note: The job is a remote job and is open to candidates in USA. Albano Systems, Inc. is seeking a Senior Data Migration Engineer to support a strategic Oracle-to-Snowflake migration program. The role combines hands-on data engineering, business analysis, requirements gathering, data validation, automation, and responsible use of AI to deliver scalable data solutions.
Responsibilities
- Analyze Oracle databases, ETL processes, and reporting solutions to support migration planning
- Design and implement Snowflake-based data solutions
- Develop, optimize, and maintain complex SQL queries, views, and data transformation logic
- Build and support ELT pipelines for loading and transforming data within Snowflake
- Participate in data modeling, data integration, and performance optimization activities
- Support testing, reconciliation, and validation of migrated data assets
- Assist with data quality assessments and remediation efforts
- Partner with business and technology stakeholders to gather and document requirements
- Perform current-state and future-state analysis
- Conduct gap analyses between Oracle and Snowflake solutions
- Identify migration risks, dependencies, and business impacts
- Translate business requirements into technical designs and engineering tasks
- Create functional and technical documentation
- Analyze data to identify issues, anomalies, trends, and business impacts
- Develop reconciliation processes to validate migration results
- Investigate and resolve data discrepancies
- Support user acceptance testing and business validation activities
- Identify opportunities to automate manual processes and recurring workflows
- Develop Python-based automation solutions where appropriate
- Improve efficiency through reusable frameworks, scripts, and engineering best practices
- Support implementation of monitoring, alerting, and operational controls
- Utilize AI-enabled tools to improve productivity, documentation, analysis, and development activities
- Evaluate opportunities to leverage AI within data engineering and business processes
- Promote AI literacy and responsible AI adoption across project teams
Skills
- • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related discipline
- • 5+ years of experience in data engineering, data warehousing, data migration, or analytics engineering
- • Strong expertise in SQL development and query optimization
- • Strong understanding of relational database concepts and data modeling
- • Experience working with databases
- • Experience gathering business requirements and translating them into technical solutions
- • Demonstrated experience conducting gap analyses and impact assessments
- • Strong troubleshooting and problem-solving skills
- • Ability to communicate effectively with both technical and business audiences
- • Strong systems thinker capable of understanding end-to-end data flows
- • Comfortable working between business and technical teams
- • Ability to independently drive ambiguous initiatives
- • Excellent analytical and critical thinking skills
- • Focus on data quality, scalability, and operational excellence
- • Strong documentation and communication skills
- • Continuous learning mindset with interest in emerging AI and automation technologies
- • Experience with Snowflake architecture and implementation
- • Experience with Oracle-to-Snowflake migration initiatives
- • Strong Python programming skills
- • Experience developing ELT/ETL pipelines
- • Familiarity with data quality, metadata management, and data governance practices
- • Experience with workflow automation platforms and process orchestration tools
- • Exposure to cloud-based data platforms and modern data architectures
- • AI literacy and practical experience using AI tools to improve engineering and analytical workflows
- • Experience supporting Tableau, Power BI, or enterprise reporting environments
Company Overview