Data Engineer

Senior Data Migration Engineer

Software Guidance & Assistance, Inc., (SGA), is searching for a Senior Data Migration Engineer for a contract assignment with one of our premier Insurance clients in Hartford, CT. We are seeking a Senior Data Migration Engineer to support a strategic Oracle-to-Snowflake data migration program. This role combines hands-on data engineering with business analysis and data analysis responsibilities. The successful candidate will work closely with business stakeholders, data engineers, architects, and reporting teams to understand requirements, analyze existing Oracle-based solutions, identify gaps, and design scalable Snowflake-based solutions. The ideal candidate will have strong technical expertise in SQL, database technologies, data engineering, and Python, along with the ability to gather requirements, perform impact assessments, analyze data, and translate business needs into technical solutions.

Role Focus

• Data Engineering
• Business Analysis / Requirements Gathering
• Data Analysis and Validation
• Automation, AI, and Continuous Improvement

Responsibilities

• Data Migration & Engineering
• Analyze Oracle databases, ETL processes, and reporting solutions to support migration planning.
• Design and implement scalable 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.
• Requirements Gathering & Business Analysis
• Partner with business and technology stakeholders to gather, analyze, and document requirements.
• Perform current-state and future-state analysis.
• Conduct gap analyses between existing Oracle solutions and future-state Snowflake solutions.
• Identify migration risks, dependencies, and potential business impacts.
• Translate business requirements into technical designs, specifications, and engineering tasks.
• Create and maintain functional and technical documentation.
• Data Analysis & Validation
• Analyze data to identify issues, anomalies, trends, and potential business impacts.
• Develop reconciliation processes to validate migration results and data accuracy.
• Investigate and resolve data discrepancies.
• Support user acceptance testing and business validation activities.
• Partner with stakeholders to ensure migrated data meets business and technical requirements.
• Automation & Continuous Improvement
• Identify opportunities to automate manual processes and recurring workflows.
• Develop Python-based automation solutions where appropriate.
• Improve engineering efficiency through reusable frameworks, scripts, and best practices.
• Support implementation of monitoring, alerting, and operational controls.
• Identify opportunities to improve data migration, validation, and operational processes.
• AI & Modern Data Practices
• Utilize AI-enabled tools to improve productivity, documentation, data 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.
• Stay current with emerging technologies and modern data engineering practices.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related discipline.
• 5+ years of experience in data engineering, data warehousing, data migration, analytics engineering, or a related field.
• Strong expertise in SQL development and query optimization.
• Strong understanding of relational database concepts and data modeling.
• Hands-on experience working with relational databases.
• Experience gathering business requirements and translating them into technical solutions.
• Demonstrated experience conducting gap analyses and impact assessments.
• Strong troubleshooting, analytical, and problem-solving skills.
• Excellent communication skills with the ability to work effectively with both technical and business stakeholders.

Preferred Qualifications

• Experience with Snowflake architecture and implementation.
• Experience supporting 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 other enterprise reporting environments.

Desired Characteristics

• Strong systems thinker with the ability to understand end-to-end data flows.
• Comfortable working across both business and technical teams.
• Ability to independently drive initiatives in an ambiguous environment.
• Excellent analytical and critical thinking skills.
• Strong focus on data quality, scalability, and operational excellence.
• Excellent documentation and communication skills.
• Continuous learning mindset with an interest in emerging AI, automation, and data technologies.

By applying for a job with SGA, you agree to allow SGA to process your application for this and future opportunities in accordance with our Privacy Policy. Also, to ensure timely processing, you agree to be contacted by our AI recruiter via email, text, or phone. Message frequency varies and data rates may apply, but you can reply STOP to any SMS message to opt-out of texts and may contact SGA at View email address on click.appcast.io to opt-out of AI communications. The choice not to engage with AI will not adversely impact your consideration for placement. AI is not used to make any hiring determinations. SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at . SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.