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